in asp/ado.net. I have a stored procedure that returns two select result sets and I want to be able to access the second select result set by the field name. How is this done?
Just access the collection of Tables in the dataset. The first query will be in 0 and the second in 1 and so on...<BR><BR> oDataSet.Tables.Rows<BR><BR> oDataSet.Tables.Rows
Can I not use a datareader to do this?