请求帮助,sos
connection.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MIEDataBase.mdb", null, null, -1);
catalog.ActiveConnection = connection;
ADOX.Table AITable = new ADOX.Table();
ADOX.Table DITable = new ADOX.Table();
//新建表名字符串
AItableName = "模拟量" + DateTime.Now.ToString("yyyy_M_d_H:mm:ss");
DItableName = "数字量" + DateTime.Now.ToString("yyyy_M_d_H:mm:ss");
AITable.Name = AItableName;
DITable.Name = DItableName;
AITable.Columns.Append("时间", ADOX.DataTypeEnum.adDouble, 10);
AITable.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "时间", "", "");
AITable.Columns.Append("MP1", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP2", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP3", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP4", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP5", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP6", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP7", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP8", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP9", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP10", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP11", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP12", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP13", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP14", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("MP15", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("CF1", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("CF2", ADOX.DataTypeEnum.adDouble, 10);
AITable.Columns.Append("JJY", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("时间", ADOX.DataTypeEnum.adDouble, 10);
DITable.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, "时间", "", "");
DITable.Columns.Append("HJQ", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("BLF1", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("BLF2", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("YKF1", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("YKF2", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF1", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF2", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF3", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF4", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF5", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF6", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF7", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("CZF8", ADOX.DataTypeEnum.adDouble, 10);
DITable.Columns.Append("程序号", ADOX.DataTypeEnum.adWChar, 20);
catalog.Tables.Append(AITable);
catalog.Tables.Append(DITable);
connection.Close();
用这种方法如何设置字段(列)的属性呀,比如字段格式 默认值、必填字段、小数点位数等等。