VB.net + continue until end of Access database

[mizzy]

Hi there,

I have checked every where for the answer to this question but no joy. Usually this means that the answer is obvious but some help would be appreciated.

I am processing an MSaccess database. I can connect to the database and I am currently processing each record in the database using a button i.e. click on the button to process the next record.

I wish to change the click so that the database is processed until there are no more records in the access database.
I have been trying "While Not EOF" and stuff like that but nothing is working.

How would I do this, continue processing until I have
reached the end of the access database
Many thanks,

 

[younguser]

Many way can do it. Here is datareader drSQL:
strSQL = "SELECT * FROM tblCustomer"
cnSQL = New SqlConnection(ConnectionString)
cnSQL.Open()
cmSQL = New SqlCommand(strSQL, cnSQL)
drSQL = cmSQL.ExecuteReader()

Do While drSQL.Read()
'do something
Loop

 

[mizzy]

Cheers ,
Thanks for the help,
All up and running now.
Regards,