C#窗体学生管理系统整套增删改查 主窗体：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace StudentManageSys
{
public partial class FrmMain : Form
{
public FrmMain()
{
InitializeComponent();
}
///
/// 退出按钮单击事件
///
/// 事件源
/// 事件参数
private void tsmiExit_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show(“确定要退出吗？”,“提示”,MessageBoxButtons.OKCancel,MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
Application.Exit();
}
else
{

        }}/// <summary>/// 查询学生信息单击事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void tsmiSearch_Click(object sender, EventArgs e){FrmSearch fs = new FrmSearch();fs.MdiParent = this;fs.Show();}/// <summary>/// 添加学生信息单击事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void tsmiAdd_Click(object sender, EventArgs e){FrmAdd fa = new FrmAdd();fa.MdiParent = this;fa.Show();}
}

}

**

增加：

**
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace StudentManageSys
{
public partial class FrmAdd : Form
{
DBhelper db = new DBhelper();
DataSet ds = new DataSet();
SqlDataAdapter adapter;
public FrmAdd()
{
InitializeComponent();
}
///
/// 保存按钮单击事件
///
///
///
private void btnSave_Click(object sender, EventArgs e)
{
//非空验证
if (CheckInput())
{
if (AddInfo())
{
MessageBox.Show(“添加成功”);
}
else
{
MessageBox.Show(“添加失败”);
}
}
else
{
MessageBox.Show(“请填写完整信息”);
}
//绑定CBO
BindCbo();
}
public void BindCbo()
{
StringBuilder sql = new StringBuilder();
sql.Append(“select * from Grade”);
adapter = db.GetAdapter(sql.ToString());
adapter.Fill(ds, “Grade”);
//添加一行
DataRow row = ds.Tables[“Grade”].NewRow();
row[0] = “-1”;
row[1] = “全部”;
ds.Tables[“Grade”].Rows.InsertAt(row, 0);

        this.cboGrade.DataSource = ds.Tables["Grade"];this.cboGrade.ValueMember = "GradeId";this.cboGrade.DisplayMember = "GradeName";}/// <summary>/// 非空验证/// </summary>/// <returns></returns>public bool CheckInput(){if (this.txtPwd.Text.Trim().Equals(String.Empty)|| this.cboGrade.Text.Trim().Equals("全部")|| this.txtName.Text.Trim().Equals(String.Empty)|| this.txtPhone.Text.Trim().Equals(String.Empty)){return false;}else{return true;}}/// <summary>/// 添加信息/// </summary>/// <returns></returns>public bool AddInfo(){StringBuilder sql = new StringBuilder();sql.AppendFormat(@"INSERT INTO [dbo].[Student]([LoginPwd],[StudentName],[Gender],[GradeId],[Phone],[Address],[Birthday],[Email])VALUES('{0}', '{1}', '{2}',{ 3},'{4}','{5}','{6}''{7}')",this.txtPwd.Text.Trim(),this.txtName.Text.Trim(),this.rdoMale.Checked == true,this.cboGrade.SelectedValue,this.txtPhone.Text.Trim(),this.txtAddress.Text.Trim(),this.txtBirthday.Text.Trim(),this.txtEmail.Text.Trim());int result = db.ExecuteNonQuery(sql.ToString());if (result >0){return true;}else{return false;}}/// <summary>/// 清空按钮/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void btnClear_Click(object sender, EventArgs e){foreach (Control control in Controls){if (control is TextBox){control.Text = "";}}this.cboGrade.SelectedIndex = 0;this.rdoMale.Checked = true;}/// <summary>/// 关闭按钮单击事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void btnClose_Click(object sender, EventArgs e){this.Close();}private void FrmAdd_Load(object sender, EventArgs e){}
}

}

查询

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

namespace StudentManageSys
{
public partial class FrmSearch : Form
{
//数据库帮助类
DBhelper db = new DBhelper();
//数据集
DataSet ds = new DataSet();
//适配器
SqlDataAdapter adapter;

