I am learning VB.NET and I would like to open an access database. With your help, I figured out how to open the database:
Dim SQLStr As String
Dim conn As OleDbConnection
conn = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" & MiBase & "';Persist Security Info=False;")
SQLStr = "SELECT * FROM tblContacts"
My questios are:
1) How do I navigate the record from the SQL code at SQLSTR? In visual basic, I used to do this:
do until rs.eof
How do I do that in VB.NET, with the code I am using above?
2) Is there any way to count the number of records returned by SQLstr?
PS: Sorry for the points, I only have 85 left :)