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

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

Answers (3)