Answered Questions

  • Sep 16 2005
    12:54 AM
    7406
    20

    can we connect two datareader to same data source using single connection at same time?
    • Niranjan

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

    Star Read Best Answer

    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";

    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 d...