动态创建数据库和表（C#）

 

class iniClass
    {
        private string path = System.AppDomain.CurrentDomain.BaseDirectory + "ysmz";
        public void createdirectanddata(string path)
        {
            string str = Directory.CreateDirectory(path) + "/" + "ysmz.mdb";
            ADOX.CatalogClass cat = new ADOX.CatalogClass();
            cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+str+";"+"Jet OLEDB:Engine Type=5");
           
            ADOX.TableClass atl = new ADOX.TableClass();
            atl.ParentCatalog = cat;
            atl.Name = "one";
            //id column
            ADOX.ColumnClass col1 = new ADOX.ColumnClass();
            col1.ParentCatalog = cat;
            col1.Type = ADOX.DataTypeEnum.adInteger;
            col1.Name = "id";
            col1.Properties["Jet OLEDB:Allow Zero Length"].Value = false;
            col1.Properties["AutoIncrement"].Value = true;         
            //name column
            ADOX.ColumnClass col2 = new ADOX.ColumnClass();
            col2.ParentCatalog = cat;
            col2.Name = "name";
            col2.Properties["Jet OLEDB:Allow Zero Length"].Value=false;        
            //classid column
            ADOX.ColumnClass col3 = new ADOX.ColumnClass();
            col3.ParentCatalog = cat;
            col3.Type = ADOX.DataTypeEnum.adInteger;
            col3.Name = "classid";
            col3.Properties["Jet OLEDB:Allow Zero Length"].Value = false;
            atl.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "id", "", "");
            atl.Columns.Append(col1, ADOX.DataTypeEnum.adInteger, 0);
            atl.Columns.Append(col2, ADOX.DataTypeEnum.adVarChar, 10);
            atl.Columns.Append(col3, ADOX.DataTypeEnum.adInteger,15);
            cat.Tables.Append(atl);
            atl = null;
            cat = null;
        }       
    }