C#编写winform新增用户

1、首先将新增用户的页面设计好，小编这边水平有限，做了一个简易的新增用户页面。

2、在添加用戶事件下，先建立数据库的连接（我用的XML连接方式）。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.Xml;namespace ATE{ public partial class Usermanage : Form { private string Read_Xml(string path) { string Source = null; string m_connStr = null; XmlDocument doc = new XmlDocument(); doc.Load(path); XmlElement rootelem = doc.DocumentElement; XmlNodeList personnodes = rootelem.GetElementsByTagName("Data"); foreach (XmlNode node in personnodes) { Source = ((XmlElement)node).GetAttribute("Source"); XmlNodeList database = ((XmlElement)node).GetElementsByTagName("Base"); XmlNodeList dataUid = ((XmlElement)node).GetElementsByTagName("Uid"); XmlNodeList dataPwd = ((XmlElement)node).GetElementsByTagName("Pwd"); m_connStr = "Data Source=" + Source + ";Database=" + database[0].InnerText + ";Uid=" + dataUid[0].InnerText + ";Pwd=" + dataPwd[0].InnerText + ""; } return m_connStr; } public Usermanage() { InitializeComponent(); } private DataSet ds_source(string sqlstring) { SqlConnection conn = new SqlConnection(Read_Xml(Application.StartupPath + "\\Sqlconnection.xml")); SqlCommand cmd = new SqlCommand(sqlstring, conn); SqlDataAdapter dpt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); dpt.Fill(ds); return ds; } private DataTable dt_source(string sqlstr) { SqlConnection conn = new SqlConnection(Read_Xml(Application.StartupPath + "\\Sqlconnection.xml")); SqlCommand cmd = new SqlCommand(sqlstr, conn); SqlDataAdapter dpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); dpt.Fill(dt); return dt; }

3、“新增用戶”事件，首先检查是否存在该新增用户。SqlConnection conn = new SqlConnection(Read_Xml(Application.StartupPath + "\\Sqlconnection.xml")); conn.Open(); SqlCommand cmd1 = new SqlCommand("select count (*) from Employee where User_id='" + textBox1.Text.Trim() + "'", conn); int a = (int)cmd1.ExecuteScalar(); if (a == 1) { MessageBox.Show("该帐号已存在！", "提示"); }

4、如果当前新增用户不存在，首先检查用户名长度:

5、检查密码和重复密码设置是否正取。

6、通过以上步骤，整个新建用户完成，附上完整代码。using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.Xml;namespace ATE{ public partial class Usermanage : Form { private string Read_Xml(string path) { string Source = null; string m_connStr = null; XmlDocument doc = new XmlDocument(); doc.Load(path); XmlElement rootelem = doc.DocumentElement; XmlNodeList personnodes = rootelem.GetElementsByTagName("Data"); foreach (XmlNode node in personnodes) { Source = ((XmlElement)node).GetAttribute("Source"); XmlNodeList database = ((XmlElement)node).GetElementsByTagName("Base"); XmlNodeList dataUid = ((XmlElement)node).GetElementsByTagName("Uid"); XmlNodeList dataPwd = ((XmlElement)node).GetElementsByTagName("Pwd"); m_connStr = "Data Source=" + Source + ";Database=" + database[0].InnerText + ";Uid=" + dataUid[0].InnerText + ";Pwd=" + dataPwd[0].InnerText + ""; } return m_connStr; } public Usermanage() { InitializeComponent(); } private DataSet ds_source(string sqlstring) { SqlConnection conn = new SqlConnection(Read_Xml(Application.StartupPath + "\\Sqlconnection.xml")); SqlCommand cmd = new SqlCommand(sqlstring, conn); SqlDataAdapter dpt = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); dpt.Fill(ds); return ds; } private DataTable dt_source(string sqlstr) { SqlConnection conn = new SqlConnection(Read_Xml(Application.StartupPath + "\\Sqlconnection.xml")); SqlCommand cmd = new SqlCommand(sqlstr, conn); SqlDataAdapter dpt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); dpt.Fill(dt); return dt; } private void button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(Read_Xml(Application.StartupPath + "\\Sqlconnection.xml")); conn.Open(); SqlCommand cmd1 = new SqlCommand("select count (*) from Employee where User_id='" + textBox1.Text.Trim() + "'", conn); int a = (int)cmd1.ExecuteScalar(); if (a == 1) { MessageBox.Show("该帐号已存在！", "提示"); } else { string User_id = textBox1.Text.Trim().ToUpper(); string User_name = textBox2.Text.Trim(); string Depart = textBox3.Text.Trim(); string pwd = textBox4.Text.Trim(); if ((textBox1.Text.Length == 7) && (textBox4.Text.Trim() == textBox5.Text.Trim())) { SqlCommand cmd2 = new SqlCommand("insert into Employee values ('" + User_id + "','" + User_name + "','" + Depart + "','" + pwd + "')", conn); int j = (int)cmd2.ExecuteNonQuery(); if (j > 0) { MessageBox.Show("用户新增成功！请牢记！", "提示"); } else { MessageBox.Show("用户新增失败！请检查资料！", "提示"); } } else { MessageBox.Show("资料有误，请检查！", "提示"); } conn.Close(); } }