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
Define authentication and authorization.
What is the good practice to implement validations in aspx page?
What's the difference between viewstate and sessionstate?
How can we communicate with each server in N-tier Architecture? and what are the methods?
What does mean by a neutral culture?
Will the asp.net validators run in server side or client side?
What is application variable in asp.net?
What is difference between cache and session?
What are the new features added from ASP to ASP.NET?
What will happen if the server confugration file and the application confugration file have different values for sassion state ASP.NET?
Define what is razor? : asp.net mvc
Please brief not about xsd,xslt & xml?
What is repository pattern in mvc.net? : asp.net mvc
What is server infrastructure & server components?
In which event of page cycle is the viewstate available?