successed.aspx.vb

用户登录新闻发布系统

Imports System.data
Imports System.Data.SqlClient
Public Class merror
    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 b1 As System.Web.UI.WebControls.Button
    Protected WithEvents Button1 As System.Web.UI.WebControls.Button
    Protected WithEvents Label2 As System.Web.UI.WebControls.Label
    Protected WithEvents Label3 As System.Web.UI.WebControls.Label

    '注意: 以下占位符声明是 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 b1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles b1.Click
        Dim St1 As String
        Dim St2 As String
        St1 = Session("username")
        St2 = Session("userpwd")
        Dim sqlstr As String = "server =cs007;uid =sa;pwd=;database=tt"
        Dim conn As New SqlConnection(sqlstr)
        conn.Open()
        Dim comm As SqlCommand
        comm = New SqlCommand("update admin set tingliu=0 where username='" & St1 & " 'and userpws= '" & St2 & "'", conn)
        comm.ExecuteNonQuery()
        Label2.Text = St1
        label3.text = St2
        conn.Close()
        Me.Response.Redirect("webform1.aspx")
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Me.Response.Redirect("changepwd.aspx")
    End Sub
End Class