By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,017 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,017 IT Pros & Developers. It's quick & easy.

how to show the data from a data reader?

P: n/a
Can someone please show me what to do with this to show the data in a
dataGrid for example? I'm not really sure what to do with it. I'm used to
Vb6.
Dim Con = New OleDb.OleDbConnection("provider=microsoft.jet.oled b.4.0;" &
"data source=c:\_Archive\Documentation - Projects\Hardware Tracking -
2008\IT_Assets.mdb")

Dim Cmd As New OleDb.OleDbCommand("SELECT * from tblAssets where asset_tag =
@fn", Con)

Cmd.Parameters.Add(New OleDb.OleDbParameter("@fn", OleDb.OleDbType.VarChar,
30)).Value = "A104485"

Try

Con.Open()

Dim Reader As OleDb.OleDbDataReader = Cmd.ExecuteReader()

While Reader.Read()

'Console.WriteLine("{0} - {1}", Reader.GetString(0), Reader.GetString(1))

'Me.lblRecords.Text = "Your search returned " & Reader.FieldCount & "
records."

'Me.DataGridView1.DataSource = reader 'sets the records in the grid to
choose from on tab 1

End While

Reader.Close()

Finally

Con.Close()

End Try

Thank you,

Bill
Jul 21 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.