    public FrmSearch(){InitializeComponent();}/// <summary>/// 窗体加载事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void FrmSearch_Load(object sender, EventArgs e){//绑定CBOBindCbo();//清除多余列this.dgvShow.AutoGenerateColumns = false;//绑定DgvBindDgv();//设置性别组合框默认选中第一项 this.cboGender.SelectedIndex = 0;}/// <summary>/// 绑定CBO/// </summary>public void BindCbo(){StringBuilder sql = new StringBuilder();sql.Append("select * from Grade");adapter = db.GetAdapter(sql.ToString());adapter.Fill(ds, "Grade");//添加一行DataRow row = ds.Tables["Grade"].NewRow();row[0] = "-1";row[1] = "全部";ds.Tables["Grade"].Rows.InsertAt(row,0);this.cboGrade.DataSource = ds.Tables["Grade"];this.cboGrade.ValueMember = "GradeId";this.cboGrade.DisplayMember = "GradeName";}/// <summary>/// 绑定Dgv/// </summary>public void BindDgv(){if (ds.Tables["StudentAndGrade"] != null){ds.Tables["StudentAndGrade"].Clear();}StringBuilder sql = new StringBuilder();sql.Append(@"select * from Grade,Studentwhere Grade.GradeId = Student.GradeId");adapter = db.GetAdapter(sql.ToString());adapter.Fill(ds, "StudentAndGrade");this.dgvShow.DataSource = ds.Tables["StudentAndGrade"];}/// <summary>/// 查询按钮单击事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void btnSearch_Click(object sender, EventArgs e){DataView dv = new DataView(ds.Tables["StudentAndGrade"]);if (!this.txtName.Text.Trim().Equals(String.Empty)&&this.cboGrade.Text.Trim().Equals("全部")&& this.cboGender.Text.Trim().Equals("全部")){//1dv.RowFilter = string.Format("StudentName like '%{0}%'",this.txtName.Text.Trim());}else if(this.txtName.Text.Trim().Equals(String.Empty) &&!this.cboGrade.Text.Trim().Equals("全部")&&this.cboGender.Text.Trim().Equals("全部")){//2dv.RowFilter = string.Format("GradeId = {0}",this.cboGrade.SelectedValue);}else if (this.txtName.Text.Trim().Equals(String.Empty) &&this.cboGrade.Text.Trim().Equals("全部")&& !this.cboGender.Text.Trim().Equals("全部")){//3dv.RowFilter = string.Format("Gender = '{0}'",this.cboGender.Text.Trim().Equals("男")?1:0);}else if (!this.txtName.Text.Trim().Equals(String.Empty) &&!this.cboGrade.Text.Trim().Equals("全部")&&this.cboGender.Text.Trim().Equals("全部")){//12dv.RowFilter = string.Format("StudentName like '%{0}%' and GradeId = {1}",this.txtName.Text.Trim(), this.cboGrade.SelectedValue);}else if (!this.txtName.Text.Trim().Equals(String.Empty) &&this.cboGrade.Text.Trim().Equals("全部")&&!this.cboGender.Text.Trim().Equals("全部")){//13dv.RowFilter = string.Format("StudentName like '%{0}%' and Gender = '{1}'",this.txtName.Text.Trim(), this.cboGender.Text.Trim().Equals("男") ? 1 : 0);}else if (this.txtName.Text.Trim().Equals(String.Empty) &&!this.cboGrade.Text.Trim().Equals("全部")&&!this.cboGender.Text.Trim().Equals("全部")){//23dv.RowFilter = string.Format("GradeId = {0} and Gender = '{1}'",this.cboGrade.SelectedValue, this.cboGender.Text.Trim().Equals("男") ? 1 : 0);}else if (this.txtName.Text.Trim().Equals(String.Empty) &&this.cboGrade.Text.Trim().Equals("全部")&& this.cboGender.Text.Trim().Equals("全部")){//123dv.RowFilter = string.Format("StudentName like '%{0}%' and GradeId = {1} and Gender = '{2}'",this.txtName.Text.Trim(),this.cboGrade.SelectedValue, this.cboGender.Text.Trim().Equals("男") ? 1 : 0);}this.dgvShow.DataSource = dv;}/// <summary>/// 删除单击事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void tsmiDelete_Click(object sender, EventArgs e){StringBuilder sql = new StringBuilder();sql.AppendFormat(@"DELETE FROM [dbo].[Student]WHERE StudentNo = { 0}",this.dgvShow.SelectedRows[0].Cells[0].Value.ToString());int result = db.ExecuteNonQuery(sql.ToString());if (result > 0){MessageBox.Show("删除成功");BindDgv();}else{MessageBox.Show("删除失败");}}/// <summary>/// 修改窗体/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void tsmiUpdate_Click(object sender, EventArgs e){FrmUpdate fu = new FrmUpdate();//传值fu.StudentNo = this.dgvShow.SelectedRows[0].Cells[0].Value.ToString();//指定修改窗体可以使用本窗体方法fu.fs = this;fu.Show();}
}

}

