ADO.NET Interview Question:

can we connect two dataadapters to same data source using single connection at same time?

Submitted by: Administrator

yes,we can connect two dataadapters 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";
Submitted by: Administrator