I have an MS SQL database that I need to query. It has around 10 million rows and I need to be able to create a vb.net loop that will:
1. open the connection to the database,
2. query first/next 1000 rows,
3. close the database
any sample code is greatly appreciated.