visual basic登录页面

前台：

用户名：<asp:TextBox ID="txtName" runat="server"></asp:TextBox><br />
        密&nbsp;&nbsp;&nbsp;码：<asp:TextBox ID="txtPwd" runat="server"></asp:TextBox><br />
        <asp:Button ID="Button1" runat="server" Text="点击" OnClick="Button1_Click" />

后台：

Dim Name As String = txtName.Text.Trim()
        Dim pwd As String = txtPwd.Text.Trim()
        Dim stronnect As String = ConfigurationManager.AppSettings("shujuku")
        Dim conn As New SqlConnection(stronnect)
        Dim sda As New SqlDataAdapter("select * from UserTableOne where UserNameO='" + Name + "' and ZhangHaoO='" + pwd + "'", conn)
        Dim ds As New DataTable()
        sda.Fill(ds)
        If (ds.Rows.Count>0) Then
            '打印
            'MsgBox("成功")
            'Response.Write("<script>alert('弹出框')</script>")
            '实现跳页
            Response.Redirect("页面名字")
        End If

注意：后台代码要放在一个事件中，由于是登录页面，所以要放在登录按钮事件（Button1_Click）之下