DataReader questions

  • Thread starter Thread starter Norton
  • Start date Start date
N

Norton

Can a DataReader contain multiple result sets? I know a dataset can but I
haven't seen the same statements regarding a DataReader?

Also, how do you loop through multiple tables in a result set, whether its a
dataset or data reader?

Thanks!

Norton
 
Norton said:
Can a DataReader contain multiple result sets?
Yes.

I know a dataset can but I
haven't seen the same statements regarding a DataReader?

Also, how do you loop through multiple tables in a result set, whether its a
dataset or data reader?
Click to expand...

In a DataSet, use DataSet.Tables, which is a collection of the tables
in the DataSet.

For DataReader, use NextResult().
 
Back
Top