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
ADO.NET
|sql-server-2008-express
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