![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| 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. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | 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 Specs![]() |
![]() |
| 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 | |||