Prev: Configuration Manager - missing / cannot find. -Solved
Next: Text box format change
From: bill on 21 Jul 2008 01:17
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


 | 
Pages: 1
Prev: Configuration Manager - missing / cannot find. -Solved
Next: Text box format change