C
Christopher Ambler
I have a stored procedure that one of the DB guys wrote for me. It's going
to return two recordsets in its output.
Normally, I'd use ExecuteReader() and just loop inside of a while
(reader.Read()) loop.
In this case, I need to get the data into a couple of DataSet objects so I
can set properties on them and spew them out as XML (my final output has to
be in XML).
I'm very unsure as to the best way to do this. I don't even see how a
SqlDataReader can get me a DataSet, much less two of them, properly loaded
with the two recordsets coming back.
Or if this is even the best way to get XML out!
Some adult supervision would be very helpful about now
Christopher
to return two recordsets in its output.
Normally, I'd use ExecuteReader() and just loop inside of a while
(reader.Read()) loop.
In this case, I need to get the data into a couple of DataSet objects so I
can set properties on them and spew them out as XML (my final output has to
be in XML).
I'm very unsure as to the best way to do this. I don't even see how a
SqlDataReader can get me a DataSet, much less two of them, properly loaded
with the two recordsets coming back.
Or if this is even the best way to get XML out!
Some adult supervision would be very helpful about now
Christopher