修改

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

namespace StudentManageSys
{
public partial class FrmUpdate : Form
{
//查询窗体（定时刷新）
public FrmSearch fs;

    DBhelper db = new DBhelper();DataSet ds = new DataSet();SqlDataAdapter adapter;//传值变量public string StudentNo;public FrmUpdate(){InitializeComponent();}/// <summary>/// 关闭按钮单击事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void btnClose_Click(object sender, EventArgs e){this.Close();}/// <summary>/// 清空按钮单击事件/// </summary>/// <param name="sender">事件源</param>/// <param name="e">事件参数</param>private void btnClear_Click(object sender, EventArgs e){this.txtAddress.Text.Trim();this.txtBirthday.Text.Trim();this.txtEmail.Text.Trim();this.txtName.Text.Trim();this.txtPhone.Text.Trim();this.txtPwd.Text.Trim();this.cboGrade.SelectedIndex = 0;this.rdoMale.Checked = true;}/// <summary>/// 保存按钮单击事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void btnSave_Click(object sender, EventArgs e){//非空验证if (CheckInput()){//修改if (UpdateInfo()){MessageBox.Show("修改成功");fs.BindDgv();//刷新this.Close();}else{MessageBox.Show("修改失败");}}else{MessageBox.Show("请填写完整信息");}//绑定CBOBindCbo();}public void BindCbo(){StringBuilder sql = new StringBuilder();sql.Append("select * from Grade");adapter = db.GetAdapter(sql.ToString());adapter.Fill(ds, "Grade");//添加一行DataRow row = ds.Tables["Grade"].NewRow();row[0] = "-1";row[1] = "全部";ds.Tables["Grade"].Rows.InsertAt(row, 0);this.cboGrade.DataSource = ds.Tables["Grade"];this.cboGrade.ValueMember = "GradeId";this.cboGrade.DisplayMember = "GradeName";}/// <summary>/// 非空验证/// </summary>/// <returns></returns>public bool CheckInput(){if (this.txtPwd.Text.Trim().Equals(String.Empty)|| this.cboGrade.Text.Trim().Equals("全部")|| this.txtName.Text.Trim().Equals(String.Empty)|| this.txtPhone.Text.Trim().Equals(String.Empty)){return false;}else{return true;}}/// <summary>/// 添加信息/// </summary>/// <returns></returns>public bool UpdateInfo(){StringBuilder sql = new StringBuilder();sql.AppendFormat(@"UPDATE [dbo].[Student]SET [LoginPwd] = '{0}',[StudentName] = '{1}',[Gender] = '{2}',[GradeId] = {3},[Phone] = '{4}',[Address] = '{5}',[Birthday] = '{6}',[Email] = '{7}'WHERE StudentNo = {8})",this.txtPwd.Text.Trim(),this.txtName.Text.Trim(),this.rdoMale.Checked == true,this.cboGrade.SelectedValue,this.txtPhone.Text.Trim(),this.txtAddress.Text.Trim(),this.txtBirthday.Text.Trim(),this.txtEmail.Text.Trim(),StudentNo);int result = db.ExecuteNonQuery(sql.ToString());if (result > 0){return true;}else{return false;}}/// <summary>/// 窗体加载事件/// </summary>/// <param name="sender"></param>/// <param name="e"></param>private void FrmUpdate_Load(object sender, EventArgs e){BindCbo();this.txtStudentNo.Text = StudentNo;GetInfoByStudentNo();}/// <summary>/// 通过学号查询学生信息/// </summary>public void GetInfoByStudentNo(){StringBuilder sql = new StringBuilder();sql.AppendFormat(@"select * from Studentwhere StudentNo = {0}",StudentNo);SqlDataReader reader = db.ExecuteReader(sql.ToString());while (reader.Read()){string Loginpwd = reader[1].ToString();string StudentName = reader[2].ToString();string Gender = reader[3].ToString();string GradeId = reader[4].ToString();string Phone = reader[5].ToString();string Address = reader[6].ToString();string Birthday = reader[7].ToString();string Email = reader[8].ToString();this.txtPwd.Text = Loginpwd;this.txtName.Text = StudentName;//性别单选按钮if (Gender.Equals("1")){this.rdoMale.Checked = true;}else{this.rdoMale.Checked = false;}//年级框if (GradeId.Equals("1")){this.cboGrade.SelectedIndex = 1;}else if (GradeId.Equals("2")){this.cboGrade.SelectedIndex = 2;}else if (GradeId.Equals("3")){this.cboGrade.SelectedIndex = 3;}this.txtPhone.Text = Phone;this.txtAddress.Text = Address;this.txtBirthday.Text = Birthday;this.txtEmail.Text = Email;}reader.Close();}
}

}

