Can the Sequence of RecordSets in a Multiple RecordSet ADO.Net resultset be determined, controlled?

Posted by Shiva on Stack Overflow See other posts from Stack Overflow or by Shiva
Published on 2010-06-03T17:15:05Z Indexed on 2010/06/05 8:42 UTC
Read the original article Hit count: 215

I am using code similar to this Support / KB article to return multiple recordsets to my C# program.

But I don't want C# code to be dependant on the physical sequence of the recordsets returned, in order to do it's job.

So my question is, "Is there a way to determine which set of records from a multiplerecordset resultset am I currently processing?"

I know I could probably decipher this indirectly by looking for a unique column name or something per resultset, but I think/hope there is a better way.

P.S. I am using Visual Studio 2008 Pro & SQL Server 2008 Express Edition.

© Stack Overflow or respective owner

Related posts about ADO.NET

Related posts about sql-server-2008-express