Can we connect two datareader to same data source using single connection at same time?

No, we cann't since once connection to database is opened must be closed before you reopen again .
  • Interview Candidate
  • 15
  • 7671

Editorial / Best Answer

Answered by: Sathiyavathi

  • Mar 24th, 2006

 We can do it in ADO.Net 2.0 as

   In your connection string there is an additional attribute named as MARS

and set it as true. MARS stands for Multiple Active Result Sets.

  Ex :

    string connectionString = "Data Source=MSSQL1;" +
    "Initial Catalog=AdventureWorks;Integrated Security=SSPI" +
    "MultipleActiveResultSets=True";

Showing Answers 1 - 15 of 15 Answers

Shree

  • Mar 17th, 2006
 

No. You will get a runtime error:// System.InvalidOperationException: There is already an open DataReader associated with this Connection which must be closed first.//SO, Connection has to be closed before it is used for another DataReader.

  Was this answer useful?  Yes

AD

  • Mar 23rd, 2006
 

You can just close the datareader instead of closing the connection.

  Was this answer useful?  Yes

Karthik

  • Mar 24th, 2006
 

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.

  Was this answer useful?  Yes

Sathiyavathi

  • Mar 24th, 2006
 

 We can do it in ADO.Net 2.0 as

   In your connection string there is an additional attribute named as MARS

and set it as true. MARS stands for Multiple Active Result Sets.

  Ex :

    string connectionString = "Data Source=MSSQL1;" +
    "Initial Catalog=AdventureWorks;Integrated Security=SSPI" +
    "MultipleActiveResultSets=True";

ashu.fouzdar

  • Sep 20th, 2007
 

It is bit ambiguous, there are two scenerios
(1) want to connect two datareader to single database .
(2) want to connect two datareader to single database using single connection.

In first scenerio, it is possible to connect two datareader to single database using different connection.
But in second scenerio it is not possible to connect two datareader to single database connection

  Was this answer useful?  Yes

dvsnraju_mek

  • Jun 27th, 2008
 

yes,we can connect two dataadaters to same datasource using single connection at same time.
There is a technology in ado.net 2.0 called MARS usinng Mars in connection string we can do it.
for eg:
  cn.ConnectionString = "server=(local); database=employee; integrated security=sspi; MultipleActiveResultSets=True";

  Was this answer useful?  Yes

Ravi

  • Sep 16th, 2011
 

Yes, you can connect two datareader to the same datasource, but one main thing 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.

  Was this answer useful?  Yes

rajankvns

  • Sep 18th, 2011
 

Yes, 100% you can connect. help of-- Multiple Active Result Sets (MARS).

more details with Example visit below Microsoft official website. --

http://msdn.microsoft.com/en-us/library/yf1a7f4f%28v=vs.80%29.

Thanks
Rajan Vishwakarma

Code
  1. span style="font-style: italic;">// By default, MARS is disabled when connecting

    2. 

  2.   // to a MARS-enabled host such as SQL Server 2005.

    3. 

  3.   // It must be enabled in the connection string."SELECT VendorId, Name FROM Purchasing.Vendor""SELECT Production.Product.Name FROM Production.Product " +

    4. 

  4.     "INNER JOIN Purchasing.ProductVendor " +

    5. 

  5.     "ON Production.Product.ProductID = " + 

    6. 

  6.     "Purchasing.ProductVendor.ProductID " +

    7. 

  7.     "WHERE Purchasing.ProductVendor.VendorID = @VendorId""@VendorId""Name""VendorId"];

    8. 

  8.  

    9. 

  9.         productCmd.Parameters["@VendorId"// The following line of code requires

    10. 

  10.         // a MARS-enabled connection."  " +

    11. 

  11.               productReader["Name""Press any key to continue"// To avoid storing the connection string in your code,

    12. 

  12.     // you can retrive it from a configuration file."Data Source=(local);Integrated Security=SSPI;" + 

    13. 

  13.       "Initial Catalog=AdventureWorks;MultipleActiveResultSets=True";

    14. 

  14.   }

    15. 

  15. }

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions