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

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

Question Posted / uday kumar vuriti

1 Answers
5526 Views
Cap Gemini, Keane India Ltd, MindSquare, I also Faced
E-Mail Answers

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

How to use multiple scriptmanager controls in a web page?

1056

Name the two properties are on every validation control?

946

What is asp.net response object?

1005

How many ways are there to maintain a state in .net? What is view state?

963

Where is asp.net view state stored?

962

How we can force all the validation controls to run?

939

What is web configuration file and how to use in web application

977

Explain the main function of url routing system in asp.net mvc? : asp.net mvc

960

What I need to create and run an asp.net application?

944

How do you declare delegates and are delegates and events one and the same and explain how do you declare delegates and invoke them ?

4148

Explain MVC model binders?

1027

Is it possible to develop a single web application using ASP.NET webforms and ASP.MVC?

1033

What are the asp.net 2.0 features?

975

How is application management and maintenance improved in asp.net 2.0?

964

i want to implement grid view value in paypal site. so how to create this code in asp.net with C#

1879