说明:执行当前Web请求期间发生未处理的异常。请查看堆栈跟踪,以获取有关错误及其在代码中起源的更多信息。
异常详细信息:System.Data.SqlClient.SqlException:关键字“ WHERE”附近的语法不正确。
这是我的代码
Imports System.Data
Imports System.Data.SqlClient
Protected Sub btnEdit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnEdit.Click
If (IsPostBack) Then
If (Not Session("Language_ID") = Nothing) Then
cn.Open()
Dim cmdEdit As New SqlCommand("UPDATE [tblDefault] SET [Language] = @lang, [Title1] = @title1," & _
"[Details1]=@detail1,[Details2]=@detail2," & _
"[Title3] = @title3, [Details3] = @detail3, [Welcome] = @wel," & _
"WHERE [LangID] = @langid", cn)
With cmdEdit.Parameters
.Add("@langid", SqlDbType.BigInt).Value = Val(Session("Language_ID").ToString)
.Add("@lang", SqlDbType.NVarChar).Value = ddlLang.SelectedValue
.Add("@title1", SqlDbType.NVarChar).Value = txtTitle1.Text
.Add("@detail1", SqlDbType.NVarChar).Value = CkeditorDetail1.Text
.Add("@title2", SqlDbType.NVarChar).Value = txtTitle2.Text
.Add("@detail2", SqlDbType.NVarChar).Value = CkeditorDetail2.Text
.Add("@title3", SqlDbType.NVarChar).Value = txtTitle3.Text
.Add("@detail3", SqlDbType.NVarChar).Value = CkeditorDetail3.Text
.Add("@wel", SqlDbType.NVarChar).Value = txtWel.Text
End With
cmdEdit.Connection = cn
cmdEdit.ExecuteNonQuery()
cn.Close()
Response.Redirect("admin_default.aspx")
Else
Response.Redirect("admin_default.aspx")
End If
End If
End Sub
,
之后删除@wel,
:
"[Title3] = @title3, [Details3] = @detail3, [Welcome] = @wel," & _
应该:
"[Title3] = @title3, [Details3] = @detail3, [Welcome] = @wel " & _
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句