DataReader questions

[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

 

[Jon Skeet [C# MVP]]

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?

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

For DataReader, use NextResult().