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

最新推荐文章于 2023-04-07 00:00:53 发布

ysmz555

最新推荐文章于 2023-04-07 00:00:53 发布

阅读量499

点赞数 1

文章标签：数据库 c# string path null class

本文链接：https://blog.csdn.net/ysmz555/article/details/7360218

版权

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;
        }
    }