c常用增删改查源码

1、这个是添加的代码 using System; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; namespace 学生成绩管理系统 public partial class studentluru : Form / CurrencyManager cmAmend; / SqlConnection sqlConnection1 = new SqlConnection(); public studentluru() InitializeComponent(); priv

2、ate 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 sa

3、ddress = 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 =

4、 ) 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=s

5、a;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.Ex

6、ecuteNonQuery(); 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_C

7、lick(object sender, EventArgs e) this.Dispose(); 这个是查询界面的代码 : using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; namespace 学生成绩管理系统 public partial class studentchaxun : Form DataTable dt = new DataTable(); string p

8、er; 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”中。您可以根据需要 移动或移除它。 / 数据绑定

9、 if (per = 超级用户 ) string sqlsel = select * from studentinfo ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; if (per = 普通用户 ) string sqlsel = select * from studentinfo where sno= + sno + ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; Da

10、taTable 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();

11、return dt; private void button1_Click(object sender, EventArgs e) string xuehao = comboBox1.Text; string sqlsel = select * from studentinfo where sno= + xuehao + ; else string xingming = comboBox2.Text; string sqlsel = select * from studentinfo where sname= + xingming + ; private void radioButton1_C

12、heckedChanged(object sender, EventArgs e) else 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; to

13、olStripButton3.Enabled = true; toolStripButton4.Enabled = true; / 首记录 private void toolStripButton1_Click(object sender, EventArgs e) cmAmend.Position = 0;/ 设置为 0. 回到首记录 checkstate(cmAmend.Position); / 上一条 private void toolStripButton2_Click(object sender, EventArgs e) cmAmend.Position-; checkstate(

14、cmAmend.Position); / 下一条 private void toolStripButton3_Click(object sender, EventArgs e) cmAmend.Position+; checkstate(cmAmend.Position); / 末记录 private void toolStripButton4_Click(object sender, EventArgs e) cmAmend.Position = cmAmend.Count - 1; checkstate(cmAmend.Position); 删除的代码 : using System; us

15、ing System.ComponentModel; using System.Data; using System.Drawing; using System.Text; namespace 学生成绩管理系统 public partial class studentshanchu : Form CurrencyManager cmAmend; public studentshanchu() InitializeComponent(); private void studentshanchu_Load(object sender, EventArgs e) / TODO:这行代码将数据加载到表

16、“ studentDataSet.studentinfo”中。您可以根据需要 移动或移除它。 / 数据绑定 string sqlsel = select * from studentinfo ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; DataTable bangding(string sqlsel) string connstr = server=.;uid=sa;pwd=sa;database=sc; using (SqlConnection conn = new SqlCo

17、nnection(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 = 4

18、50; else this.Height = 250; private void button1_Click(object sender, EventArgs e) if (MessageBox.Show( 你确定要删除该记录吗 , 询问 , MessageBoxButtons.OKCancel, MessageBoxIcon.Question) = DialogResult.OK) string connstr = server=.;uid=sa;pwd=sa;database=sc; using (SqlConnection conn = new SqlConnection(connstr

19、) 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.T

20、ext = ; textBox2.Text = ; textBox3.Text = textBox4.Text = textBox5.Text = ; textBox6.Text = ; textBox7.Text = ; textBox8.Text = ; textBox9.Text = ; MessageBox.Show(恭喜你已成功删除,温馨提示”); conn.Close(); 修改的代码 : using System; using System.ComponentModel; using System.Data; using System.Drawing; using System.

21、Text; 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) InitializeCompon

22、ent(); 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_Loa

23、d(object sender, EventArgs e) / 数据绑定 if (per = 超级用户 ) string sqlsel = select * from studentinfo order by sno asc ; DataTable dt = bangding(sqlsel); cmAmend = (CurrencyManager)BindingContextdt; if (per = 普通用户 ) string sqlsel = select *from studentinfo where sno= + sno + DataTable dt = bangding(sqlsel

24、); 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.Cl

25、ose(); 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 = tex

26、tBox6.Text; string sphone = textBox7.Text; string sqq = textBox8.Text; | textBox4.Text = | if (textBox2.Text = | textBox3.Text = textBox5.Text = ) if (textBox2.Text = ) MessageBox.Show(性 别 不 能为空,温 馨提示 MessageBoxButtons.OKCancel, MessageBoxIcon.Error); textBox2.Focus(); return; if (textBox3.Text = ) MessageBox.Show(年龄不 能为空,温 馨提示 MessageBo