Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - how to show the data from a data reader?

Reply
 
Old 07-21-2008   #1 (permalink)
bill


 
 

how to show the data from a data reader?

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

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Retreive wmi data and show it in form label PowerShell
Store data on Data disk always Vista General
KHz sample rate data and other key data fields missing from audio/media file properties view Vista file management
appdata-local-Application Data-Application Data-Application Data infinitum ad nauseum. WHY Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46