I come from classic asp and am newer to the .net community. I want to use a query to return a recordset and use the results of this recordset to programmatically loop trough it, populate, and execute a stored procedure. Since asp.net does not use a recordset with cursor control per say how does one do this? Code examples are much appreciated!!!

Thanks for the help.

ADO.NET does not use RecordSets but it does have several classes that perform similar functionality. Look into the SqlDataReader class. This is the closest to a cursor type object (like the recordset).

-Peter

Does the DataReader allow steping through the records with an equivalent "movenext", "movefirst", etc?

Thanks for the reply!