Connect two dataadapter to same data source using single connection at same time in Ado.Net

Question

can i Connect two dataadapter to same data source using single connection at same time in Ado.Net and how?

Shivanand Arur · Answer

string ConnectionString = ConfigurationManager.ConnectionStrings[SqlServer].ConnectionString; SqlConnection con = new SqlConnection(ConnectionString); DataSet ds = new DataSet(Dataset1); DataSet ds2 = new DataSet(Dataset2); con.Open(); SqlDataAdapter da1 = new SqlDataAdapter(Select * from CollegeMembers con); da1.Fill(ds); da1.Dispose(); SqlDataAdapter da2 = new SqlDataAdapter(Select * from CollegeMembers where MemberID = 1 con); da2.Fill(ds2); da2.Dispose(); con.Close();

Satyapriya Nayak · Answer

http://www.dotnetfunda.com/interview/exam5277-can-we-connect-two-dataadapters-to-same-data-source-using-single-connection.aspx http://msdn.microsoft.com/en-us/library/h32h3abf%28v=vs.80%29.aspx

Shivanand Arur · Answer

I think you can do it.... I have not tested this but you can try it out in this way... Basically a Adapter is nothing but a Bridge between the DataSource and the DataSet/DataTable. It get the information from the DataSource and helps to fill the Dataset or DataTable.... It is basically used in Disconnected Architecture... protected void AdapterTest() { SqlConnection CON = new SqlConnection(); CON.ConnectionString = Connection String; SqlCommand cmd = new SqlCommand(Select * from tableName CON); CON.Open(); DataSet ds = new DataSet(); DataSet ds2 = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd.CommandText CON); SqlDataAdapter da2 = new SqlDataAdapter(cmd.CommandText CON); CON.Close(); da.Fill(ds); da2.Fill(ds2); } May be I am wrong with this solution but you can still try and let me know. PLEASE MARK THE ANSWER AS ACCEPTED IF IT HELPED YOU!!! Thanks