当我写这段代码时
System.Data.OleDb.OleDbException(0x80040E14):UPDATE语句中的语法错误。
消息。(C#,访问权限(SayacGun,SayacToplam是整数,而Tarih是dateTime))
OleDbConnection dbBaglanti2 = new OleDbConnection(VTYolu);
dbBaglanti2.Open();
string Ekle2 = "UPDATE Sys_Sayac SET SayacGun = @Gun, SayacToplam = @Toplam, WHERE Tarih = @Tarih";
OleDbCommand Komut2 = new OleDbCommand(Ekle2, dbBaglanti2);
Komut2.Parameters.AddWithValue("@Gun", int.Parse(OkunanGun));
Komut2.Parameters.AddWithValue("@Toplam", Convert.ToInt32(OkunanToplam) + 1);
Komut2.Parameters.AddWithValue("@Tarih", DateTime.Now.ToShortDateString());
Komut2.ExecuteNonQuery();
dbBaglanti.Close();
最佳答案
您应该在WHERE子句之前删除逗号“,”,
string Ekle2 = "UPDATE Sys_Sayac SET SayacGun = @Gun, SayacToplam = @Toplam WHERE Tarih = @Tarih";
有关更多信息,请检查更新语法here的详细信息
关于c# - C# Access System.Data.OleDb.OleDbException(0x80040E14):UPDATE语句中的语法错误,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/46497750/