adduser.cs

不错的班级管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace _7计应的班级管理系统
{
    public partial class adduser : Form
    {
        public adduser()
        {
            InitializeComponent();
        }

        private void buttonok_Click(object sender, EventArgs e)
        {

            string userid = textBoxuid.Text.Trim();
            string password1 = textBoxpwd1.Text.Trim();
            string password2 = textBoxpwd2.Text.Trim();
            if (userid != "" && password1 != "" && password2 != "")
            {
                if (password1 == password2)
                {
                    try
                    {
                        SqlConnection conn = new SqlConnection("user id=sa;data source=localhost;integrated security=false;initial catalog=学生数据库1");
                        SqlDataAdapter da = new SqlDataAdapter("select * from login", conn);
                        DataSet ds = new DataSet();
                        ds.Clear();
                        da.Fill(ds, "login");
                        DataTable dt = ds.Tables["login"];
                        DataRow newrow = dt.NewRow();
                        newrow["用户名"] = userid;
                        newrow["密码"] = password1;
                        newrow["用户权限"] = comboBox1.Text.Trim();
                        dt.Rows.Add(newrow);
                        SqlCommandBuilder cb = new SqlCommandBuilder(da);
                        da.Update(ds, "login");
                        MessageBox.Show("成功!");
                        this.Close();
                    }
                    catch
                    {
                        MessageBox.Show("重复的用户名!");
                    }
                }
                else
                    MessageBox.Show("两次的密码不相同!");
            }
            else
                MessageBox.Show("帐号或密码不能为空!");
        }
    }
}