If you are using two select queries and retrieving data. how
do you access second query's result set using data reader?
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
Can more than one person use the same login?
Any one can tell how we store tiff format images in database and retrive from the database(need for tiff format only)
can any one find and tell the difference between dot net and php which one is best ? which one we get more salary? which one is stable and which one is best for freshers and also better in future and carrer ? which one we wil get more salary sir ? please send ur valuable suggestions to kiranpulsar2007@gmail.com
What is virtual directory in asp.net?
What is advantage of code behind coding in ASP.NET?
What is the difference between server-side scripting and client-side scripting?
Where is http session stored?
What are app services?
Define xmlvalidatingreader class.
What is the difference between typeof() vs gettype()?
How many types of cache are there?
Will the asp.net validators run in server side or client side? How do you do client-side validation in .net? How to disable validator control by client side javascript?
When Cookies are expired in ASP.NET?
How do I force the dispose method to be called automatically, as clients can forget to call dispose method?
What is asp net theme?