C#-通过ADOX创建Access文件

添加工程中的应用——Microsoft ADO Ext. 2.8 for DDL and Security 

               string strConn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};" + "Jet OLEDB:Engine Type=5", m_strPath);
                // 创建数据文件
                CatalogClass cat = new CatalogClass();
                cat.Create(strConn);
                // 创建表
                TableClass table = new TableClass();
                table.ParentCatalog = cat;
                table.Name = "name";
                // 创建列
                ColumnClass col1 = new ColumnClass();
                col1.ParentCatalog = cat;
                col1.Name = "index";
                col1.Properties["Jet OLEDB:Allow Zero Length"].Value = false;
                col1.Properties["AutoIncrement"].Value = true;
                // 创建列
                ColumnClass col2 = new ColumnClass();
                col2.ParentCatalog = cat;
                col2.Name = "Description";
                col2.Properties["Jet OLEDB:Allow Zero Length"].Value = false;
                // 添加列
                table.Columns.Append(col1, DataTypeEnum.adInteger, 0);
                table.Columns.Append(col2, DataTypeEnum.adVarChar, 666);
                // 添加表
                cat.Tables.Append(table);

                // 释放接口资源
                Marshal.ReleaseComObject(col1);
                col1 = null;
                Marshal.ReleaseComObject(col2);
                col2 = null;
                Marshal.ReleaseComObject(table);
                table = null;
                Marshal.ReleaseComObject(cat);
                cat = null;

                // 垃圾回收
                GC.WaitForPendingFinalizers();
                GC.Collect();

                MessageBox.Show("Access数据库成功创建!");