写了以下代码,但是老说“insert statement”有错误。还有那个id怎么能自动添加一个自动增加的数
OleDbConnection mConn;
string connectionString_a = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=H:\\words.accdb";
mConn = new OleDbConnection(connectionString_a); OleDbCommand add_cmd = new OleDbCommand("INSERT INTO Relationship ([id],word_o, word_n, user) VALUES
(@id,@word_o,@word_n,@user)", mConn);
add_cmd.Parameters.Add("@id", OleDbType.VarChar, 50);
add_cmd.Parameters["@id"].Value = 5;
add_cmd.Parameters.Add("@word_o", OleDbType.VarChar, 50);
add_cmd.Parameters["@word_o"].Value = txt_sr.Text.ToString();
add_cmd.Parameters.Add("@word_n", OleDbType.VarChar, 50);
add_cmd.Parameters["@word_n"].Value = LB_syn.SelectedValue.ToString();
add_cmd.Parameters.Add("@user", OleDbType.VarChar, 50);
add_cmd.Parameters["@user"].Value = txt_user.Text.ToString(); mConn.Open();
add_cmd.ExecuteNonQuery();
mConn.Close();
OleDbConnection mConn;
string connectionString_a = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=H:\\words.accdb";
mConn = new OleDbConnection(connectionString_a); OleDbCommand add_cmd = new OleDbCommand("INSERT INTO Relationship ([id],word_o, word_n, user) VALUES
(@id,@word_o,@word_n,@user)", mConn);
add_cmd.Parameters.Add("@id", OleDbType.VarChar, 50);
add_cmd.Parameters["@id"].Value = 5;
add_cmd.Parameters.Add("@word_o", OleDbType.VarChar, 50);
add_cmd.Parameters["@word_o"].Value = txt_sr.Text.ToString();
add_cmd.Parameters.Add("@word_n", OleDbType.VarChar, 50);
add_cmd.Parameters["@word_n"].Value = LB_syn.SelectedValue.ToString();
add_cmd.Parameters.Add("@user", OleDbType.VarChar, 50);
add_cmd.Parameters["@user"].Value = txt_user.Text.ToString(); mConn.Open();
add_cmd.ExecuteNonQuery();
mConn.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货