MySqlConnection mycon = new MySqlConnection(constr);            

mycon.Open();                          

sql += "UPDATE promotion.xzgyq_yeargift_publish SET type=0  WHERE name='张三';";                       

MySqlCommand mycmd = new MySqlCommand(sql,mycon);         

 //mycmd.CommandText = "UPDATE promotion.xzgyq_yeargift_publish SET

//type=0  WHERE  name=?name;";

//mycmd.Parameters.Add(new MySqlParameter("?name", "张三"));

            if (mycmd.ExecuteNonQuery() > 0)             {                 result = true;             }             else             {                 result = false;             }             mycon.Close();