title: update a mySQL table using C#
body: <p>I have written some C# to update a MySql table but I get an exception every time I call  the method ExecuteNonQuery(). I have researched this on the web and every solution I find produces the same error. I have an open connection to the database and the update query to the database is written correctly. The code that I have so far come up with is :</p>
  
  <pre><code>public int executeUpdate()
  {
    int result = 0;
    if (isConnected)
    {
      try
      {
        MySqlConnection cn = new  MySqlConnection(connection.ConnectionString);
        MySqlCommand cmd = new MySqlCommand();
  
        cmd.Connection = cn; 
        cmd.CommandText = "UPDATE test SET status_id = 1 WHERE test_id = 1";
        int numRowsUpdated = cmd.ExecuteNonQuery(); 
      }
      catch (MySqlException exSql)
      {
        Console.Error.WriteLine("Error - SafeMySql: SQL Exception: " + query);
        Console.Error.WriteLine(exSql.StackTrace);
      }
      catch (Exception ex)
      {
        Console.Error.WriteLine("Error - SafeMySql: Exception: " + query);
        Console.Error.WriteLine(ex.StackTrace);
      }
    }
    else
      Console.Error.WriteLine("Error - SafeMySql: executeQuery failed. Not connected to DB");
  }
  </code></pre>