数据库作业汇总

1、三、实验方法（原理、流程图using三、实验方法（原理、流程图usingusing System.Data;using System.Linq; using System.Text;using System.Data.OleDb; namespace _4._12publicpartialclassForm2:publicn=newOleDbConnection(); mand CMD =OleDbDataReader Reader; DataSetdt=newDataSet();ter=newprivatevoidder,EventArgsn.ConnectionString=CMD.Con

2、nection =/ mandText=号CMD.Connection =/ mandText=号textBox1.Textobjectt=CMD.ExecuteScalar(); if (t != null)?,学号from生?表括?whereMessageBox.Show(该?学号?已?存?在，?请?检查mandText=o生?表括?学号?)values(textBox1.Text+,+textBox2.Text+mandText=select mand=ter.Fill(dt,?,学号from生?表dataGridView1.DataSource = privatevoidder,Eve

3、ntArgs号n.ConnectionString = Source=F:c#程序设?计?2017-4-5 第台?五?次?上?机实害?验CMD.Connection mandText=?,学号?from学生?表括?where学号liketextBox5.TextorderliketextBox5.Textorderby号mand = CMD; ter.Fill(dt,学生?表括?);dataGridView1.DataSourcedt.Tables学生?表括?; privatevoidder,EventArgsdt.Tablesabc.Columns.Add(学号dt.Tablesabc.Ro

4、wsdt.Tablesabc.Rows.Count - 1dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count1学号? dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1?谭磊dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count1学号?谭 ?聪?磊dataGridView1.DataSource = privatevoidder,EventArgsn.ConnectionString = Provider=Source=F:c#程序设?计?2017-4-5 第台?五?次?上?机实害?验CMD.Conn

5、ection =mandText = update 学生?表括?set?=+textBox2.Text+ where 学号?= + textBox2.Text + ;mandText = select?,学号from生?表括?where号? like % + textBox5.Text + % order by 学号?;mand = CMD; dataGridView1.DataSource = dt.Tables学生?表括private void dataGridView1_CellContentClick(objecDataGridViewCellEventArgs private voi

6、d dataGridView1_CellContentClick(objecDataGridViewCellEventArgs e)textBox2.Text = dataGridView1?, e.RowIndex.Value.ToString(); textBox1.TextdataGridView1学号?e.RowIndex.Value.ToString();privatevoidder,EventArgsn.ConnectionString = Provider=Source=F:c#程序设?计?2017-4-5 第台?五?次?上?机实害?验CMD.Connection =mandTextdeletefrom 学生where 学号+mandText = select?,学号from生?表括?whe