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
What is authentication in asp.net?
What is the difference between mechine.config and web.config?
What do you mean by query string?
How many web.config files can I have in an application?
What would be salary for 8+ years of experience in ASP.NET in different metro city in india?
How many types cache in asp net?
When we use cookie less session? Explain its working?
Explain the Order of events in an asp.net page?
Where is asp.net session stored?
What is the difference between stored procedure vs function?
What is the usage of DelegatingHandler?
How do you design a website with multilingual support in ASP.NET ?
What is the difference between a multi-layer and multi-tier applications?
Which object encapsulates state or data of a user?
What is difference between singleton and single call?