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

Where is asp.net session stored?

931

What is viewstate? What does the “enableviewstate” property do?

915

What is the namespace to create thread in .net?

938

Do you know using sql cache invalidation?

1016

What does session_start () do?

1088

How can we use Web API with ASP.NET Web Form?

1098

Can more than one person use the same login?

969

How many types of state management are there in asp net?

1024

Explain in what order a destructors is called.

1022

What is application state?

905

What is web router?

915

What is asp.net master page?

985

What is in a session cookie?

968

How to use a Master Database in Asp.net?

1057

Difference between response.redirect and server.transfer?

1025