Can we connect two datareader to same data source using single connection at same time?

Question

Muralidharan Deenathayalan · Answer

Yes it is possible , if you use Multiple Active Result Sets( MARS ); using (SqlConnection con = new SqlConnection()) { string constr = @"Data Source=MURALIDHARAND\SQL2008R2;Initial Catalog=DestinationDB;Integrated Security=True; MultipleActiveResultSets=true "; con.ConnectionString = constr; con.Open(); SqlCommand cmd1 = con.CreateCommand(); SqlCommand cmd2 = con.CreateCommand(); cmd1.CommandText = " select * from division"; cmd1.CommandType = CommandType.Text; SqlDataReader reader1 = cmd1.ExecuteReader(); if (reader1.HasRows) { reader1.Read(); cmd2.CommandText = " select * from subdivision"; cmd2.CommandType = CommandType.Text; SqlDataReader reader2 = cmd2.ExecuteReader(); if (reader2.HasRows) { MessageBox.Show("Success"); } } } Hope this helps you.

shams khan · Answer

yes it is possible , if u want to use multiple active results

vikram thakur · Answer

Thanks Murli. It Works.

Marcus · Answer

Thanks Murlidharan, great site, quick response

Can we connect two datareader to same data source using single connection at same time?

Answers (4)