Display DataReader's Data

[kebele]

I know it is possible to display dataset's data in a label like below but i am just wondering if i could do the same thing for datareader? please help. thanks

Label1.Text = myDataSet.Tables("OneItem").Rows(0).Item("PRROUTE").ToString()

here is my code for datareader

Dim cmd As OracleCommand = New OracleCommand(StrSql, oOracleConn)
dr1 = cmd.ExecuteReader()
gvOneItem.DataSource = dr1

 

[ca8msm]

You'll have to loop through the reader.

faq855-5662


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[kebele]

Thanks for the tip.