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
