If you are using two select queries and retrieving data. how
do you access second query's result set using data reader?
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 |
What is the difference between session and viewstate in asp.net?
What are the types of caching in asp.net?
How to write unmanaged code and how to identify whether the code is managed /unmanaged?
we are working in .net namespaces like using system.io,system.text. these namespace before we use "using " keyword what means of using?
7 Answers CEI, CSC, HCL, Tech Mahindra,
Explain the difference between sql invalidation and sql notification.
How to convert any string to view state format in asp.net? §ÇÛ짬ªª³ö»Ç¾ö»ÂÇ¿¾»¼»¾ö¼ÉÇöÇÏǼ»Ãö®±ª§°ö«³ -- i want convert this string to view state.
What are the new features added from ASP to ASP.NET?
What is _dopostback in asp net?
What does the hotspot class in .net do?
What is the lifespan for items stored in ViewState?
What is a Metadata?
Is global asax mandatory?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)