Multiple recordset from a stored procedure

  • Thread starter Thread starter Jon Spivey
  • Start date Start date
J

Jon Spivey

Hi,
using vb.net/sql server 2000 migrating an app from asp to asp.net. I have a
stored procedure that returns 3 recordsets. In asp to move to the next
recordset I'd just do
<%
set rs = rs.nextrecordset
' display data
set rs = rs.nextrecordset
' display data
'etc

Is there an equivalant to this in asp.net? I can get the first recordset
fine just don't know how to move to the 2nd and 3rd

Cheers,
Jon
 
If you are using a DataReader type object, use the NextResult method.
If you are using Fill on a DataSet, all the resultsets will be filled
into DataTables of the DataSet.

HTH,
 
e.g. recordset1 in ds.Tables[0], recordset2 in ds.Tables[1] and so on...

Tiendq,
(e-mail address removed)
 
got it - thanks

Jon

Do Quyet Tien said:
e.g. recordset1 in ds.Tables[0], recordset2 in ds.Tables[1] and so on...

Tiendq,
(e-mail address removed)

Scott Allen said:
If you are using a DataReader type object, use the NextResult method.
If you are using Fill on a DataSet, all the resultsets will be filled
into DataTables of the DataSet.

HTH,
Click to expand...
have
a
Click to expand...
Click to expand...
 
Back
Top