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
5590 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 is a web api endpoint?

0 Answers

How can you achieve nested Masterpages in 2.0?

1 Answers Microsoft,

What is the difference between the asp and asp.net?

0 Answers

What is _viewstart?

0 Answers

What methods are fired during the page load? Init()

0 Answers

how we deploy the asp.net 2.0 application

2 Answers Logistics,

How to disable validator control by client side JavaScript?

0 Answers

What is .net remoting?

0 Answers

Explain how cookies work. Give an example of cookie abuse.

0 Answers

Which data type does the rangevalidator control support?

0 Answers

Write some code using interfaces, virtual methods, and an abstract class`

0 Answers

what are the security certificates used in webservices?

0 Answers

For more ASP.NET Interview Questions Click Here