[C#²Ù×÷MySqlÇóÖú] MySqlCommand²»ÄÜCancel

C# code:

MySqlConnection conn = null;
MySqlCommand cmd = null;
try
{
conn = new MySqlConnection("*****");
conn.Open();
cmd = conn.CreateCommand();
string sql = string.Empty;

sql = @"insert
into table_user(id,name)
values(@id,@name)";
cmd.CommandText = sql;
cmd.Parameters.Clear();
cmd.Parameters.Add(new MySqlParameter("id", 1));
cmd.Parameters.Add(new MySqlParameter("name", "mark"));
cmd.ExecuteNonQuery();
}
catch
{
}
finally
{
if (cmd != null)
{
cmd.Cancel(); //ÕâÀﱨ´í£ºCanceling an active query is only supported on MySQL 5.0.0 and above.
cmd.Dispose();
}
if (conn != null)
{
conn.Close();
conn.Dispose();
}
}

---

È¡ÏûÁ˲éѯ¹¦ÄÜ Ö»Ö§³ÖÔÚ