using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.OleDb;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;

namespace?stu
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????public?void?GetConnected（）
????????{
????????????try
????????????{
????????????????string?strCon?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?Application.StartupPath?+?“\\學生信息.mdb“;
????????????????OleDbConnection?myConn?=?new?OleDbConnection（strCon）;
????????????????string?strCom?=?“SELECT?*?FROM?學生“;
????????????????this.dataSet1?=?new?DataSet（）;
????????????????myConn.Open（）;
????????????????MessageBox.Show（“連接成功！“）;
????????????????OleDbDataAdapter?myCommand?=?new?OleDbDataAdapter（strCom?myConn）;
????????????????myCommand.Fill（dataSet1?“學生“）;
????????????????myConn.Close（）;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????MessageBox.Show（“連接錯誤！“?+?e.ToString（）?“錯誤“）;
????????????}
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????GetConnected（）;
????????????this.dataGrid1.DataSource?=?this.dataSet1.Tables[“學生“];

????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????try
????????????{
????????????????string?strCon?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=F:\\c#\\數據庫\\學生信息.mdb“;
????????????????OleDbConnection?myConn?=?new?OleDbConnection（strCon）;
????????????????myConn.Open（）;
????????????????string?strCom?=?“SELECT??*??FROM?學生??WHERE??姓名??Like?‘%“?+?this.textBox1.Text?+?“%‘“;
????????????????OleDbDataAdapter?myCommand?=?new?OleDbDataAdapter（strCom?myConn）;
????????????????this.dataSet1.Clear（）;
????????????????myCommand.Fill（dataSet1?“學生“）;
????????????????myConn.Close（）;
????????????}
????????????catch?（Exception?x）
????????????{?MessageBox.Show（“錯誤！“?+?x.ToString（）?“error“）;?}

????????}

????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????try
????????????{
????????????????string?strCon?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?Application.StartupPath?+?“\\學生信息.mdb“;
????????????????OleDbConnection?myConn?=?new?OleDbConnection（strCon）;
????????????????myConn.Open（）;
????????????????string?strCom?=?“INSERT?INTO?學生（學號姓名性別年齡）?VALUES?（‘“?+?this.textBox2.Text?+?“‘‘“?+?this.textBox3.Text?+?“‘‘“?+?this.textBox4.Text?+?“‘“?+?this.textBox5.Text?+?“）“;
????????????????OleDbCommand?inst?=?new?OleDbCommand（strCom?myConn）;
????????????????inst.ExecuteNonQuery（）;
????????????????OleDbDataAdapter?myCommand?=?new?OleDbDataAdapter（“SELECT??*?FROM?學生?order?by?學號“?myConn）;
????????????????dataSet1.Clear（）;
????????????????myCommand.Fill（dataSet1?“學生“）;
????????????????myConn.Close（）;
????????????}
????????????catch?（Exception?x）
????????????{?Message

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????20992??2014-12-21?09:38??stu\stu\bin\Debug\stu.exe

?????文件??????52736??2014-12-21?09:38??stu\stu\bin\Debug\stu.pdb

?????文件??????22984??2014-12-21?09:38??stu\stu\bin\Debug\stu.vshost.exe

?????文件????????490??2013-06-18?20:28??stu\stu\bin\Debug\stu.vshost.exe.manifest

?????文件??????75776??2014-12-14?08:39??stu\stu\bin\Debug\學生信息.mdb

?????文件???????6057??2014-12-15?10:24??stu\stu\Form1.cs

?????文件??????10344??2014-12-15?10:24??stu\stu\Form1.Designer.cs

?????文件???????6013??2014-12-15?10:24??stu\stu\Form1.resx

?????文件???????3548??2014-12-15?10:25??stu\stu\Form2.cs

?????文件???????8277??2014-12-15?10:25??stu\stu\Form2.Designer.cs

?????文件???????5817??2014-12-15?10:25??stu\stu\Form2.resx

?????文件???????2340??2014-12-15?10:23??stu\stu\Form3.cs

?????文件???????4734??2014-12-15?10:23??stu\stu\Form3.Designer.cs

?????文件???????5817??2014-12-15?10:23??stu\stu\Form3.resx

?????文件???????2867??2014-12-21?09:38??stu\stu\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????6948??2014-12-21?09:36??stu\stu\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件????????518??2014-12-15?10:26??stu\stu\obj\x86\Debug\GenerateResource.read.1.tlog

?????文件???????2290??2014-12-15?10:26??stu\stu\obj\x86\Debug\GenerateResource.write.1.tlog

?????文件???????7897??2014-12-07?19:14??stu\stu\obj\x86\Debug\ResolveAssemblyReference.cache

?????文件???????1573??2014-12-21?09:38??stu\stu\obj\x86\Debug\stu.csproj.FileListAbsolute.txt

?????文件???????1091??2014-12-21?09:38??stu\stu\obj\x86\Debug\stu.csproj.GenerateResource.Cache

?????文件???????9174??2014-12-21?09:38??stu\stu\obj\x86\Debug\stu.csprojResolveAssemblyReference.cache

?????文件??????20992??2014-12-21?09:38??stu\stu\obj\x86\Debug\stu.exe

?????文件????????180??2014-12-15?10:26??stu\stu\obj\x86\Debug\stu.Form1.resources

?????文件????????180??2014-12-15?10:26??stu\stu\obj\x86\Debug\stu.Form2.resources

?????文件????????180??2014-12-15?10:23??stu\stu\obj\x86\Debug\stu.Form3.resources

?????文件??????52736??2014-12-21?09:38??stu\stu\obj\x86\Debug\stu.pdb

?????文件????????180??2014-12-15?10:23??stu\stu\obj\x86\Debug\stu.Properties.Resources.resources

?????文件??????75776??2013-12-08?05:31??stu\stu\obj\學生信息.mdb

?????文件????????484??2014-12-14?08:46??stu\stu\Program.cs

............此處省略22個文件信息