adduser.aspx.vb

基于.net科研管理信息系统 毕业设计参考代码

Imports System.Data
Imports System.Data.SqlClient
Partial Class WebForm2
    Inherits System.Web.UI.Page
  

   


#Region " Web 窗体设计器生成的代码 "

        '该调用是 Web 窗体设计器所必需的。
        <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents Reset1 As System.Web.UI.HtmlControls.HtmlInputButton

        '注意: 以下占位符声明是 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 connectionstring As String
    Dim mycmd As SqlCommand

    Dim sql As String
    Dim conn As SqlConnection
    Dim ds As DataSet = New DataSet
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        '在此处放置初始化页的用户代码
        conn = New SqlConnection(connectionstring)
        conn.ConnectionString = "server=HP-PC;Database=SRM;uid=sa;pwd=sa;"
        conn.Open()
        If Not IsPostBack Then
            Dim dbcommand As SqlDataAdapter
            dbcommand = New SqlDataAdapter("select  group_id  from   sci_group  ", conn)
            dbcommand.Fill(ds)
            DropDownList1.DataSource = ds.Tables(0)
            DropDownList1.DataTextField = ds.Tables(0).Columns(0).ColumnName
            DropDownList1.DataValueField = ds.Tables(0).Columns(0).ColumnName
            DropDownList1.DataBind()
            DropDownList1.Items.Insert(0, New ListItem("请选择", "0"))
        End If
        sql = "select * from sci_user where user_id='" + user_id.Value + "'"
        Dim da As SqlDataAdapter = New SqlDataAdapter(sql, conn)
        da.Fill(ds)
    End Sub
    Private Sub Submit1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.ServerClick
        If user_id.Value = "" Then
            Response.Write("<script>alert('请输入用户名！ ');</script>")
        ElseIf (password.Value = "" Or name.Value = "" Or level.Value = 0 Or DropDownList1.SelectedValue = 0 Or role.Value = 0) Then
            Response.Write("<script>alert('输入信息不完整！ ');</script>")
        ElseIf (ds.Tables(0).Rows.Count <> 0) Then
            Response.Write("<script>alert('该用户已存在！');</script>")
        Else
            sql = "insert into sci_user(user_id,password,user_name,level,group_id,role)values('" + user_id.Value + "',  '" + password.Value + "', '" + name.Value + "', '" + level.Value + "','" + DropDownList1.SelectedValue + "', '" + role.Value + "') "
            mycmd = New SqlCommand(sql, conn)
            mycmd.ExecuteNonQuery()
            mycmd.Dispose()
            conn.Close()
            Response.Write("<script>alert('添加成功！！！');</script>")
            conn.Close()
            user_id.Value = ""
            password.Value = ""
            name.Value = ""
            level.Value = 0
            DropDownList1.SelectedValue = 0
            role.Value = 0
        End If
    End Sub
    Private Sub reset_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles reset.ServerClick
        user_id.Value = ""
        password.Value = ""
        name.Value = ""
        level.Value = ""
        DropDownList1.SelectedValue = ""
        role.Value = ""
    End Sub
    Private Sub Button1_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.ServerClick
        Response.Redirect("userinfor.aspx")
    End Sub
    Private Sub Submit2_ServerClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit2.ServerClick
       
        If (ds.Tables(0).Rows.Count <> 0) Then
            Response.Write("<script>alert('该用户已存在！');</script>")
        Else
            Response.Write("<script>alert('不存在该用户,请继续添加！');</script>")
        End If
    End Sub
End Class