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

insert into 语法出错! 求9!

ryophoenix 发布于 2007-12-10 10:30, 969 次点击
<%@ Import Namespace="system.data" %>
<%@ Import Namespace="system.data.oledb" %>
<script language="VBSCRIPT" runat="server">
    Sub enter_click(ByVal sender As Object, ByVal e As EventArgs)
        Dim conn As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Inetpub\wwwroot\asp1\App_Data\user.mdb")
        Dim strsql As String
        strsql = "Insert Into user(user_name,password ) values('" & user_name.Text & " ','" & password.Text & " ')"
        Dim cmd As New OleDbCommand(strsql, conn)
        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()         
    End Sub
3 回复
#2
bygg2007-12-11 09:30
strsql = "Insert Into [user](user_name,password ) values('" & user_name.Text & " ','" & password.Text & " ')"
#3
gupiao1752007-12-11 13:49
user是关键字
汗,user是SQLSERVER的关键字!一般用表名都不用关键字来做!
#4
ryophoenix2007-12-12 08:57
    3Q~!
1