webform1.asp.vb Imports System.DataImports System.Data.sqlClientPublic Class WebForm1    Inherits System.Web.UI.Page    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load        '在此处放置初始化页的用户代码         Dim objconn As New SqlConnection        objconn.ConnectionString = "server=localhost;uid=sa;pwd=sa;database=northwind"        objconn.Open()        If objconn.State = ConnectionState.Open Then            Response.Write("112")        Else            Response.Write("110")        End If        objconn.Close()       End Sub#Region " Web 窗体设计器生成的代码 "     '该调用是 Web 窗体设计器所必需的。    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()     End Sub     '注意: 以下占位符声明是 Web 窗体设计器所必需的。    '不要删除或移动它。    Private designerPlaceholderDeclaration As System.Object     Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的        '不要使用代码编辑器修改它。        InitializeComponent()    End Sub #End Region   End Class index.aspx.vb Imports System.DataImports System.Data.SqlClientPublic Class index    Inherits System.Web.UI.Page #Region " Web 窗体设计器生成的代码 "     '该调用是 Web 窗体设计器所必需的。    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()     End Sub    Protected WithEvents Label1 As System.Web.UI.WebControls.Label    Protected WithEvents Label2 As System.Web.UI.WebControls.Label    Protected WithEvents Label3 As System.Web.UI.WebControls.Label    Protected WithEvents Userid As System.Web.UI.WebControls.TextBox    Protected WithEvents Pwd As System.Web.UI.WebControls.TextBox    Protected WithEvents register As System.Web.UI.WebControls.Button    Protected WithEvents Login As System.Web.UI.WebControls.Button     '注意: 以下占位符声明是 Web 窗体设计器所必需的。    '不要删除或移动它。    Private designerPlaceholderDeclaration As System.Object     Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的        '不要使用代码编辑器修改它。        InitializeComponent()    End Sub #End Region     Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load        '在此处放置初始化页的用户代码           End Sub     Private Sub Login_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login.Click        Dim dr As SqlDataReader        Dim sql As String        sql = "select * from Register where userid='" & Userid.Text & "'and pwd='" & Pwd.Text & "'"        dr = connect(sql)        If dr.Read() Then            Response.Redirect("register_result.aspx")        Else            Response.Write("有错误")        End If     End Sub     Private Sub register_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles register.Click        Dim dr As SqlDataReader        Dim sql As String        sql = "select * from Register where userid=' " & Userid.Text & "'"        dr = connect(sql)        If dr.Read() Then            Response.Write("用户名存在")        Else            Session("userid") = Userid.Text            Response.Redirect("register.aspx")        End If    End SubEnd Class   connect1.vb Imports System.DataImports System.Data.SqlClientModule connect1     Public Function connect(ByVal sql As String) As SqlDataReader        Dim objconn As New SqlConnection        objconn.ConnectionString = "server=localhost;uid=sa;pwd=sa;database=User"        objconn.Open()        Dim cmd As New SqlCommand(sql, objconn)        Dim dr As SqlDataReader        dr = cmd.ExecuteReader()        connect = dr     End FunctionEnd Module     register.aspx.vb Public Class register    Inherits System.Web.UI.Page #Region " Web 窗体设计器生成的代码 "     '该调用是 Web 窗体设计器所必需的。    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()     End Sub    Protected WithEvents Label1 As System.Web.UI.WebControls.Label    Protected WithEvents Label2 As System.Web.UI.WebControls.Label    Protected WithEvents Label3 As System.Web.UI.WebControls.Label    Protected WithEvents Userid As System.Web.UI.WebControls.TextBox    Protected WithEvents pwd As System.Web.UI.WebControls.TextBox    Protected WithEvents Age As System.Web.UI.WebControls.TextBox    Protected WithEvents Label4 As System.Web.UI.WebControls.Label    Protected WithEvents Button1 As System.Web.UI.WebControls.Button    Protected WithEvents Button2 As System.Web.UI.WebControls.Button     '注意: 以下占位符声明是 Web 窗体设计器所必需的。    '不要删除或移动它。    Private designerPlaceholderDeclaration As System.Object     Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的        '不要使用代码编辑器修改它。        InitializeComponent()    End Sub #End Region     Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load        '在此处放置初始化页的用户代码    End Sub     Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click        Session("userid") = Userid.Text        Session("pwd") = pwd.Text        Session("age") = Age.Text     End Sub     Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click        Response.Redirect("index.aspx")    End SubEnd Class

评论