第七周-4.12童第六次實驗

1、寧波大學(xué)實驗實驗課程名稱：數(shù)據(jù)庫應(yīng)用與開發(fā)院：學(xué)專業(yè)：15 信管指導(dǎo) 教師：人：童學(xué)號：156001259級：15 信管班學(xué)期：大二下商科實驗教學(xué)中心制實驗成績實驗項目名稱實驗五一、實驗?zāi)康呐c要求：對數(shù)據(jù)庫進(jìn)行添加 修改等操作二、實驗設(shè)備及：電腦VS三、實驗方法（原理、流程圖）四、實驗過程、步驟及內(nèi)容設(shè)計如下using System;using System.Collections.Generic; usingponentM; using System.Data;using System.Drawing; using System.Linq; using System.Text;using S

2、ystem.Windows.Forms; using System.Data.OleDb;namespace _4._5_數(shù)y據(jù)Y庫a添加信?息2public partial class Form1 : FormOleDbConnectionn = new OleDbConnection(); mand CMD =d();OleDbDataReader Reader; DataSet dt = new DataSet();OleDbDataAdapterter = new OleDbDataAdapter(); public Form1()ponent();private void butto

3、n1_Click(objecder, EventArgs e)n.ConnectionString = Provider=.Jet.OLEDB.4.0;Data Source=C:UsersmyDesktopDatabase3.mdb;CMD.Connection =n; n.Open();mandText = select * from 學(xué)生表 where 學(xué)號?= + textBox1.Text + ;object t = CMD.ExecuteScalar(); if (t != null)MessageBox.Show(錯誤！?已?存?在); return;mandText = ins

4、erto 學(xué)生表(學(xué)號?,?) values( + textBox1.Text + , + textBox2.Text + );CMD.ExecuteNonQuery();mandText = select 學(xué)號?,? from 學(xué)生表 ;/dt.Clear();mand = CMD; ter.Fill(dt, Database3);dataGridView1.DataSource = dt.TablesDatabase3; n.Close();MessageBox.Show(添加成功|);private void button2_Click(objecder, EventArgs e)n.C

5、onnectionString = Provider=.Jet.OLEDB.4.0;Data Source=C:UsersmyDesktopDatabase3.mdb;CMD.Connection =n; n.Open();mandText = select * from 課?程表 where 課?程號?= + textBox3.Text + ;object t = CMD.ExecuteScalar(); if (t != null)MessageBox.Show(錯誤！?已?存?在); return;mandText = inserto 課?程表(課?程號?,課?程) values(+ t

6、extBox3.Text + , + textBox4.Text + ); CMD.ExecuteNonQuery();n.Close();MessageBox.Show(添加成功|);private void button5_Click(objecder, EventArgs e)n.ConnectionString = Provider=.Jet.OLEDB.4.0;Data Source=C:UsersmyDesktopDatabase3.mdb;CMD.Connection =n; n.Open();mandText = delete from 學(xué)生表 where 學(xué)號?= + tex

7、tBox1.Text + ;CMD.ExecuteNonQuery();dt.Clear();mandText = select 學(xué)號?,? from 學(xué)生表 where 學(xué)號? like % + textBox1.Text + % order by 學(xué)號?;mand = CMD; ter.Fill(dt, 學(xué)生表);dataGridView2.DataSource = dt.Tables學(xué)號?; n.Close();private void button6_Click(objecder, EventArgs e)注：內(nèi)頁的項目或內(nèi)容設(shè)置，根據(jù)實際情況可加以調(diào)整和補(bǔ)充，寫不下可附一頁。n.Co

8、nnectionString = Provider=.Jet.OLEDB.4.0;Data Source=C:UsersmyDesktopDatabase3.mdb;CMD.Connection =n; n.Open();mandText = delete from 課?程表 where 課?程號?= + textBox3.Text + ;CMD.ExecuteNonQuery();dt.Clear();mandText = select * from 課?程表 where 課?程號? like % + textBox3.Text + % order by 課?程號?;mand = CMD; ter.