RSS
热门关键字:  Java  idc 下载  域名  idc  idc+下载
当前位置 :| 主页>程序设计>VB>

一个vb.net的用户登陆页面代码

来源:商务互联 作者:佚名 时间:2008-04-01 点击:

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

    If TextBox3.Text = "" Or TextBox4.Text = "" Then

    Label35.Text = "请确认您的输入!"

    Return

    End If

    Dim sql As String = "select * from pwd where stu_id=@stu_id and pwd=@pwd"

    Dim comm As SqlCommand = New SqlCommand(sql, conn)

    comm.Parameters.Add(New SqlParameter("@stu_id", SqlDbType.Int, 4))

    comm.Parameters("@stu_id")。Value = TextBox3.Text

    comm.Parameters.Add(New SqlParameter("@pwd", SqlDbType.Char, 16))

    comm.Parameters("@pwd")。Value = TextBox4.Text

    Dim dr As SqlDataReader

    conn.Open()

    dr = comm.ExecuteReader

    If dr.Read Then

    Session("stu_id") = TextBox3.Text

    dr.Close()

    comm.Cancel()

    Dim sql_3 As String = "update stu_base set point=point+1 where stu_id=@stu_id"

    comm = New SqlCommand(sql_3, conn)

    comm.Parameters.Add(New SqlParameter("@stu_id", SqlDbType.Int, 4))

    comm.Parameters("@stu_id")。Value = Session("stu_id")

    comm.ExecuteNonQuery()

    comm.Cancel()

    Response.Redirect("detail.aspx?stu_id='" & Session("stu_id") & "'")

    Else

    Label35.Text = "您还没有注册或账号密码错误"

    End If

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

    TextBox1.Text = ""

    TextBox2.Text = ""

    End Sub

最新评论共有 0 位网友发表了评论
发表评论
评论内容:不能超过250字,需审核,请自觉遵守互联网相关政策法规。
用户名: 密码:
匿名?
注册
栏目列表