數(shù)據(jù)庫(kù)作業(yè)匯總試驗(yàn)

1、寧波大學(xué)商學(xué)院實(shí)驗(yàn)報(bào)告實(shí)驗(yàn)課程名稱： 數(shù)據(jù)庫(kù)的應(yīng)用與開(kāi)發(fā) 學(xué) 院： 商學(xué)院 專 業(yè)： 信息管理與信息系統(tǒng) 指導(dǎo)教師： 張宇萌 報(bào)告人姓名： 余雅春 學(xué)號(hào)： 144173745 班 級(jí)： 14信管 學(xué) 期： 2016-2017年第二個(gè)學(xué)期 商學(xué)院商科實(shí)驗(yàn)教學(xué)中心制實(shí)驗(yàn)成績(jī)實(shí)驗(yàn)項(xiàng)目名稱導(dǎo)入文件一、實(shí)驗(yàn)?zāi)康呐c要求：把選課名單這個(gè)文件導(dǎo)入數(shù)據(jù)庫(kù)中二、實(shí)驗(yàn)設(shè)備及軟件：Vs2010、電腦實(shí)驗(yàn)方法（原理、流程圖）四、實(shí)驗(yàn)過(guò)程、步驟及內(nèi)容代碼：using System;using System.Collections.Generic;using System.ComponentModel;using Syst

2、em.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.OleDb;namespace 添加 public partial class Form1 : Form public Form1() InitializeComponent(); OleDbConnection Database1 = new OleDbConnection(); OleDbCommand CMD = new OleDbCommand(); OleDbData

3、Reader Reader; DataSet dt = new DataSet(); OleDbDataAdapter adpter = new OleDbDataAdapter(); private void Form1_Load(object sender, EventArgs e) private void button1_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UserszDocumentsDatabase

4、1.accdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 學(xué)號(hào) from students where 學(xué)號(hào) = + textBox1.Text + ; object t = CMD.ExecuteScalar(); if (t != null) MessageBox.Show(該學(xué)號(hào)已存在); return; CMD.CommandText = insert into students(學(xué)號(hào),姓名,班級(jí),性別) values( + textBox1.Text + , + textBox2.T

5、ext + , + textBox3.Text + , + textBox4.Text + ); CMD.ExecuteNonQuery(); Database1.Close(); MessageBox.Show(添加成功！); CMD.CommandText = select 姓名，學(xué)號(hào)，班級(jí)，性別 from students ; dt.Clear(); adpter.SelectCommand = CMD; adpter.Fill(dt, stu); dataGridView1.DataSource = dt.Tablesstu; Database1.Close(); private vo

6、id button2_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UserszDocumentsDatabase1.accdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = Select 課程號(hào) from course where 課程號(hào) = + textBox5.Text + ; object t = CMD.ExecuteScala

7、r(); if (t != null) MessageBox.Show(該課程號(hào)已存在); return; CMD.CommandText = insert into course(課程號(hào),課程名,學(xué)分) values( + textBox5.Text + , + textBox6.Text + , + textBox7.Text + ); CMD.ExecuteNonQuery(); Database1.Close(); MessageBox.Show(添加成功！); private void 查詢_Click(object sender, EventArgs e) dt.Clear();

8、string name, No; Database1.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UserszDocumentsDatabase1.accdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = select 學(xué)號(hào),姓名,班級(jí),性別 from students where 學(xué)號(hào) like % + textBox1.Text + % order by 學(xué)號(hào); adpter.SelectCommand = CMD;

9、adpter.Fill(dt, stu); dataGridView1.DataSource = dt.Tablesstu; Database1.Close(); private void 修改_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UserszDocumentsDatabase1.accdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandTe

10、xt = update students set 姓名= + textBox2.Text + where 學(xué)號(hào)= + textBox1.Text + ; CMD.ExecuteNonQuery(); dt.Clear(); CMD.CommandText = select 姓名,學(xué)號(hào),班級(jí)，性別 from students where 學(xué)號(hào) like % + textBox1.Text + % order by 學(xué)號(hào); adpter.SelectCommand = CMD; adpter.Fill(dt, stu); dataGridView1.DataSource = dt.Tablesst

11、u; Database1.Close(); private void 刪除_Click(object sender, EventArgs e) Database1.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UserszDocumentsDatabase1.accdb; CMD.Connection = Database1; Database1.Open(); CMD.CommandText = delete from students where 學(xué)號(hào)= + textBox1.Text + ; CMD.

12、ExecuteNonQuery(); CMD.CommandText = select 姓名，學(xué)號(hào)，班級(jí)，性別 from students ; dt.Clear(); adpter.SelectCommand = CMD; adpter.Fill(dt, stu); dataGridView1.DataSource = dt.Tablesstu; Database1.Close(); private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) textBox2.Text = da

13、taGridView1姓名, e.RowIndex.Value.ToString(); textBox1.Text = dataGridView1學(xué)號(hào), e.RowIndex.Value.ToString(); textBox3.Text = dataGridView1班級(jí), e.RowIndex.Value.ToString(); textBox4.Text = dataGridView1性別, e.RowIndex.Value.ToString(); private void dataset_Click(object sender, EventArgs e) dt.Tables.Add(a

14、bc); dt.Tablesabc.Columns.Add(姓名); dt.Tablesabc.Columns.Add(學(xué)號(hào)); dt.Tablesabc.Columns.Add(班級(jí)); dt.Tablesabc.Columns.Add(性別); dt.Tablesabc.Rows.Add(); dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1姓名 = 余雅春; dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1學(xué)號(hào) = 144173745; dt.Tablesabc.Rowsdt.Tablesabc.Rows.C

15、ount - 1班級(jí) = 14信管; dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1性別 = 女; dt.Tablesabc.Rows.Add(); dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1姓名 = 余雅夏; dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1學(xué)號(hào) = 144173746; dt.Tablesabc.Rowsdt.Tablesabc.Rows.Count - 1班級(jí) = 14金融; dt.Tablesabc.Rowsdt.Tablesabc.Rows.

16、Count - 1性別 = 女; dataGridView1.DataSource = dt.Tablesabc; private void button3_Click(object sender, EventArgs e) OpenFileDialog openfileDialog = new OpenFileDialog(); openfileDialog.DefaultExt = xlsx;/默認(rèn)為xlsx格式 openfileDialog.Filter = xlsx文件(*.xlsx)|*.xlsx|xls文件(*.xls)|*.xls|所有文件(*.*)|*.*; if (openf

17、ileDialog.ShowDialog() != DialogResult.OK) return; try string FilePath = , File_Name = ; int pos = openfileDialog.FileName.LastIndexOf(); FilePath = openfileDialog.FileName.Substring(0, pos); File_Name = openfileDialog.FileName.Substring(pos + 1); OleDbConnection con = new OleDbConnection(Provider=M

18、icrosoft.ACE.OLEDB.12.0;Data Source= + openfileDialog.FileName + ;Extended Properties=Excel 12.0;HDR=YES); con.Open(); DataTable dtSheetName = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object null, null, null, Table ); string strTableNames = dtSheetName.Rows0TABLE_NAME.ToString(); string datainput = select * from + strTableNames + ; OleDbDataAdapter adapter = new OleDbDataAdapter(datainput, con); DataTable dt = new DataTable(); dt.Clear(); adapter.Fill(dt); con.C