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.oledb.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