数据库开发第六次实验报告

1、宁波大学商学院实验报告实验课程名称： 数据库开发与应用 学 院： 商学院 专 业： 信息管理与信息系统 指导教师： 张宇萌 报告人姓名： 李杰 学号： 156001240 班 级： 15信管 学 期： 大二第二学期 商学院商科实验教学中心制实验成绩实验项目名称实现MDI窗口查找（模糊查找）、修改、删除功能。一、实验目的与要求： 实现MDI窗口查找（模糊查找）、修改、删除功能。二、实验设备及软件：三、实验方法（原理、流程图）四、实验过程、步骤及内容一、代码：namespace 添加数据库数据 public partial class Form1 : Form public Form1() Ini

2、tializeComponent(); OleDbConnection Database1 = new OleDbConnection(); OleDbCommand CMD = new OleDbCommand(); DataSet dt = new DataSet(); OleDbDataAdapter adpater = new OleDbDataAdapter(); private void button1_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLED

3、B.4.0;Data Source=D:C+作业Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 学号 from students where 学号 = + textBox1.Text + ; object t = CMD.ExecuteScalar(); if (t != null) MessageBox.Show(该学号已存在); return; CMD.CommandText = insert into students(学号,姓名,班级,性别) values( +

4、textBox1.Text + , + textBox2.Text + , + textBox3.Text + , + textBox4.Text + ); CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = Select 姓名,学号,班级,性别 from students; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource = dt.Tablesstudents; Database1.Close(); MessageBox.S

5、how(添加成功！); private void button2_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作业Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 课程号 from course where 课程号 = + textBox5.Text + ; object t = CMD.Exec

6、uteScalar(); if (t != null) MessageBox.Show(该课程号已存在); return; CMD.CommandText = insert into course(课程号,课程名,学分) values( + textBox5.Text + , + textBox6.Text + , + textBox7.Text + ); Database1.Close(); MessageBox.Show(添加成功！); private void button3_Click(object sender, EventArgs e) dt.Clear(); Database1.

7、ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作业Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 姓名,学号,班级,性别 from students where 学号 like% + textBox1.Text + %; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource

8、= dt.Tablesstudents; Database1.Close(); private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) textBox1.Text = dataGridView1学号, e.RowIndex.Value.ToString(); textBox2.Text = dataGridView1姓名, e.RowIndex.Value.ToString(); textBox3.Text = dataGridView1班级, e.RowIndex.Value.ToStr

9、ing(); textBox4.Text = dataGridView1性别, e.RowIndex.Value.ToString(); private void button4_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作业Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = update students s

10、et 学号= + textBox1.Text +,姓名= + textBox2.Text + ,班级= + textBox3.Text +,性别= + textBox4.Text + where 学号= + textBox1.Text + ; CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = Select 姓名,学号,班级,性别 from students; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource = dt.Tabl

11、esstudents; Database1.Close(); private void button5_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:C+作业Database1.mdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Delete from students where 学号= + textBox1.Text + ; CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = Select 姓名,学号,班级,性别 from students; adpater.SelectCommand = CMD; adpater.Fill(dt, students); dataGridView1.DataSource = dt.Table