實(shí)驗(yàn)-數(shù)據(jù)庫(kù)操作綜合三

綜合實(shí)驗(yàn)studentstudent表中刪除相應(yīng)記錄。2、在實(shí)驗(yàn)報(bào)告中【待分析實(shí)驗(yàn)步驟】的設(shè)計(jì)和代碼存在的不足之處2masterstudent。其表結(jié)構(gòu)如下表所示。usecreatetablestudent(snochar(10)primarykey,snamevarchar(50)notnull, char(2)notnull,sageintnotsdeptvarchar(20)not)insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( 1、打開(kāi)VS2008，新建一個(gè)項(xiàng)目，在新建項(xiàng)目框中，模板選擇“Windows應(yīng)用程StudentInfoManagementFrmStudentStudentnfoManagemntCDataBase.csFrmStudent男女2、點(diǎn)擊添加的時(shí)候，出現(xiàn)的界面如下，點(diǎn)擊確定的時(shí)候，會(huì)彈出是否確定的3、點(diǎn)擊修改的時(shí)候， 4system5、選擇查詢條件為，查詢值為，點(diǎn)擊查詢，得到以下結(jié)果數(shù)據(jù)庫(kù)連接代碼如下usingusingSystem.Collections.Generic;usingSystem.Linq;usingusingSystem.Data.Sql usingSystem.Data;usingnamespace{class{ publicstaticSqlConnectionconn=newpublicstaticDataSetGetDataFromDB(string{SqlDataAdaptermyAdapter=newSqlDataAdapter(sqlStr,conn);DataSetmyDataSet=newDataSet();if(myDataSet.Tables[0].Rows.Count!={}{}}

returnreturnpublicstaticvoidUpdateDB(string{mandmyCmd=new mand(sqlStr,conn);mandType=CommandType.Text;}}}FormStudent.cs窗體設(shè)計(jì)代碼如下usingusingSystem.Collections.Generic; usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingnamespace{publicpartialclassFormStudent:{public{} privatevoid{txtNo.Enabled=true;txtName.Enabled=true;txtAge.Enabled=true;cmb.Enabled=true;txtDept.Enabled=true;} privatevoid{txtNo.Enabled=false;txtName.Enabled=false;txtAge.Enabled=false;cmb.Enabled=false;txtDept.Enabled=false;} privatevoid{txtNo.Text="";txtName.Text="";txtAge.Text="";cmb.SelectedIndex=-1;txtDept.Text="";} 用于將Student表中的數(shù)據(jù)出來(lái)，顯示在相應(yīng)的數(shù)據(jù)控件中privatevoidRefreshData(){stringDataSetds=newDataSet();sqlStr="select*fromstudent";ds=CDataBase.GetDataFromDB(sqlStr);if(ds!=null){dgrdvStudent.DataSource=}{}}

dgrdvStudent.Columns[0].HeaderText="學(xué)號(hào)";dgrdvStudent.Columns[0].Width=120;dgrdvStudent.Columns[1].HeaderText="";dgrdvStudent.Columns[1].Width=120;dgrdvStudent.Columns[2].HeaderText="";dgrdvStudent.Columns[2].Width=80;dgrdvStudent.Columns[3].HeaderText="";dgrdvStudent.Columns[3].Width=80;dgrdvStudent.Columns[4].HeaderText="系";dgrdvStudent.Columns[4].Width=150;dgrdvStudent_RowHeaderMouseClick(nullnull);dgrdvStudent.DataSource=//true，說(shuō)明輸入的學(xué)生信息不存privateboolIsNoExist(string{intn=dgrdvStudent.Rows.Count;for(inti=0;i<n-1;i++){returnfalse;}return}//窗體的Load代碼privatevoidFormStudent_Load(objectsender,EventArgs{} 窗體的FormClosing代privatevoidFrmStudent_FormClosing(objectsender,FormClosingEventArgs{if{if(MessageBox.Show("數(shù)據(jù)尚未保存，要關(guān)閉窗口嗎？詢問(wèn)",MessageBoxButtons.YesNo,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2)==DialogResult.No){e.Cancel=}}}privatevoiddgrdvStudent_RowHeaderMouseClick(objectsender,DataGridViewCellMouseEventArgse){intn=dgrdvStudent.CurrentCell.RowIndex;if(n<dgrdvStudent.RowCount){txtNo.Text=dgrdvStudent[0,n].Value.ToString().Trim();cmb.Text=dgrdvStudent[2,n].Value.ToString().Trim();txtAge.Text=dgrdvStudent[3,n].Value.ToString().Trim();txtDept.Text=dgrdvStudent[4,n].Value.ToString().Trim();}}privatevoidbtnAdd_Click(objectsender,EventArgs{if(btnAdd.Text.Trim()添加{btnAdd.Text確定";btnUpdate.Enabled=false;btnDelete.Enabled=false;cmbSelect.Enabled=false;txtSelect.Enabled=false;btnSelect.Enabled=false;dgrdvStudent.Enabled=false;}elseif(txtNo.Text.Trim()=={MessageBox.Show("請(qǐng)輸入學(xué)號(hào)！提示");}elseif(txtName.Text.Trim()=={MessageBox.Show("請(qǐng)輸入！","提示");}elseif(cmb.SelectedIndex==-{MessageBox.Show("請(qǐng)選擇！","提示");}elseif(txtAge.Text.Trim()=={MessageBox.Show("請(qǐng)輸入！","提示");}elseif(txtDept.Text.Trim()=={MessageBox.Show("請(qǐng)輸入該生所在系！提示");}elseif{MessageBox.Show("該生已存在！提示");txtNo.Text="";}btnAdd.Text添加";stringsqlStr1;sqlStr1="insertintostudentvalues('"+txtNo.Text.Trim()++txtName.Text.Trim()+"','"+cmb.Text.Trim()++txtAge.Text.Trim()+"','"+txtDept.Text.Trim()+"')";if(MessageBox.Show("添加成功！繼續(xù)添加嗎？添加學(xué)生MessageBoxButtons.YesNo,MessageBoxIcon.Question,{}{}}

btnAdd.Text確定";btnUpdate.Enabled=true;btnDelete.Enabled=true;cmbSelect.Enabled=true;txtSelect.Enabled=true;btnSelect.Enabled=true;dgrdvStudent.Enabled=true;privatevoidbtnUpdate_Click(objectsender,EventArgs{if(btnUpdate.Text.Trim()修改{}{

btnUpdate.Text="確定";btnAdd.Enabled=false;btnDelete.Enabled=false;cmbSelect.Enabledfalse;txtSelect.Enabled=false;btnSelect.Enabled=false;txtName.Enabled=true;txtAge.Enabled=true;cmb.Enabled=true;txtDept.Enabled=true;btnUpdate.Text="修改";btnAdd.Enabled=true;btnDelete.Enabled=true;cmbSelect.Enabledtrue;txtSelect.Enabled=true;btnSelect.Enabled=true;stringsqlStr="updatestudentsetSname='"+txtName.Text.Trim()+"',S='"+cmb.Text.Trim()+"',Sage='"+txtAge.Text.Trim()+"',Sdept='"+txtDept.Text.Trim()+"'whereSno='"+txtNo.Text.Trim()+"'";MessageBox.Show("修改成功！提示}}privatevoidbtnDelete_Click(objectsender,EventArgs{if(txtNo.Text.Trim()=={MessageBox.Show("沒(méi)有可刪除的記錄！提示");}if(MessageBox.Show("確定要?jiǎng)h除學(xué)生“txtName.Text.Trim()”嗎？","刪除學(xué)生",MessageBoxButtons.YesNo,MessageBoxIcon.Question,MessageBoxDefaultButton.Button2)==DialogResult.Yes){stringsqlStr="deletefromstudentwhereSno='"+txtNo.Text.Trim()+"'";intn=dgrdvStudent.CurrentCell.RowIndex;if(dgrdvStudent.Rows.Count=={}{}}}

dgrdvStudent.DataSource=null;privatevoidbtnSelect_Click(objectsender,EventArgs{stringsqlStr=if(txtSelect.Text.Trim()=={MessageBox.Show("請(qǐng)輸入要查詢的“+"",}elseif(cmbSelect.SelectedIndex=={sqlStr="select*fromStudentwhereSno='"+txtSelect.Text.Trim()+}elseif(cmbSelect.SelectedIndex=={sqlStr="select*fromStudentwhereSname='"+txtSelect.Text.Trim()+}elseif(cmbSelect.SelectedIndex=={sqlStr="select*fromStudentwhereS='"+txtSelect.Text.Trim()+}elseif(cmbSelect.SelectedIndex=={sqlStr="select*fromStudentwhereSage='"+txtSelect.Text.Trim()+}elseif(cmbSelect.SelectedIndex=={sqlStr="select*fromStudentwhereSdept='"+txtSelect.Text.Trim()+}DataSetds=newds=CDataBase.GetDataFromDB(sqlStr);if(ds!=null){}

dgrdvStudent.DataSource=ds.Tables[0];dgrdvStudent.Columns[0].HeaderText="學(xué)號(hào)