Connection of two DataAdapters at same time

Question

Is it possible to connect two DataAdapters of same data source with the use of single connection at the same time?

Jignesh Trivedi · Answer

hi add multipleactiveresultsets = true in web config. please refer. http://www.sqlteam.com/article/multiple-active-result-sets-mars hope this help.

Hemant Kumar · Answer

yes we can connect two data adapters to same data source 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;