Connection of two DataAdapters at same time
Is it possible to connect two DataAdapters of same data source with the use of single connection at the same time?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Feb 28, 2012, 5:34 AM
add multipleactiveresultsets = true in web config.
please refer.
http://www.sqlteam.com/article/multiple-active-result-sets-mars
hope this help.
Hemant KumarPosted Feb 25, 2012, 9:08 AM
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";