title: How do I return multiple tables using MySqlDataReader?
body: <p>I want to return two tables using a mySqlDataReader and load the results into two datatables.</p>
  
  <pre><code> using (MySqlConnection connMySql = new MySqlConnection(global.g_connString))
              {
                 MySqlCommand cmd = connMySql.CreateCommand();
                  cmd.CommandText = @"
                                      SELECT * FROM table1;
                                      SELECT * FROM table2;
                                      "; 
                  connMySql.Open();
                  using (MySqlDataReader dr = cmd.ExecuteReader())
                  {
                          DataTable dt1 = new DataTable();
                          dt1.Load(dr);
                          dr.NextResult();
                          DataTable dt2 = new DataTable();
                          dt2.Load(dr);
  
                          gridView1.DataSource = dt1;
                          gridView1.DataBind();
                          gridView2.DataSource = dt2;
                          gridView2.DataBind();
                   }
  </code></pre>
  
  <p>However, when I run this, only one gridView is populated. Can I use NextResult in this way, or is there a better way to acheive this?</p>
  
  <p>Thanks in advance,</p>
  
  <p>Ben</p>