Hi
I am trying to duplicate Theoron Willis book written for VB 6.0 and SQL Server 7.0. I have gotten as far as chapter 8 where it wants to use nextrecordset command to read three tables selected from SQL. SQL 2000 won't accept nextrecordset or exec in stored procedure but will accept execute so I need to know how to read the data from sqlreader to put each table into its appropriate listbox, I don't know how to work with recordsets in vb.net. (I don't think vb.net uses recordsets). Any help would be appreciated.
Thank you, John

I am not so clear about your qestions. Make it more specific. I think that Vb.net also use recordset.
Someone might have more ideas...

Pheap

Nextrecordset is a VB command. Don't why you would have trouble with it in SQL 2000 but not 7.0

There is no recordset in ADO.NET but you should be able to get comparable results if you tried sqlReader.NextResult