webform1.asp.vb

Imports System.Data
Imports System.Data.sqlClient
Public 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.Data
Imports System.Data.SqlClient
Public 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 Sub
End Class

connect1.vb

Imports System.Data
Imports System.Data.SqlClient
Module 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 Function
End 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 Sub
End Class

评论