title: How to call multiple stored procedures in a MySql database
body: <p>I am able to get this program to work with one stored procedure. Is it possible to call multiple stored procedures from MYSQL in C#? If so what is the most efficient way of doing so? Here is a snippet of my code to show what I've done thus far: </p>
  
  <pre><code>public static string RunSQL()
  {
      // Here is where it is connecting to local host.
      string connStr = "server=localhost;user=xxxx;"
                       + "database=xxxx;port=3306;password=xxx;"
                       + "Allow User Variables=True";
      MySqlConnection conn = new MySqlConnection(connStr);
  
      // Here is where the connection gets opened.
      conn.Open();
  
      // Here I call the CN_renumber stored procedure.
      MySqlCommand CN_renumber = new MySqlCommand("CN_renumber", conn);
      CN_renumber.CommandType = System.Data.CommandType.StoredProcedure;
  
      object result = CN_renumber.ExecuteNonQuery();
  
      // Disconnect from local host.
      conn.Close();
  
      return result.ToString();
  }
  </code></pre>