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

namespace?創建ACCESS表
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
?
????????//創建Access數據庫必須添加下面這兩個引用
????????//Microsoft?ADO?Ext.?2.8?for?DDL?and?Security”
????????//Microsoft?ActiveX?Data?objects?2.8?Library
????????private?void?btnOK_Click（object?sender?EventArgs?e）
????????{
????????????if?（txtPath.Text?==?““?||?txtTableName.Text?==?““?||?txtDBName.Text?==?““）
????????????{
????????????????MessageBox.Show（“請將信息簽寫完整“）;
????????????}
????????????else
????????????{

????????????????try
????????????????{
????????????????????ADOX.Catalog?catalog?=?new?Catalog（）;
????????????????????catalog.Create（“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?txtPath.Text?+?“\\“?+?txtDBName.Text?+?“.mdb;Jet?OLEDB:Engine?Type=5“）;
????????????????????MessageBox.Show（“庫創建成功“）;
????????????????????try
????????????????????{
????????????????????????string?strPath?=?txtPath.Text?+?“\\“?+?txtDBName.Text?+?“.mdb“;
????????????????????????string?ConStr?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?source=‘“?+?strPath?+?“‘“;

????????????????????????OleDbConnection?oleCon?=?new?OleDbConnection（ConStr）;//連接數據庫
????????????????????????string?Sql?=?“create?table?“?+?txtTableName.Text?+?“??（PKIAA?varchar（50）??null?TKALA??varchar（50）?nullTKALB??varchar（50）?nullCHAHBA??varchar（50）?null“?+
?????????????????????????????????????“?CHAHBB??varchar（50）?null?TKCAH?Single?GCJCBL?Single?CDGC?Single?GCKKJ?Single?GCDKJ?Single?TKCBCL?Single?“?+
?????????????????????????????????????“?SWJCSD?varchar（50）??null?SWEFBP??varchar（50）?nullSWAMN??varchar（50）?nullSWAMB??varchar（50）?nullSWAE??varchar（50）?null“?+
?????????????????????????????????????“?SWAF?varchar（50）??null?SWAG??varchar（50）?nullSWEB??varchar（50）?nullSWEFBR??varchar（50）?nullSWEFC??varchar（50）?null“?+
?????????????????????????????????????“?SWEFBU?varchar（50）??null?HJY?????varchar（50）?nullSWEFBX??varchar（50）?nullSWEFBQ??varchar（50）?nullSWEFBA??varchar（50）?null“+
?????????????????????????????????????“?SWEFBB?varchar（50）??null?SWEFBC??varchar（50）?nullSWEFBD??varchar（50）?nullZJDW??varchar（50）?null）“;
????????????????????????using?（OleDbConnection?cn?=?new?OleDbConnection（ConStr））
????????????????????????{
????????????????????????????cn.Open（）;
????????????????????????????OleDbCommand?cmd?=?new?OleDbCommand（Sql?cn）;
????????????????????????????cmd.ExecuteNonQuery（）;
????????????????????????????MessageBox.Show（“表創建成功“）;
????????????????????????????cn.Close（）;
????????????????????????????this.Close（）;

????????????????????????}
????????????????????}
????????????????????catch
????????????????????{
????????????????????????MessageBox.Show（“表創建失敗“）;
????

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

?????文件?????102400??2010-05-19?14:25??創建ACCESS表\創建ACCESS表\bin\Debug\Interop.ADODB.dll

?????文件??????36864??2010-05-19?14:24??創建ACCESS表\創建ACCESS表\bin\Debug\Interop.ADOX.dll

?????文件??????24576??2010-05-20?11:13??創建ACCESS表\創建ACCESS表\bin\Debug\創建ACCESS表.exe

?????文件??????22016??2010-05-20?11:13??創建ACCESS表\創建ACCESS表\bin\Debug\創建ACCESS表.pdb

?????文件???????5632??2005-11-11?22:25??創建ACCESS表\創建ACCESS表\bin\Debug\創建ACCESS表.vshost.exe

?????文件???????3709??2010-05-20?18:18??創建ACCESS表\創建ACCESS表\Form1.cs

?????文件???????6505??2010-05-19?14:53??創建ACCESS表\創建ACCESS表\Form1.Designer.cs

?????文件???????6021??2010-05-19?14:53??創建ACCESS表\創建ACCESS表\Form1.resx

?????文件?????102400??2010-06-11?14:36??創建ACCESS表\創建ACCESS表\obj\Debug\Interop.ADODB.dll

?????文件??????36864??2010-06-11?14:36??創建ACCESS表\創建ACCESS表\obj\Debug\Interop.ADOX.dll

?????文件????????842??2010-05-19?14:53??創建ACCESS表\創建ACCESS表\obj\Debug\創建ACCESS表.csproj.GenerateResource.Cache

?????文件????????651??2010-06-11?14:36??創建ACCESS表\創建ACCESS表\obj\Debug\創建ACCESS表.csproj.ResolveComReference.cache

?????文件??????24576??2010-05-20?11:13??創建ACCESS表\創建ACCESS表\obj\Debug\創建ACCESS表.exe

?????文件????????180??2010-05-19?14:53??創建ACCESS表\創建ACCESS表\obj\Debug\創建ACCESS表.Form1.resources

?????文件??????22016??2010-05-20?11:13??創建ACCESS表\創建ACCESS表\obj\Debug\創建ACCESS表.pdb

?????文件????????180??2010-05-19?14:27??創建ACCESS表\創建ACCESS表\obj\Debug\創建ACCESS表.Properties.Resources.resources

?????文件???????2213??2010-06-11?14:36??創建ACCESS表\創建ACCESS表\obj\創建ACCESS表.csproj.FileListAbsolute.txt

?????文件????????474??2010-05-19?14:21??創建ACCESS表\創建ACCESS表\Program.cs

?????文件???????1226??2010-05-19?14:21??創建ACCESS表\創建ACCESS表\Properties\AssemblyInfo.cs

?????文件???????2886??2010-05-19?14:21??創建ACCESS表\創建ACCESS表\Properties\Resources.Designer.cs

?????文件???????5612??2010-05-19?14:21??創建ACCESS表\創建ACCESS表\Properties\Resources.resx

?????文件???????1100??2010-05-19?14:21??創建ACCESS表\創建ACCESS表\Properties\Settings.Designer.cs

?????文件????????249??2010-05-19?14:21??創建ACCESS表\創建ACCESS表\Properties\Settings.settings

?????文件???????3845??2010-05-19?14:27??創建ACCESS表\創建ACCESS表\創建ACCESS表.csproj

?????文件????????934??2010-05-19?14:21??創建ACCESS表\創建ACCESS表.sln

????..A..H.?????13824??2010-06-11?14:36??創建ACCESS表\創建ACCESS表.suo

?????目錄??????????0??2010-05-20?08:20??創建ACCESS表\創建ACCESS表\obj\Debug\TempPE

?????目錄??????????0??2010-05-20?08:20??創建ACCESS表\創建ACCESS表\bin\Debug

?????目錄??????????0??2010-06-11?14:36??創建ACCESS表\創建ACCESS表\obj\Debug

?????目錄??????????0??2010-05-20?08:20??創建ACCESS表\創建ACCESS表\bin

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