Question

c# update语句，access报错

string date =comboBox2.Text+"-"+comboBox4.Text+"-"+comboBox5.Text;

string updatecmd = "UPDATE consume SET ID =@ID,datetime=@datetime,type =@type,categate =@categate,money=@money,descrition=@money where ID=@ID";
oleDbCommand1 = new OleDbCommand(updatecmd,oleDbConnection1);
oleDbCommand1.Parameters.Add(new OleDbParameter("@ID",OleDbType.Integer,10));
oleDbCommand1.Parameters["@ID"].Value = textBox1.Text.Trim();
oleDbCommand1.Parameters.Add(new OleDbParameter("@datetime", OleDbType.DBDate, 10));
oleDbCommand1.Parameters["@datetime"].Value = date;
oleDbCommand1.Parameters.Add(new OleDbParameter("@type", OleDbType.Char, 6));
oleDbCommand1.Parameters["@type"].Value = comboBox1.Text;
oleDbCommand1.Parameters.Add(new OleDbParameter("@categate",OleDbType.Char,10));
oleDbCommand1.Parameters["@categate"].Value = comboBox3.Text;
oleDbCommand1.Parameters.Add(new OleDbParameter("@money",OleDbType.Integer,10));
oleDbCommand1.Parameters["@money"].Value = textBox3.Text.Trim();
oleDbCommand1.Parameters.Add(new OleDbParameter("@descrition",OleDbType.Char,50));
oleDbCommand1.Parameters["@descrition"].Value = textBox2.Text.Trim();
oleDbCommand1.Parameters.Add(new OleDbParameter("@ID", OleDbType.Integer, 10));
oleDbCommand1.Parameters["@ID"].Value = textBox1.Text.Trim();
oleDbCommand1.Connection.Open();
oleDbCommand1.ExecuteNonQuery();
oleDbCommand1.Connection.Close();
大侠们救我

Answer 1

oleDbCommand1.Parameters["@ID"].Value = textBox1.Text.Trim();
oleDbCommand1.Parameters["@money"].Value = textBox3.Text.Trim();

这俩都是整型, 后面改为 int.parse(textBox1.Text.Trim())

oleDbCommand1.Parameters["@ID"].Value = int.parse(textBox1.Text.Trim())
oleDbCommand1.Parameters["@money"].Value = int.parse(textBox3.Text.Trim())

Answer 2

string updatecmd = "UPDATE consume SET ID =@ID,datetime=@datetime,type =@type,categate =@categate,money=@money,descrition=@money where ID=@ID";
错误点：SET ID==@ID,where ID=@ID,作为条件的ID不能出现在更新里面，你也更新不了。

Answer 3

oleDbCommand1.Parameters["@ID"].Value = int.Parse(textBox1.Text);
oleDbCommand1.Parameters["@money"].Value = int.Parse(textBox3.Text);

Answer 4

把每个字段加上 [] （比如 [uname]） 试试..