实验-数据库操作综合三

综合实验studentstudent表中删除相应记录。2、在实验报告中【待分析实验步骤】的设计和代码存在的不足之处2masterstudent。其表结构如下表所示。usecreatetablestudent(snochar(10)primarykey,snamevarchar(50)notnull, char(2)notnull,sageintnotsdeptvarchar(20)not)insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( insertintostudentvalues( 1、打开VS2008，新建一个项目，在新建项目框中，模板选择“Windows应用程StudentInfoManagementFrmStudentStudentnfoManagemntCDataBase.csFrmStudent男女2、点击添加的时候，出现的界面如下，点击确定的时候，会弹出是否确定的3、点击修改的时候， 4system5、选择查询条件为，查询值为，点击查询，得到以下结果数据库连接代码如下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窗体设计代码如下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表中的数据出来，显示在相应的数据控件中privatevoidRefreshData(){stringDataSetds=newDataSet();sqlStr="select*fromstudent";ds=CDataBase.GetDataFromDB(sqlStr);if(ds!=null){dgrdvStudent.DataSource=}{}}

dgrdvStudent.Columns[0].HeaderText="学号";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，说明输入的学生信息不存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("数据尚未保存，要关闭窗口吗？询问",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("请输入学号！提示");}elseif(txtName.Text.Trim()=={MessageBox.Show("请输入！","提示");}elseif(cmb.SelectedIndex==-{MessageBox.Show("请选择！","提示");}elseif(txtAge.Text.Trim()=={MessageBox.Show("请输入！","提示");}elseif(txtDept.Text.Trim()=={MessageBox.Show("请输入该生所在系！提示");}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("添加成功！继续添加吗？添加学生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("没有可删除的记录！提示");}if(MessageBox.Show("确定要删除学生“txtName.Text.Trim()”吗？","删除学生",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("请输入要查询的“+"",}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="学号