Reading Multiple Result Sets Using Datareader In Ado.Net

//  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
}

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 
    }
  }
}

Query/Feedback