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






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 do you manage session in ASP and ASP.NET?

1 Answers   Microsoft,


how can we create wcf in asp.net and how can we cll that in to asp.net application?plsss tel me each step clearly

0 Answers  


Which two properties are there on every validation control?

2 Answers  


what is the role of aspx file ?

2 Answers   Netsweeper,


Tell About Web.config ?

2 Answers   Keane India Ltd,






Is overloading possible in web services?

2 Answers   Microsoft,


main difference between asp.net2.0,asp.net1.1,asp.net1.0

15 Answers   iSoft, Infosys, Microsoft, Inflexion, Prakruthi,


if we establish the cinnection with connection string tag in web.config file,can i go for encrypt and decrypt with that?

1 Answers  


how to integrate Language conversion, without asking the enduser to download font, it should auto integrate

1 Answers  


How do you register the .Net Component or Assembly?

2 Answers   Accenture,


What is Auto-event wireup? what is the default value for this? when u change the value what will happen?

1 Answers   CMC,


How to Open any web page by clicking any Any ASPControl like (Checkbox,radio button or Button) without calling its event and without going to Siverside code?

5 Answers   LG Soft,






Categories