未知列'；buyDate'；在'；字段列表'；

使用phpMyAdmin，希望从C#更新数据。但是，我有一个错误：

"Unknown column 'buyDate' in 'field list'"

我也用绳子。buyDate字段的格式。这只是我代码的几个部分。谢谢你的帮助。

private void btnSave_Click(object sender, EventArgs e)
{
        conect.Open();
        MySqlCommand cmd = new MySqlCommand();
        cmd.Connection = conect;
        cmd.CommandType = CommandType.Text;
        int result = 0;
        buyDate = string.Format("{0,10:dd/MM/yyyy}", txtBuyDate.Text);
        volume = txtVolume.Text;
        color = cboColor.SelectedValue.ToString();
        type = cboType.SelectedValue.ToString();
        cmd.CommandText = "update bucket set buyDate=@buyDate, volume=@volume, color=@color, type=@type where idBucket=@idBucket";
        cmd.Parameters.AddWithValue("@idBucket", idBucket);
        cmd.Parameters.AddWithValue("@buyDate", buyDate);
        cmd.Parameters.AddWithValue("@volume", volume);
        cmd.Parameters.AddWithValue("@color", color);
        cmd.Parameters.AddWithValue("@type", type);
        result += cmd.ExecuteNonQuery();
        cmd.Parameters.Clear();
        if (result > 0)
        {
            MessageBox.Show("You've changed " + result + " data");
        }
        else
        {
            MessageBox.Show("You haven't changed any data");
        }
        conect.Close();
        this.Close();
   }

我已经知道这个问题了。我对字符串使用了错误的语法。格式化

cmd.Parameters.AddWithValue("@buyDate", "'" + buyDate + "'");