Re: 菜鸟的迷惑 - ASP.NET Forums

楼主

2007-6-24, 12:13 PM

ASP菜鸟

等级: 士兵
注册: 2007年6月24日
积分: 2
精华: 0
发贴: 1

菜鸟的迷惑

各位大虾们，小弟是ASP的菜鸟。下面的代码我搞了好几天都通不过，每次按提交就会出现“语法错误（操作符丢失）在查询表达式‘username='中

<head id="Head1" runat="server">
    <title>提交</title>
    <script language="vbscript" runat="server">
        Sub button(ByVal obj As Object, ByVal e As CommandEventArgs)
            Dim DSN As String
            Dim Tsql As String
            Dim OB As New OleDbConnection()
            DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
            Server.MapPath("userinformation.mdb") & ";"
            OB = New OleDbConnection(DSN)
            OB.Open()
            Label1.InnerHtml = "数据库连接状态:" & OB.State.ToString
            Tsql = "SELECT * FROM userinfo where username=" '&txtusername.Text&'""

            Dim OBJc As OleDbCommand = New OleDbCommand(Tsql, OB)
            Dim OBR As OleDbDataReader = OBJc.ExecuteReader()
            If OBR.Read() Then
                Response.Write("having record")
            Else : Response.Write("no record")
            End If

        End Sub
     </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       用户名<asp:TextBox ID="txtusername" TextMode="SingleLine" runat="server"></asp:TextBox><br />
       密码<asp:TextBox ID="txtuserpassword" TextMode="Password" runat="server"></asp:TextBox><br />
      <asp:Button ID="Button1" runat="server" OnCommand="button" Text="提交" />
      </div>
    </form>
     <span id="Label1" runat="server"></span>
</body>
</html>

IP 地址: 已登录来自: 已登录