1.首先需要添加两个引用:
//引用COM:Microsoft ADO Ext. 2.8 for DDL and Security
//添加引用:Microsoft ActioveX Data Objects 2.8 Library2.添加
using System.Data.OleDb;
using ADOX;
3.创建数据库代码
public void CreateDataBase(string
path)
{
string conn = "Provider =Microsoft.Jet.OLEDB.4.0;Data Source =" + path;
ADOX.Catalog catalog = new ADOX.Catalog();
catalog.Create(conn);
ADODB.Connection cn = new ADODB.Connection();
cn.Open(conn, null, null, -1);
catalog.ActiveConnection = cn;
try
{
//创建表
ADOX.Table table2 = new ADOX.Table();
table2.Name = "tableName";
//添加列
ADOX.Column column = new ADOX.Column();
column.ParentCatalog = catalog;
column.Type = ADOX.DataTypeEnum.adInteger;
column.Name = "ID";
column.DefinedSize = 9;
column.Properties["AutoIncrement"].Value = true;
table2.Columns.Append(column, ADOX.DataTypeEnum.adInteger, 0);
//设定主键
table2.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "S_ID", "", "");
table2.Columns.Append("S_ID", ADOX.DataTypeEnum.adVarWChar, 0);
table2.Columns.Append("Remark", ADOX.DataTypeEnum.adVarWChar, 0);
catalog.Tables.Append(table2);
table2 = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
catalog = null;
cn.Close();
}
转载自 http://hi.baidu.com/retrying/item/3e0d74eae1d68b0264db0008
自己适当做些整理