C#常用增删改查源码.doc

这个是添加的代码 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 学生成绩管理系统 public partial class studentluru : Form / CurrencyManager cmAmend; / SqlConnection sqlConnection1 = new SqlConnection(); public studentluru() InitializeComponent(); private void studentluru_Load(object sender, EventArgs e) /录入 private void button5_Click(object sender, EventArgs e) string sno = textBox1.Text; string sname = textBox2.Text; string ssex = textBox3.Text; string sage = textBox4.Text; string sclass = textBox5.Text; string sdept = textBox6.Text; string saddress = textBox7.Text; string sphone = textBox8.Text; string sqq = textBox9.Text; if (textBox1.Text = | textBox2.Text = | textBox5.Text = ) if (textBox1.Text = ) MessageBox.Show(学号不能为空, 警告提示, MessageBoxButtons.OKCancel, MessageBoxIcon.Error); textBox1.Focus(); return; if (textBox2.Text = ) MessageBox.Show(姓名不能为空, 警告提示, MessageBoxButtons.OKCancel, MessageBoxIcon.Error); textBox2.Focus(); return; if (textBox5.Text = ) MessageBox.Show(班级不能为空, 警告提示, MessageBoxButtons.OKCancel, MessageBoxIcon.Error); textBox5.Focus(); return; else string connstr = server=IT32;uid=sa;pwd=sa;database=sc; try SqlConnection conn = new SqlConnection(connstr); conn.Open(); string sqlinsert = insert into studentinfo values( + sno + , + sname + , + ssex + , + sage + , + sclass + , + sdept + , + saddress + , + sphone + , + sqq + ); SqlCommand sc = new SqlCommand(sqlinsert, conn); sc.ExecuteNonQuery(); textBox1.Text = ; textBox2.Text = ; textBox3.Text = ; textBox4.Text = ; textBox5.Text = ; textBox6.Text = ; textBox7.Text = ; textBox8.Text = ; textBox9.Text = ; MessageBox.Show(数据已经添加成功, 温馨提示); conn.Close(); catch (Exception ex) MessageBox.Show(ex.ToString(); private void button8_Click(object sender, EventArgs e) this.Dispose(); 这个是查询界面的代码: 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 学生成绩管理系统 public partial class studentchaxun : Form DataTable dt = new DataTable(); string per; string sno; CurrencyManager cmAmend; public studentchaxun() InitializeComponent(); public studentchaxun(string k, string s) InitializeComponent(); per = k; sno = s; private void studentchaxun_Load(object sender, EventArgs e) / TODO: 这行代码将数据加载到表“studentDataSet.studentinfo”中。您可以根据需要移动或移除它。 /this.studentinfoTableAdapter.Fill(this.studentDataSet.studentinfo); /数据绑定 if (per = 超级用户) string sqlsel = select * from studentinfo ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; this.dataGridView1.DataSource = dt; boBox1.DataSource = dt; boBox1.DisplayMember = sno; boBox2.DataSource = dt; boBox2.DisplayMember = sname; if (per = 普通用户) string sqlsel = select * from studentinfo where sno= + sno + ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; this.dataGridView1.DataSource = dt; boBox1.DataSource = dt; boBox1.DisplayMember = sno; boBox2.Enabled = false; this.radioButton2.Enabled = false; /this.toolStripButton1.Enabled = false; /this.toolStripButton2.Enabled = false; /this.toolStripButton3.Enabled = false; /this.toolStripButton4.Enabled = false; /boBox2.DataSource = dt; /boBox2.DisplayMember = sname; DataTable bangding(string sqlsel) string connstr = server=.;uid=sa;pwd=sa;database=sc; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn); da.Fill(ds, coust); DataTable dt = ds.Tablescoust; conn.Close(); return dt; private void button1_Click(object sender, EventArgs e) if (this.radioButton1.Checked = true) string xuehao = comboBox1.Text; string sqlsel = select * from studentinfo where sno= + xuehao + ; this.dataGridView1.DataSource = bangding(sqlsel); else string xingming = comboBox2.Text; string sqlsel = select * from studentinfo where sname= + xingming + ; this.dataGridView1.DataSource = bangding(sqlsel); private void radioButton1_CheckedChanged(object sender, EventArgs e) if (this.radioButton1.Checked = true) boBox1.Enabled = true; boBox2.Enabled = false; else boBox1.Enabled = false; boBox2.Enabled = true; private void checkstate(int pos) if (pos = 0) toolStripButton1.Enabled = false; toolStripButton2.Enabled = false; toolStripButton3.Enabled = true; toolStripButton4.Enabled = true; else toolStripButton1.Enabled = true; toolStripButton2.Enabled = true; toolStripButton3.Enabled = true; toolStripButton4.Enabled = true; /首记录 private void toolStripButton1_Click(object sender, EventArgs e) cmAmend.Position = 0;/设置为0.回到首记录 this.dataGridView1.Select(); checkstate(cmAmend.Position); /上一条 private void toolStripButton2_Click(object sender, EventArgs e) cmAmend.Position-; this.dataGridView1.Select(); checkstate(cmAmend.Position); /下一条 private void toolStripButton3_Click(object sender, EventArgs e) cmAmend.Position+; this.dataGridView1.Select(); checkstate(cmAmend.Position); /末记录 private void toolStripButton4_Click(object sender, EventArgs e) cmAmend.Position = cmAmend.Count - 1; this.dataGridView1.Select(); checkstate(cmAmend.Position); 删除的代码: 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 学生成绩管理系统 public partial class studentshanchu : Form CurrencyManager cmAmend; public studentshanchu() InitializeComponent(); private void studentshanchu_Load(object sender, EventArgs e) / TODO: 这行代码将数据加载到表“studentDataSet.studentinfo”中。您可以根据需要移动或移除它。 /this.studentinfoTableAdapter.Fill(this.studentDataSet.studentinfo); /数据绑定 string sqlsel = select * from studentinfo ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; this.dataGridView1.DataSource = dt; this.textBox1.DataBindings.Add(text, dt, sno); this.textBox2.DataBindings.Add(text, dt, sname); this.textBox3.DataBindings.Add(text, dt, ssex); this.textBox4.DataBindings.Add(text, dt, sage); this.textBox5.DataBindings.Add(text, dt, sclass); this.textBox6.DataBindings.Add(text, dt, sdept); this.textBox7.DataBindings.Add(text, dt, saddress); this.textBox8.DataBindings.Add(text, dt, sphone); this.textBox9.DataBindings.Add(text, dt, sqq); DataTable bangding(string sqlsel) string connstr = server=.;uid=sa;pwd=sa;database=sc; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn); da.Fill(ds, coust); DataTable dt = ds.Tablescoust; conn.Close(); return dt; private void checkBox1_CheckedChanged(object sender, EventArgs e) if (checkBox1.Checked = true) this.Height = 450; else this.Height = 250; private void button1_Click(object sender, EventArgs e) if (MessageBox.Show(你确定要删除该记录吗, 询问, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) = DialogResult.OK) int pos = this.dataGridView1.CurrentCell.RowIndex; /获取该行 string connstr = server=.;uid=sa;pwd=sa;database=sc; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); DataSet ds = new DataSet(); string sqlset = select * from studentinfo; /数据集 SqlDataAdapter da = new SqlDataAdapter(sqlset, conn); da.Fill(ds, coust); DataTable dt = ds.Tablescoust; SqlCommandBuilder cb = new SqlCommandBuilder(da); dt.Rowspos.Delete(); da.Update(ds, coust); textBox1.Text = ; textBox2.Text = ; textBox3.Text = ; textBox4.Text = ; textBox5.Text = ; textBox6.Text = ; textBox7.Text = ; textBox8.Text = ; textBox9.Text = ; this.dataGridView1.DataSource = bangding(sqlset); MessageBox.Show(恭喜你已成功删除,温馨提示); conn.Close(); 修改的代码: 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 学生成绩管理系统 public partial class studentxiugai : Form string connstr = server=.;uid=sa;pwd=sa;database=sc; string per; string sno; CurrencyManager cmAmend; public studentxiugai() InitializeComponent(); public studentxiugai(string k,string s) InitializeComponent(); per = k; sno = s; private void checkBox1_CheckedChanged(object sender, EventArgs e) if (checkBox1.Checked = true) /this.Height = 450; comboBox1.Enabled = false; textBox1.Enabled = false; else /this.Height = 250; comboBox1.Enabled = true; textBox1.Enabled = true; private void studentxiugai_Load(object sender, EventArgs e) /数据绑定 if (per = 超级用户) string sqlsel = select * from studentinfo order by sno asc ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; boBox1.DataSource = dt; boBox1.DisplayMember = sno; this.textBox1.DataBindings.Add(text, dt, sname); this.textBox2.DataBindings.Add(text, dt, ssex); this.textBox3.DataBindings.Add(text, dt, sage); this.textBox4.DataBindings.Add(text, dt, sclass); this.textBox5.DataBindings.Add(text, dt, sdept); this.textBox6.DataBindings.Add(text, dt, saddress); this.textBox7.DataBindings.Add(text, dt, sphone); this.textBox8.DataBindings.Add(text, dt, sqq); if (per = 普通用户) string sqlsel = select *from studentinfo where sno= + sno + ; DataTable dt = bangding(sqlsel); boBox1.DataSource = dt; boBox1.DisplayMember = sno; this.textBox1.DataBindings.Add(text, dt, sname); this.textBox2.DataBindings.Add(text, dt, ssex); this.textBox3.DataBindings.Add(text, dt, sage); this.textBox4.DataBindings.Add(text, dt, sclass); this.textBox5.DataBindings.Add(text, dt, sdept); this.textBox6.DataBindings.Add(text, dt, saddress); this.textBox7.DataBindings.Add(text, dt, sphone); this.textBox8.DataBindings.Add(text, dt, sqq); DataTable bangding(string sqlsel) / string connstr = server=.;uid=sa;pwd=sa;database=sc; using (SqlConnection conn = new SqlConnection(connstr) conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sqlsel, conn); da.Fill(ds, coust); DataTable dt = ds.Tablescoust; conn.Close(); return dt; private void button1_Click(object sender, EventArgs e) if (checkBox1.Checked = true) string sno = comboBox1.Text; string sname = textBox1.Text; string sex = textBox2.Text; string age = textBox3.Text; string sclass = textBox4.Text; string sdept = textBox5.Text; string saddress = textBox6.Text; string sphone = textBox7.Text