If you are using two select queries and retrieving data. how do you access seco

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

Question Posted / anonymous

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

If you are using two select queries and retrieving data. how do you access second query's resu..

Answer / 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

More ASP.NET Interview Questions

How will you maintain versioning in asp.net 2.0?

0 Answers MCN Solutions,

What are the advantages of asp.net?

0 Answers

What are web beacons used for?

0 Answers

how can i am search the data from database? just like google

2 Answers

How do you secure your configuration files to be accessed remotely by unauthorized users?

0 Answers

Which template must you provide, in order to display data in a Repeater control?

3 Answers Siebel Systems, Wipro,

Define ViewState and how can it be used?

6 Answers Siebel,

What does a switch do?

0 Answers

What are the layouts of ASP.NET Pages?

0 Answers

What is server side session management?

0 Answers

What is difference between viewstate and session in asp net?

0 Answers

What r the asp.net list controls and diff. Between them?

0 Answers

For more ASP.NET Interview Questions Click Here