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

Are cookies client side or server side?

0 Answers  


What is the caspol.exe tool used for?

0 Answers  


What is the difference between asp.net mvc and asp.net webforms? : asp.net mvc

0 Answers  


Trigger syntax in sql2000

1 Answers   Wipro,


If iam developing an application that must accomodate multiple security levels though secure login and my asp.net web appplication is spanned across three web-servers (using round-robbin load balancing) what would be the best approach to maintain login-in state for the users?

0 Answers  






Explain culture and uiculture values.

0 Answers  


What is cache in asp net?

0 Answers  


What is state management techniques in asp.net?

0 Answers  


What is an application domain ?

2 Answers   Microsoft,


Explain the code Access Security (CAS) in .net Framework?

0 Answers  


What does clearing cache?

0 Answers  


i have one gridview contains edititemtemplate(which contains update and cancel buttons) and i have one item template (contains edit button) i want the code for update and cancelbuttons in edit item template and i want the code for edit button in itemtemplate. please help me

4 Answers  


Categories