1 新建数据库

1
2
3
4
5
6
7
8
9
10
11
12
13
14
string path = AppDomain.CurrentDomain.BaseDirectory + "\\test.mdb";
ADOX.CatalogClass catalog = new ADOX.CatalogClass();
try
{
    string connectionStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Jet OLEDB:Database Password=admin123;Jet OLEDB:Engine Type=5;";
    object v = catalog.Create(connectionStr);
    //OleDbConnection conn = new OleDbConnection(connectionStr);
    //conn.Open();
    //conn.Close();
}
catch(Exception ex)
{
	throw ex;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
insert into [表名](字段名) values('字段值')

delete from [表名] where [字段名]='字段值'

update [表名] set [字段名]=字段值 where [字段名]='字段值'

SELECT [字段名] FROM [表名]


alter table [表名] add column [字段名] 字段类型

alter table [表名] drop column [字段名]

alter table [表名] add primary key(字段名)

alter table [表名] drop primary key(字段名)


create table [表名]([字段名] 字段类型 [not null] [primary key],[字段名] 字段类型 [not null],..)

)