If you are using two select queries and retrieving data. how
do you access second query's result set using data reader?
- 1 Answers
- 4757 Views
- Cap Gemini, Keane India Ltd, MindSquare, I also Faced
- E-Mail Answers
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
Explain what is an abstract class?
Define application state variable and session state variable?
How can u deifne the benefits and limitation of using Viewstate for state management?
Apart from IDE what are the enhancements in asp.net 2.0?
What's the difference between viewstate and sessionstate?
Explain what is the procedure to create the environment for asp.net? : asp.net mvc
What are resource file and how do we generate resource file?
What language is asp.net written in?
How do I open an ashx file in windows 7?
When does a session actually start?
What is the use of view state?
Briefly describe the role of global.asax?
Which adapter should you use, if you want to get the data from an access database?
What is the significance of finalize method in .net?
Define msil.
