title: Reuse of SqlConnection and SqlDataReader
body: <p>If I want to run multiple SELECT queries on different tables, can I use the same SqlDataReader and SqlConnection for all of them?? Would the following be wise?? (I typed this up fast, so it lacks try/catch):</p>
  
  <pre><code>MySqlCommand myCommand = new MySqlCommand("SELECT * FROM table1", myConnection);
  
  myConnection.Open();
  SqlDataReader myDataReader = myCommand.ExecuteReader();
  
  while(myReader.Read())
  {
      //Perform work.
  }
  
  myCommand.commandText = "SELECT * FROM table2";
  
  myReader = myCommand.ExecuteReader();
  
  while(myReader.Read())
  {
      //Perform more work
  }
  
  myReader.Close();
  myConnection.Close();
  </code></pre>
  
  <p>Thanks a lot.</p>