使用添加為值的參數(shù)執(zhí)行此查詢時(shí)，出現(xiàn)錯(cuò)誤，提示我的語法錯(cuò)誤。我嘗試了以下多個(gè)教程，在這里查找問題是堆棧溢出，并且進(jìn)行比較時(shí)，它們似乎相同，但是我的似乎不起作用。OleDbConnection con = new OleDbConnection(); con.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source =C:\\Users\\fidyc\\OneDrive\\Desktop\\ProgrII.accdb"; OleDbCommand cmd = new OleDbCommand("INSERT Product_Orders(order_ID,plankCount,thickness,width,height)VALUES(@order_ID, @plankCount, @thickness, @width, @height)"); cmd.Parameters.Add("@order_ID", OleDbType.Integer).Value = orderID; cmd.Parameters.Add("@plankCount", OleDbType.Decimal).Value = plankCount; cmd.Parameters.Add("@thickness", OleDbType.Decimal).Value = thickness; cmd.Parameters.Add("@width", OleDbType.Decimal).Value = width; cmd.Parameters.Add("@height", OleDbType.Decimal).Value = height; cmd.Connection = con; con.Open(); if (con.State == ConnectionState.Open) { /*try {*/ cmd.ExecuteNonQuery(); MessageBox.Show("Data Added"); con.Close(); /*} catch (OleDbException ex) { MessageBox.Show(ex.Source); con.Close(); }*/ }編輯：值傳遞給函數(shù)public static void Push(int orderID, decimal plankCount, decimal thickness, decimal width, decimal height) {
2 回答
慕田峪9158850
TA貢獻(xiàn)1794條經(jīng)驗(yàn) 獲得超7個(gè)贊
問題原來是count列名，因?yàn)閟ql有一個(gè)count命令，所以它必須是
OleDbCommand cmd = new OleDbCommand("INSERT INTO Product_Orders(order_ID,[count],thickness,width,height)VALUES(@order_ID, @count, @thickness, @width, @height)");代替
OleDbCommand cmd = new OleDbCommand("INSERT INTO Product_Orders(order_ID,count,thickness,width,height)VALUES(@order_ID, @count, @thickness, @width, @height)");
慕桂英4014372
TA貢獻(xiàn)1871條經(jīng)驗(yàn) 獲得超13個(gè)贊
using (OleDbCommand cmd = conn.CreateCommand())
{
cmd.CommandText =
"INSERT INTO bookRated "+
"([firstName], [lastName]) "+
"VALUES(@firstName, @lastName)";
cmd.Parameters.AddRange(new OleDbParameter[]
{
new OleDbParameter("@firstName", firstName),
new OleDbParameter("@lastName", lastName),
});
cmd.ExecuteNonQuery();
}
- 2 回答
- 0 關(guān)注
- 262 瀏覽
添加回答
舉報(bào)
0/150
提交
取消