UC知道c#中怎么指定复合主键
来源：百度知道 编辑：UC知道 时间：2024/05/29 11:06:44
我有表BaseInfo
id name birthday course
1 liming 1980 高数
2 zhang 1982 线代
我使用下面的方法建表
ADOX.CatalogClass catlog = new ADOX.CatalogClass();
ADODB.Connection cn = new ADODB.Connection();
cn.Open(dbpath, null, null, -1);
catlog.ActiveConnection = cn;
ADOX.TableClass tbl = new ADOX.TableClass();
tbl.ParentCatalog = catlog;
tbl.Name = "BaseInfo";//表名
//1id
ADOX.ColumnClass col1 = new ADOX.ColumnClass();
col1.ParentCatalog = catlog;
col1.Name = "id";
col1.Properties["Jet OLEDB:Allow Zero Length"].Value = false;
//2name
ADOX.ColumnClass col2 = new ADOX.ColumnClass();
col2.ParentCatalog = catlog;
col2.Name = "name";
//3birthday
ADOX.ColumnClass col3 = new ADOX.ColumnClass();
col3.ParentCatalog = catlog;
col3.Name = "birthday";
col3.Properties["Jet OLEDB:Allow Zero Len
id name birthday course
1 liming 1980 高数
2 zhang 1982 线代
我使用下面的方法建表
ADOX.CatalogClass catlog = new ADOX.CatalogClass();
ADODB.Connection cn = new ADODB.Connection();
cn.Open(dbpath, null, null, -1);
catlog.ActiveConnection = cn;
ADOX.TableClass tbl = new ADOX.TableClass();
tbl.ParentCatalog = catlog;
tbl.Name = "BaseInfo";//表名
//1id
ADOX.ColumnClass col1 = new ADOX.ColumnClass();
col1.ParentCatalog = catlog;
col1.Name = "id";
col1.Properties["Jet OLEDB:Allow Zero Length"].Value = false;
//2name
ADOX.ColumnClass col2 = new ADOX.ColumnClass();
col2.ParentCatalog = catlog;
col2.Name = "name";
//3birthday
ADOX.ColumnClass col3 = new ADOX.ColumnClass();
col3.ParentCatalog = catlog;
col3.Name = "birthday";
col3.Properties["Jet OLEDB:Allow Zero Len
// 设置多列主键（联合主键）
ADOX.Key PK_Key = new ADOX.Key();
PK_Key.Columns.Append("字段1");
PK_Key.Columns.Append("字段2");
PK_Key.Name = "PrimaryKey";
tbl.Keys.Append(PK_Key, ADOX.KeyTypeEnum.adKeyPrimary);
在建表时，在id,name同时加主键。