C#常用增删改查源码资料.docVIP

这个是添加的代码 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_C