数据库帮助类：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace StudentManageSys
{
class DBhelper
{
private string connString = “Data Source=.;Initial Catalog=MySchool;Integrated Security=True”;
private SqlConnection conn;

    public SqlConnection Conn{get{if (this.conn == null){conn = new SqlConnection(connString);}return conn;}}/// <summary>/// 打开数据库/// </summary>public void OpenConnection(){if (this.Conn.State == ConnectionState.Broken){this.Conn.Close();this.Conn.Open();}if (this.Conn.State == ConnectionState.Closed){this.Conn.Open();}}/// <summary>/// 关闭数据库/// </summary>public void CloseConnection(){if (this.Conn.State == ConnectionState.Broken||this.Conn.State == ConnectionState.Open){this.Conn.Close();}}/// <summary>/// 增删改/// </summary>/// <param name="sql">SQL语句</param>/// <returns>受影响行数</returns>public int ExecuteNonQuery(string sql){int result = 0;try{this.OpenConnection();SqlCommand comm = new SqlCommand(sql, Conn);result = comm.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);return -1;}finally{this.CloseConnection();}return result;}/// <summary>/// 查询单行单列/// </summary>/// <param name="sql">SQL语句</param>/// <returns>受影响行数</returns>public object ExecuteScalar(string sql){object result = null;try{this.OpenConnection();SqlCommand comm = new SqlCommand(sql, Conn);result = comm.ExecuteScalar();}catch (Exception ex){MessageBox.Show(ex.Message);return null;}finally{this.CloseConnection();}return result;}/// <summary>/// 查询多行多列/// </summary>/// <param name="sql">SQL语句</param>/// <returns>受影响行数</returns>public SqlDataReader ExecuteReader(string sql){SqlDataReader reader = null;try{this.OpenConnection();SqlCommand comm = new SqlCommand(sql, Conn);reader = comm.ExecuteReader(CommandBehavior.CloseConnection);}catch (Exception ex){MessageBox.Show(ex.Message);return null;}return reader;}/// <summary>/// 获取适配器对象/// </summary>/// <param name="sql">SQL语句</param>/// <returns>适配器对象</returns>public SqlDataAdapter GetAdapter(string sql){try{SqlDataAdapter adapter = new SqlDataAdapter(sql, Conn);return adapter;}catch (Exception ex){MessageBox.Show(ex.Message);throw;}}
}

}