CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS MICROSOFT ADO.NET DETAILS
Question :
Can we connect two datareader to same data source using single connection at same time?


Category ADO.NET Interview Questions
Rating (4.9) By 34 users
Added on 7/27/2006
Views 1726
Rate it!
Answers:

Yes, you can connect two datareader to the same datasource, but one mainthing is close the first datareader before using second one then only it's possible.



The point is, we can have any number of datareaders to the same datasource, but only one of them could have an active connection at any point of time.



 Posted by: Sathishkumar    

Contact Sathishkumar  Contact Sathishkumar

It is possible using MARS (Multi Active Record Set) in VS 2005. We have to set MARS =True in the connection string, so that we can use 2 datareaders for a single connection



 Posted by: Madhusudhanreddy    

Contact Madhusudhanreddy  Contact Madhusudhanreddy


If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
Why can't we use Multiple inheritance and garbage collector paralelly in .net

View Answer
How many records can take clustured index in sql server




View Answer
Difference between SqlCommand and SqlCommandBuilder

View Answer
Why edit is not possible in repeater??

View Answer
What is the difference between data reader & data set




View Answer
How can we load multiple tables in to Dataset?

View Answer
Does SQLClient and OLEdb class share the same functionality

View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL ADO.NET Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/8574/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.88