注册 登录
编程论坛 ASP技术论坛

INSERT INTO语句语法错误 求解

kiska3088915 发布于 2010-11-04 14:39, 936 次点击

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim logname As String
        Dim logpsw As String
        logname = TextBox1.Text
        logpsw = TextBox2.Text
        Dim connect As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection
        connect.ConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/database/book.mdb"))
        Try
            connect.Open()
            Response.Write("SUCCEED")
        Catch ex As Exception
            Response.Write(ex)
        End Try
        Try
            Dim cmd As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand
            Dim result As Integer
            cmd.Connection = connect
             =
             = "insert into BOOK (username,password) values ('" + logname + " ',' " + logpsw + " ')"
            result = cmd.ExecuteNonQuery()
            Response.Write("write successfully")
        Catch ex As Exception
            Response.Write(ex.Message)
        End Try
        connect.Close()

    End Sub

点了这个button以后,打开数据库成功,显示SUCCEED,但紧接着就报错说INSERT INTO 语句的语法错误,补充一下,相应的ACCESS数据库里的BOOK表里所有属性都可以是空值。。。。。希望大虾们赐教


再补充一下response.write()后的运行结果是
insert into BOOK (username,password) values ('ASS ',' ASS ')
应该没问题

[ 本帖最后由 kiska3088915 于 2010-11-4 14:48 编辑 ]
4 回复
#2
dzt00012010-11-04 15:05
我怎么看着不像ASP的代码啊。
#3
jingjing3162010-11-04 17:19
好像没有什么错误,把连接符换一下试试
"insert into BOOK (username,password) values ('" & logname &" ','" & logpsw & " ')"
#4
kiska30889152010-11-05 22:01
我知道了,是PASSWORD这个和关键字冲突了,加个中括号就解决了
#5
kiska30889152010-11-05 22:02
回复 2楼 dzt0001
VS2008上用VB写的
1