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
5521 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

What are the authentication types in asp.net?

0 Answers

Explain what does mvc represent in asp.net? : asp.net mvc

0 Answers

What is the concept of postback in asp.net?

0 Answers

What are the different ways of processing data in ASP page in the server side (like Forms, QueryStrings etc)?

1 Answers

explain code with datachaching with example

0 Answers

What is the life cycle of web page?

0 Answers

What is the difference between a thread and a process?

3 Answers

What is the difference between c# and .net?

0 Answers

how many select state ments are used in stored procedure?

8 Answers CSC,

What is asp.net localization?

0 Answers

Difference between .NET and previous version?

1 Answers Microsoft,

What is three major points in WCF?

1 Answers Patni,

For more ASP.NET Interview Questions Click Here