C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Resources » Articles » .NET Framework »

Accessing Multiple ResultSets using DataReader


Posted Date: 04 Jul 2004    Resource Type: Articles    Category: .NET Framework
Author: Sathia Murthi N MahalingamMember Level: Bronze    
Rating: 1 out of 5Points: 7




string strMultiSelect = "Select * from Categories; Select * from Product";
// conn is OledbConnection
OledbCommand cmdMultiSelect = new OledbCommand(strMultiSelect,conn)
DataReader drMultiReader = cmdMultiSelect.ExecuteReader()
do
{
while(drMultiReader.Read())
{
// access all the fileds for the first select command
System.Consol.Write(drMultiReader[0]);
}

}
// moving to the next select command or result set in the DataReader
while(drMultiReader.NextResult());




I hope this will help you



Responses


No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks      
Popular Tags   What are tags ?   Search Tags  
Sign In to add tags.
(No tags found.)

Post Feedback


This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.
Next Resource: Using reflection to find a Type and create an instance
Previous Resource: A common function in VB.NET to execute any stored procedure in SQL server 2000
Return to Discussion Resource Index
Post New Resource
Category: .NET Framework


Post resources and earn money!
 
More Resources



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use