VB.NET:SQL 参数(更新) [英] VB.NET: SQL Parameters (Update)
本文介绍了VB.NET:SQL 参数(更新)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试更新一些值,但我的代码似乎有问题.
I'm trying to update some values but it seems that there is a problem with my code.
Dim con As New OleDbConnection
Dim id As Integer = Main.Passes.Items.Count + 1
Dim id As Integer = Main.Passes.Items.Count + 1
Try
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ...\database.mdb"
con.Open()
Catch ex As Exception
MsgBox("There was a problem connection to database.", MsgBoxStyle.Critical)
End Try
Dim objCmd As OleDbCommand
Dim strSQL As String
strSQL = "UPDATE passwords SET website= @website, username= @username, password= @password, dates= @datenow, notes= @notes WHERE id= @id"
objCmd = New System.Data.OleDb.OleDbCommand(strSQL, con)
objCmd.Parameters.AddWithValue("@website", txtURL.Text)
objCmd.Parameters.AddWithValue("@username", txtUser.Text)
objCmd.Parameters.AddWithValue("@password", txtPass.Text)
objCmd.Parameters.AddWithValue("@datenow", txtDate.Text)
objCmd.Parameters.AddWithValue("@notes", txtNotes.Text)
objCmd.Parameters.AddWithValue("@id", id)
objCmd.ExecuteNonQuery()
con.Close()
我得到的错误是:UPDATE 语句中的语法错误.
推荐答案
尝试将您的列名括在 ``(反引号)中.我猜密码列是罪魁祸首,可能是关键字.
Try enclose your column names in `` (backticks). I guess password column is the culprit, probably a keyword.
这篇关于VB.NET:SQL 参数(更新)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文