registerform.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;
using MySchoolPrj.DAO;

namespace MySchoolPrj.Login
{
    public partial class RegisterForm : Form
    {
        public RegisterForm()
        {
            InitializeComponent();
        }
        //修改信息
        public bool JudgeAdd()
        {
            string Name = txtName.Text.Trim() ;
            string Pwd = txtpwd.Text;
            string Pwd1 = txtPwd1.Text;
            if (Name.Length != 0 && Pwd.Length != 0 && Pwd1.Length != 0)
            {
                if(Pwd==Pwd1){
                    return true;
                }else{ 
                    MessageBox .Show ("两次输入的密码不一致！");
                    txtpwd.Text = "";
                    txtPwd1.Text = "";
                    return false;
                }
            }
            else {
                MessageBox.Show("用户名，密码，确认密码不能为空！");
                return false;
            }
        
        }

        //提交信息
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (JudgeAdd())
            {
                try
                {
                    string userName = txtName.Text;
                    string pwd = txtpwd.Text;
                    string pwd1 = txtPwd1.Text;
                    int grade = cmbGrade.SelectedIndex + 1;

                                DBHelper.con.Open();
                                SqlCommand cmd = new SqlCommand();
                                cmd.Connection = DBHelper.con;
                                cmd.CommandType = CommandType.Text;
                                string sql = string.Format("insert into userInfo values('{0}','{1}','{2}')", userName, pwd, grade);
                                cmd.CommandText = sql;
                                cmd.ExecuteNonQuery();


                                MessageBox.Show("添加成功！", "提示！");
                                this.Close();
                            }
                            catch (Exception)
                            {

                                MessageBox.Show("用户名已经存在！", "提示！");
                                this.Close();
                            }
                            finally
                            {
                                DBHelper.con.Close();
                            }
                           
                        }

                    }
        //取消修改        
        private void btnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        //界面初始化信息
        private void RegisterForm_Load(object sender, EventArgs e)
        {
            cmbGrade.Items.AddRange(new string[]{ "学  生", "教  师", "管理员" });   //设置选择项
            cmbGrade.DropDownStyle = ComboBoxStyle.DropDownList;         //设置下拉框风格
            cmbGrade.SelectedIndex = 0;                                //默认选项
        }
    }
}