UC知道使用cmd.ExecuteNonQuery();时，出现insert into语法错误
来源：百度知道 编辑：UC知道 时间：2024/05/31 08:34:31
老鸟们帮帮忙！！！我做的是一个C#+access的C/S程序，主要是往库里插数据
private void button1_Click(object sender, EventArgs e)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=account.mdb";
OleDbConnection conn = new OleDbConnection(strConn);
string date = textBox1.Text.Trim();
string sql = "select count(*) from AccountTable where date='" + textBox1.Text +"'";
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
int n = (int)cmd.ExecuteScalar();
if (n > 0)
{
MessageBox.Show("该记录重复！（可能日期与表内日期重复）");
}
cmd.CommandText = "insert into AccountTable (date,earning,eatery,life,capture,bleeding,borrow,loan,remark) values (@date,@earning,@eatery,@life,@capture,@bleeding,@borrow,@loan,@remark)";
cmd.Parameters.Add("@dat
private void button1_Click(object sender, EventArgs e)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=account.mdb";
OleDbConnection conn = new OleDbConnection(strConn);
string date = textBox1.Text.Trim();
string sql = "select count(*) from AccountTable where date='" + textBox1.Text +"'";
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
int n = (int)cmd.ExecuteScalar();
if (n > 0)
{
MessageBox.Show("该记录重复！（可能日期与表内日期重复）");
}
cmd.CommandText = "insert into AccountTable (date,earning,eatery,life,capture,bleeding,borrow,loan,remark) values (@date,@earning,@eatery,@life,@capture,@bleeding,@borrow,@loan,@remark)";
cmd.Parameters.Add("@dat
OleDbCommand cmd = new OleDbCommand(sql, conn);
int n = (int)cmd.ExecuteScalar();
OleDbCommand cmd1 = new OleDbCommand("insert into AccountTable (date,earning,eatery,life,capture,bleeding,borrow,loan,remark) values (@date,@earning,@eatery,@life,@capture,@bleeding,@borrow,@loan,@remark)";
, conn);
cmd1.ExecuteNonQuery();
应该是这样写吧。。一个cmd怎么能有2个SQL语句呢。。如果想在button1下做2个事情要写2个cmd与cmd1来区分下