C#常用增刪改查源碼

-.z.這個是添加的代碼usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Te*t;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace學生成績管理系統(tǒng){publicpartialclassstudentluru:Form{//CurrencyManagercmAmend;//SqlConnectionsqlConnection1=newSqlConnection();publicstudentluru(){Initializeponent();}privatevoidstudentluru_Load(objectsender,EventArgse){}//錄入privatevoidbutton5_Click(objectsender,EventArgse){stringsno=te*tBo*1.Te*t;stringsname=te*tBo*2.Te*t;stringsse*=te*tBo*3.Te*t;stringsage=te*tBo*4.Te*t;stringsclass=te*tBo*5.Te*t;stringsdept=te*tBo*6.Te*t;stringsaddress=te*tBo*7.Te*t;stringsphone=te*tBo*8.Te*t;stringsqq=te*tBo*9.Te*t;if(te*tBo*1.Te*t==""||te*tBo*2.Te*t==""||te*tBo*5.Te*t==""){if(te*tBo*1.Te*t==""){MessageBo*.Show("**不能為空","警告提示",MessageBo*Buttons.OKCancel,MessageBo*Icon.Error);te*tBo*1.Focus();return;}if(te*tBo*2.Te*t==""){MessageBo*.Show("不能為空","警告提示",MessageBo*Buttons.OKCancel,MessageBo*Icon.Error);te*tBo*2.Focus();return;}if(te*tBo*5.Te*t==""){MessageBo*.Show("班級不能為空","警告提示",MessageBo*Buttons.OKCancel,MessageBo*Icon.Error);te*tBo*5.Focus();return;}}else{stringconnstr="server=IT32;uid=sa;pwd='sa';database=sc;";try{SqlConnectionconn=newSqlConnection(connstr);conn.Open();stringsqlinsert="insertintostudentinfovalues('"+sno+"','"+sname+"','"+sse*+"','"+sage+"','"+sclass+"','"+sdept+"','"+saddress+"','"+sphone+"','"+sqq+"')";Sqlmandsc=newSqlmand(sqlinsert,conn);sc.E*ecuteNonQuery();te*tBo*1.Te*t="";te*tBo*2.Te*t="";te*tBo*3.Te*t="";te*tBo*4.Te*t="";te*tBo*5.Te*t="";te*tBo*6.Te*t="";te*tBo*7.Te*t="";te*tBo*8.Te*t="";te*tBo*9.Te*t="";MessageBo*.Show("數(shù)據(jù)已經添加成功","溫馨提示");conn.Close();}catch(E*ceptione*){MessageBo*.Show(e*.ToString());}}}privatevoidbutton8_Click(objectsender,EventArgse){this.Dispose();}}}這個是查詢界面的代碼:usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Te*t;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace學生成績管理系統(tǒng){publicpartialclassstudentcha*un:Form{DataTabledt=newDataTable();stringper;stringsno;CurrencyManagercmAmend;publicstudentcha*un(){Initializeponent();}publicstudentcha*un(stringk,strings){Initializeponent();per=k;sno=s;}privatevoidstudentcha*un_Load(objectsender,EventArgse){//TODO:這行代碼將數(shù)據(jù)加載到表“studentDataSet.studentinfo”中。您可以根據(jù)需要移動或移除它。//this.studentinfoTableAdapter.Fill(this.studentDataSet.studentinfo);//數(shù)據(jù)綁定if(per=="超級用戶"){stringsqlsel="select*fromstudentinfo";DataTabledt=bangding(sqlsel);cmAmend=(CurrencyManager)BindingConte*t[dt];this.dataGridView1.DataSource=dt;this.boBo*1.DataSource=dt;this.boBo*1.DisplayMember="sno";this.boBo*2.DataSource=dt;this.boBo*2.DisplayMember="sname";}if(per=="普通用戶"){stringsqlsel="select*fromstudentinfowheresno='"+sno+"'";DataTabledt=bangding(sqlsel);cmAmend=(CurrencyManager)BindingConte*t[dt];this.dataGridView1.DataSource=dt;this.boBo*1.DataSource=dt;this.boBo*1.DisplayMember="sno";this.boBo*2.Enabled=false;this.radioButton2.Enabled=false;//this.toolStripButton1.Enabled=false;//this.toolStripButton2.Enabled=false;//this.toolStripButton3.Enabled=false;//this.toolStripButton4.Enabled=false;//this.boBo*2.DataSource=dt;//this.boBo*2.DisplayMember="sname";}}DataTablebangding(stringsqlsel){stringconnstr="server=.;uid=sa;pwd=sa;database=sc";using(SqlConnectionconn=newSqlConnection(connstr)){conn.Open();DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);da.Fill(ds,"coust");DataTabledt=ds.Tables["coust"];conn.Close();returndt;}}privatevoidbutton1_Click(objectsender,EventArgse){if(this.radioButton1.Checked==true){string*uehao=boBo*1.Te*t;stringsqlsel="select*fromstudentinfowheresno='"+*uehao+"'";this.dataGridView1.DataSource=bangding(sqlsel);}else{string*ingming=boBo*2.Te*t;stringsqlsel="select*fromstudentinfowheresname='"+*ingming+"'";this.dataGridView1.DataSource=bangding(sqlsel);}}privatevoidradioButton1_CheckedChanged(objectsender,EventArgse){if(this.radioButton1.Checked==true){this.boBo*1.Enabled=true;this.boBo*2.Enabled=false;}else{this.boBo*1.Enabled=false;this.boBo*2.Enabled=true;}}privatevoidcheckstate(intpos){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;}}//首記錄privatevoidtoolStripButton1_Click(objectsender,EventArgse){cmAmend.Position=0;//設置為0.回到首記錄this.dataGridView1.Select();checkstate(cmAmend.Position);}//上一條privatevoidtoolStripButton2_Click(objectsender,EventArgse){cmAmend.Position--;this.dataGridView1.Select();checkstate(cmAmend.Position);}//下一條privatevoidtoolStripButton3_Click(objectsender,EventArgse){cmAmend.Position++;this.dataGridView1.Select();checkstate(cmAmend.Position);}//末記錄privatevoidtoolStripButton4_Click(objectsender,EventArgse){cmAmend.Position=cmAmend.Count-1;this.dataGridView1.Select();checkstate(cmAmend.Position);}}}刪除的代碼:usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Te*t;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace學生成績管理系統(tǒng){publicpartialclassstudentshanchu:Form{CurrencyManagercmAmend;publicstudentshanchu(){Initializeponent();}privatevoidstudentshanchu_Load(objectsender,EventArgse){//TODO:這行代碼將數(shù)據(jù)加載到表“studentDataSet.studentinfo”中。您可以根據(jù)需要移動或移除它。//this.studentinfoTableAdapter.Fill(this.studentDataSet.studentinfo);//數(shù)據(jù)綁定stringsqlsel="select*fromstudentinfo";DataTabledt=bangding(sqlsel);cmAmend=(CurrencyManager)BindingConte*t[dt];this.dataGridView1.DataSource=dt;this.te*tBo*1.DataBindings.Add("te*t",dt,"sno");this.te*tBo*2.DataBindings.Add("te*t",dt,"sname");this.te*tBo*3.DataBindings.Add("te*t",dt,"sse*");this.te*tBo*4.DataBindings.Add("te*t",dt,"sage");this.te*tBo*5.DataBindings.Add("te*t",dt,"sclass");this.te*tBo*6.DataBindings.Add("te*t",dt,"sdept");this.te*tBo*7.DataBindings.Add("te*t",dt,"saddress");this.te*tBo*8.DataBindings.Add("te*t",dt,"sphone");this.te*tBo*9.DataBindings.Add("te*t",dt,"sqq");}DataTablebangding(stringsqlsel){stringconnstr="server=.;uid=sa;pwd=sa;database=sc";using(SqlConnectionconn=newSqlConnection(connstr)){conn.Open();DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);da.Fill(ds,"coust");DataTabledt=ds.Tables["coust"];conn.Close();returndt;}}privatevoidcheckBo*1_CheckedChanged(objectsender,EventArgse){if(checkBo*1.Checked==true){this.Height=450;}else{this.Height=250;}}privatevoidbutton1_Click(objectsender,EventArgse){if(MessageBo*.Show("你確定要刪除該記錄嗎","詢問",MessageBo*Buttons.OKCancel,MessageBo*Icon.Question)==DialogResult.OK){intpos=this.dataGridView1.CurrentCell.RowInde*;//獲取該行stringconnstr="server=.;uid=sa;pwd=sa;database=sc";using(SqlConnectionconn=newSqlConnection(connstr)){conn.Open();DataSetds=newDataSet();stringsqlset="select*fromstudentinfo";//數(shù)據(jù)集SqlDataAdapterda=newSqlDataAdapter(sqlset,conn);da.Fill(ds,"coust");DataTabledt=ds.Tables["coust"];SqlmandBuildercb=newSqlmandBuilder(da);dt.Rows[pos].Delete();da.Update(ds,"coust");te*tBo*1.Te*t="";te*tBo*2.Te*t="";te*tBo*3.Te*t="";te*tBo*4.Te*t="";te*tBo*5.Te*t="";te*tBo*6.Te*t="";te*tBo*7.Te*t="";te*tBo*8.Te*t="";te*tBo*9.Te*t="";this.dataGridView1.DataSource=bangding(sqlset);MessageBo*.Show("恭喜你已成功刪除","溫馨提示");conn.Close();}}}}}修改的代碼:usingSystem;usingSystem.Collections.Generic;usingSystem.ponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Te*t;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespace學生成績管理系統(tǒng){publicpartialclassstudent*iugai:Form{stringconnstr="server=.;uid=sa;pwd=sa;database=sc";stringper;stringsno;CurrencyManagercmAmend;publicstudent*iugai(){Initializeponent();}publicstudent*iugai(stringk,strings){Initializeponent();per=k;sno=s;}privatevoidcheckBo*1_CheckedChanged(objectsender,EventArgse){if(checkBo*1.Checked==true){//this.Height=450;boBo*1.Enabled=false;te*tBo*1.Enabled=false;}else{//this.Height=250;boBo*1.Enabled=true;te*tBo*1.Enabled=true;}}privatevoidstudent*iugai_Load(objectsender,EventArgse){//數(shù)據(jù)綁定if(per=="超級用戶"){stringsqlsel="select*fromstudentinfoorderbysnoasc";DataTabledt=bangding(sqlsel);cmAmend=(CurrencyManager)BindingConte*t[dt];this.boBo*1.DataSource=dt;this.boBo*1.DisplayMember="sno";this.te*tBo*1.DataBindings.Add("te*t",dt,"sname");this.te*tBo*2.DataBindings.Add("te*t",dt,"sse*");this.te*tBo*3.DataBindings.Add("te*t",dt,"sage");this.te*tBo*4.DataBindings.Add("te*t",dt,"sclass");this.te*tBo*5.DataBindings.Add("te*t",dt,"sdept");this.te*tBo*6.DataBindings.Add("te*t",dt,"saddress");this.te*tBo*7.DataBindings.Add("te*t",dt,"sphone");this.te*tBo*8.DataBindings.Add("te*t",dt,"sqq");}if(per=="普通用戶"){stringsqlsel="select*fromstudentinfowheresno='"+sno+"'";DataTabledt=bangding(sqlsel);this.boBo*1.DataSource=dt;this.boBo*1.DisplayMember="sno";this.te*tBo*1.DataBindings.Add("te*t",dt,"sname");this.te*tBo*2.DataBindings.Add("te*t",dt,"sse*");this.te*tBo*3.DataBindings.Add("te*t",dt,"sage");this.te*tBo*4.DataBindings.Add("te*t",dt,"sclass");this.te*tBo*5.DataBindings.Add("te*t",dt,"sdept");this.te*tBo*6.DataBindings.Add("te*t",dt,"saddress");this.te*tBo*7.DataBindings.Add("te*t",dt,"sphone");this.te*tBo*8.DataBindings.Add("te*t",dt,"sqq");}}DataTablebangding(stringsqlsel){//stringconnstr="server=.;uid=sa;pwd=sa;database=sc";using(SqlConnectionconn=newSqlConnection(connstr)){conn.Open();DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter(sqlsel,conn);da.Fill(ds,"coust");DataTabledt=ds.Tables["coust"];conn.Close();returndt;}}privatevoidbutton1_Click(objectsender,EventArgse){if(checkBo*1.Checked==true){stringsno=boBo*1.Te*t;stringsname=te*tBo*1.Te*t;stringse*=te*tBo*2.Te*t;stringage=te*tBo*3.Te*t;stringsclass=te*tBo*4.Te*t;stringsdept=te*tBo*5.Te*t;stringsaddress=te*tBo*6.Te*t;stringsphone=te*tBo*7.Te*t;stringsqq=te*tBo*8.Te*t;if(te*tBo*2.Te*t==""||te*tBo*3.Te*t