I am trying to retrieve ten fields each from a different column in access 2007 and put them in vb.net labels. I can always mange to get the last record in the table but how can I get 10 records each from different columns?
Thats my code for retrieving one record how can i change it to retrieve ten?Code:Dim objconnection As New OleDbConnection(connection) objconnection.Open() Dim Sql As String = "select * From aa Where bb = 98" Dim objCommand As New OleDbCommand(Sql, objconnection) Dim objReader As OleDbDataReader objReader = objCommand.ExecuteReader If objReader.HasRows Then While objReader.Read Label11.Text = (objReader.GetString(1)) End While End If
Thankss




Reply With Quote