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: 197

Filed under:

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

Related posts about ADO.NET

Asp.net ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
RIA Services vs ADO.NET Data Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience… >>> More
Ado.net dataservices BeginExecuteBatch call works on development fails on production server with Obj

as seen on Stack Overflow - Search for 'Stack Overflow'
We have an ado.net dataservices 1.0 call that is being passed to a [WebGet] service operation as a batch through BeginExecuteBatch. Everything works perfectly on our development server - we have the project configured to use IIS instead of the cassini web server to make it as close to our production… >>> More
ADO.Net : Get table definition from SQL server tables

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using C# to write a method that returns the following information about a table: column names, column types, column sizes, foreign keys. Can someone point me in the right direction on how to accomplish this ? >>> More

Related posts about sql-server-2008-express

NAT: Exposing SQL Server 2008 Express to the internet

as seen on Server Fault - Search for 'Server Fault'
Hi, I have a Windows Server 2003 SP2 machine with SQL Server 2008 Express installed. I have my network configured with a NAT. Internal clients can access the instance of SQL Server without a problem. I would like to enable SQL Server to be accessible from anywhere on the the internet. I am not… >>> More
SQL Server 2008 Express + Reporting Services on Windows 7

as seen on Server Fault - Search for 'Server Fault'
I'm trying to install SQL Server Express 2008 and Reporting Services on a x64 Windows 7 Machine for development purposes. I've installed SQL Server 2008 Express with the Microsoft Web Platform Installer I had to manually enable the SQL Server Browser in the Sql Server Configuration Manager and tried… >>> More
SQL Server 2008 Express - "Best" backup solution?

as seen on Server Fault - Search for 'Server Fault'
Hi! What backup solutions would you recommend when using SQL Server 2008 express? I'm pretty new to SQL Server, but as I'm coming from an MySql background i thought of setting up replication on another computer and just take x-copy backups of that server. But unfortanetly replication is not available… >>> More
SQL Server 2008 Restore from Backup fails with error 3241 'cannot process this media family'

as seen on Server Fault - Search for 'Server Fault'
I am attempting to backup a database from a SQL Server instance on one machine and restore it to another, and I am encountering the frequently discovered 'SQL Server cannot process this media family' error. Each of my instances are SQL Server 2008, but with different patch levels Restore: 10.0.2531… >>> More
Migrate database from SQL Server Standard to SQL Server Express for DotNetNuke

as seen on Server Fault - Search for 'Server Fault'
Hello, we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the server and thus have both the Database server and the Web Server on the machine. But: The databases… >>> More