Articles → ADO.NET → Reading multiple result sets using datareader in ado.net

Reading multiple result sets using datareader in ado.net




Introduction





Syntax


//  This will read the first result set
while (<data_reader_object>.Read())
{
	//  Do something
}
//  Advances to next result set
<data_reader_object>.NextResult();
//  This will read the second result set
while (<data_reader_object>.Read())
{
	//  Do something
}
//  Advances to next result set
<data_reader_object>.NextResult();
//  This will read the third result set
while (<data_reader_object>.Read())
{
	//  Do something
}







Example


using (SqlConnection conn = new SqlConnection("<connection_string>"))
{
  using (SqlCommand cmd = new SqlCommand("query1;query2;query3", conn))
  {
    conn.Open();
    SqlDataReader rd = cmd.ExecuteReader();
    //  This will read the first result set
    while (rd.Read())
    {
      //  Do something 
    }
    //  Advances to next result set
		rd.NextResult();
    //  This will read the second result set
		while (rd.Read())
    {
      //  Do something 
    }
    //  Advances to next result set
		rd.NextResult();
    //  This will read the second result set
		while (rd.Read())
    {
      //  Do something 
    }
  }
}



Posted By  -  Karan Gupta
 
Posted On  -  Saturday, December 10, 2011

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250