title: C# MySQL connection multiple select statements
body: <p>I can connect to MySQL database from my WinForms app fine. The question is once I am logged in how can I perform multiple select statements without having to login again?</p>
  
  <pre><code>MySqlConnection connection = new MySqlConnection(MyConString);
  connection.Open();
  
  MySqlCommand command = connection.CreateCommand();
  MySqlDataReader Reader;
  
  command.CommandText = "select id from user ";
  </code></pre>
  
  <p>Then I want to perform a select statement for another table without having to create connection again.
  How do I dothis?
  I can't seem to just do <code>connection.CreateCommand</code>.</p>