using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.OleDb;
using?System.ComponentModel;
using?System.Windows.Forms;
namespace?ex1
{
????public?class?AdpToAccess????????//連接access數據庫datebase21

????{
????????//string?myConnstring;
????????
????????//OleDbDataAdapter?MyAdapter;
????????//OleDbCommandBuilder?MyCmdBuilder;
????????//OleDbCommand?MyCommand;
????????#region
????????///?

????????///?建立到datebase21的連接。
????????///?

????????///?返回OleDbConnection對象?
????????public?virtual?OleDbConnection?getcon（）
????????{
????????????OleDbConnection?MyCon?=new?OleDbConnection?（）?;
????????????string?myConnstring?=?@“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source?=?D:\db\datebase2\Database21.accdb“;
????????????try
????????????{
????????????????MyCon?=?new?OleDbConnection（myConnstring）;
????????????????return?MyCon;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“連接失敗“）;
????????????????return?MyCon;
????????????}

?????????}
????????#endregion
????????#region
????????///?

????????///?建立到datebase附加庫的連接。
????????///?

????????///?返回OleDbConnection對象?
????????public?OleDbConnection?getcon（string?path?string?dataname）?????//連接access附加庫使用
????????{
?????????
????????????string?myConnstring?=?@“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source?=?D:\db\datebase2\Database21.accdb“;
????????????OleDbConnection??MyCon?=?new?OleDbConnection（myConnstring）;
????????????return?MyCon;
?????????}
????????#endregion
????????#region
????????///?

????????///?執行OleDbCommand命令。
????????///?

????????///?SQL語句?
????????public?void?getcom（string?Qcmd）
????????{
????????????OleDbConnection?oledbcon?=?this.getcon（）;
????????????oledbcon.Open（）;
????????????try
????????????{
????????????????OleDbCommand?sqlcmd?=?new?OleDbCommand（Qcmd）;
????????????????sqlcmd.Connection?=?oledbcon;
????????????????sqlcmd.ExecuteNonQuery（）;
????????????????sqlcmd.Dispose（）;
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“操作執行失敗?“）;
????????????}
????????????finally
????????????{
????????????????oledbcon.Close（）;
??????????????//??oledbcon.Dispose（）;
????????????}
????????}
????????#endregion
????????/*public?OleDbDataAdapter?MyQuery（string?Qcmd?）
????????{
????????????MyAdapter??=?new?OleDbDataAdapter（QcmdMyConnection?）;
????????????return?MyAdapter;
????????}?*/
????????#region
????????///

????????///創建一個dataset對象
????????///

????????///SQL語句?
????????///表名?
????????///返回Dataset對象
????????public?DataSet?getds（string?Qcmd?string?TbName）
????????{
????????????OleDbConnection?oledbcon?=?this.getcon（）;
????????????OleD

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????230??2019-06-10?17:09??說明.txt
?????目錄???????????0??2015-06-06?10:01??example\
?????目錄???????????0??2015-06-06?10:01??example\ex1\
?????目錄???????????0??2015-06-07?17:00??example\ex1\ex1\
?????文件????????5260??2015-06-07?15:27??example\ex1\ex1\AdpToAccess.cs
?????文件???????12015??2015-06-07?16:07??example\ex1\ex1\Form1.Designer.cs
?????文件????????7332??2015-06-07?16:07??example\ex1\ex1\Form1.cs
?????文件????????5817??2015-06-07?16:07??example\ex1\ex1\Form1.resx
?????文件????????3148??2015-06-07?16:58??example\ex1\ex1\FrmA.Designer.cs
?????文件?????????876??2015-06-07?16:58??example\ex1\ex1\FrmA.cs
?????文件????????5817??2015-06-07?16:58??example\ex1\ex1\FrmA.resx
?????文件????????6595??2015-06-07?16:58??example\ex1\ex1\FrmDocForm.Designer.cs
?????文件????????2424??2015-06-07?17:00??example\ex1\ex1\FrmDocForm.cs
?????文件????????5817??2015-06-07?16:58??example\ex1\ex1\FrmDocForm.resx
?????文件???????11563??2015-06-07?15:27??example\ex1\ex1\FrmSetting.Designer.cs
?????文件????????5166??2015-06-07?15:52??example\ex1\ex1\FrmSetting.cs
?????文件????????5817??2015-06-07?15:27??example\ex1\ex1\FrmSetting.resx
?????文件????????1783??2015-06-07?16:31??example\ex1\ex1\MyATAccess.cs
?????文件?????????646??2015-06-07?16:58??example\ex1\ex1\MyCommon.cs
?????文件?????????484??2015-06-05?10:26??example\ex1\ex1\Program.cs
?????目錄???????????0??2015-06-06?10:01??example\ex1\ex1\Properties\
?????文件????????1348??2015-06-05?10:26??example\ex1\ex1\Properties\AssemblyInfo.cs
?????文件????????2858??2015-06-05?10:26??example\ex1\ex1\Properties\Resources.Designer.cs
?????文件????????5612??2015-06-05?10:26??example\ex1\ex1\Properties\Resources.resx
?????文件????????1833??2015-06-05?12:21??example\ex1\ex1\Properties\Settings.Designer.cs
?????文件?????????538??2015-06-05?12:21??example\ex1\ex1\Properties\Settings.settings
?????文件?????????886??2015-06-05?12:21??example\ex1\ex1\app.config
?????目錄???????????0??2015-06-06?10:01??example\ex1\ex1\bin\
?????目錄???????????0??2015-06-07?15:45??example\ex1\ex1\bin\Debug\
?????文件???????22656??2015-06-05?10:26??example\ex1\ex1\bin\Debug\ex1.vshost.exe
?????文件?????????490??2010-03-17?22:39??example\ex1\ex1\bin\Debug\ex1.vshost.exe.manifest
............此處省略35個文件信息