Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

If you are using two select queries and retrieving data. how
do you access second query's result set using data reader?

Answer Posted / uday kumar vuriti

If we have 2 select queries as follws
select * from dept
select * from emp

SqlDataReader dr;

//To Read 1st Select query dept
dr.Read();

//To Read 2nd Select query emp
dr.NextResult();

So the answer is dr.NextResult();

Is This Answer Correct ?    27 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is authentication in asp.net?

1080


What is the difference between mechine.config and web.config?

1243


What do you mean by query string?

952


How many web.config files can I have in an application?

998


What would be salary for 8+ years of experience in ASP.NET in different metro city in india?

2484


How many types cache in asp net?

1094


When we use cookie less session? Explain its working?

1043


Explain the Order of events in an asp.net page?

1036


Where is asp.net session stored?

950


What is the difference between stored procedure vs function?

1063


What is the usage of DelegatingHandler?

1095


How do you design a website with multilingual support in ASP.NET ?

1003


What is the difference between a multi-layer and multi-tier applications?

1036


Which object encapsulates state or data of a user?

1079


What is difference between singleton and single call?

1104