static void Main(string[] args)
{
// required COM reference: Microsoft Office 14.0 Access Database Engine Object Library
var dbe = new Microsoft.Office.Interop.Access.Dao.DBEngine();
Microsoft.Office.Interop.Access.Dao.Database db = dbe.Workspaces[0].OpenDatabase(@"C:\Users\Public\Database1.accdb");
Microsoft.Office.Interop.Access.Dao.Field fld = db.TableDefs["myTable"].Fields["oldFieldName"];
fld.Name = "newFieldName";
db.Close();
}
static void Main(string[] args)
{
// required COM reference: Microsoft Office 14.0 Access Database Engine Object Library
var dbe = new Microsoft.Office.Interop.Access.Dao.DBEngine();
Microsoft.Office.Interop.Access.Dao.Database db = dbe.Workspaces[0].OpenDatabase(@"C:\__tmp\testData.accdb");
Microsoft.Office.Interop.Access.Dao.Field fld = db.TableDefs["poiData"].Fields["lon"];
Console.WriteLine("Properties[\"DecimalPlaces\"].Value was: " + fld.Properties["DecimalPlaces"].Value);
fld.Properties["DecimalPlaces"].Value = 5;
Console.WriteLine("Properties[\"DecimalPlaces\"].Value is now: " + fld.Properties["DecimalPlaces"].Value);
db.Close();
Console.WriteLine("Hit a key...");
Console.ReadKey();
}
static void Main(string[] args)
{
string TableName = "Cars";
string FieldName = "CarType";
// This code requires the following COM reference in your project:
//
// Microsoft Office 14.0 Access Database Engine Object Library
//
var dbe = new Microsoft.Office.Interop.Access.Dao.DBEngine();
Microsoft.Office.Interop.Access.Dao.Database db = dbe.OpenDatabase(@"Z:\_xfer\Database1.accdb");
try
{
Microsoft.Office.Interop.Access.Dao.Field fld = db.TableDefs[TableName].Fields[FieldName];
string RowSource = "";
try
{
RowSource = fld.Properties["RowSource"].Value;
}
catch
{
// do nothing - RowSource will remain an empty string
}
if (RowSource.Length == 0)
{
Console.WriteLine("The field is not a lookup field.");
}
else
{
Console.WriteLine(RowSource);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
/// <summary>
/// 录入附件信息
/// </summary>
/// <param name="dtTemp2">附件2的模板数据</param>
/// <param name="dtTemp3">附件3的模板数据</param>
/// <returns></returns>
private string insertDataTable(DataTable dtTemp2, DataTable dtTemp3)
{
string msg = string.Empty;
Microsoft.Office.Interop.Access.Dao.Database db = dbEngine.OpenDatabase(Utils.dataPath);
Microsoft.Office.Interop.Access.Dao.Recordset rs = db.OpenRecordset("INFOMATION_ENTITIES");
Microsoft.Office.Interop.Access.Dao.Field[] myFields = new Microsoft.Office.Interop.Access.Dao.Field[65];
myFields[0] = rs.Fields["VIN"];
myFields[1] = rs.Fields["CLXZ"];
myFields[2] = rs.Fields["CLZL"];
myFields[3] = rs.Fields["GCSF"];
myFields[4] = rs.Fields["GCCS"];
myFields[5] = rs.Fields["CLYT"];
myFields[6] = rs.Fields["CLXH"];
myFields[7] = rs.Fields["GGPC"];
myFields[8] = rs.Fields["CLPZ"];
myFields[9] = rs.Fields["EKGZ"];
myFields[10] = rs.Fields["GMJG"];
myFields[11] = rs.Fields["SQBZBZ"];
myFields[12] = rs.Fields["FPHM"];
myFields[13] = rs.Fields["FPSJ"];
myFields[14] = rs.Fields["XSZSJ"];
myFields[15] = rs.Fields["FPTP"];
myFields[16] = rs.Fields["XSZTP"];
myFields[17] = rs.Fields["FPTP_PICTURE"];
myFields[18] = rs.Fields["XSZTP_PICTURE"];
myFields[19] = rs.Fields["CJDRXX_CXXH"];
myFields[20] = rs.Fields["CJDRXX_DRZRL"];
myFields[21] = rs.Fields["CJDRXX_DRZSCQY"];
myFields[22] = rs.Fields["CJDRXX_DTSCQY"];
myFields[23] = rs.Fields["CJDRXX_DTXH"];
myFields[24] = rs.Fields["CJDRXX_XTJG"];
myFields[25] = rs.Fields["CJDRXX_ZBNX"];
myFields[26] = rs.Fields["CLSFYCJDR"];
myFields[27] = rs.Fields["CLSFYQDDJ2"];
myFields[28] = rs.Fields["CLSFYRLDC"];
myFields[29] = rs.Fields["DCDTXX_SCQY"];
myFields[30] = rs.Fields["DCDTXX_XH"];
myFields[31] = rs.Fields["DCZXX_SCQY"];
myFields[32] = rs.Fields["DCZXX_XH"];
myFields[33] = rs.Fields["DCZXX_XTJG"];
myFields[34] = rs.Fields["DCZXX_ZBNX"];
myFields[35] = rs.Fields["DCZXX_ZRL"];
myFields[36] = rs.Fields["QDDJXX_EDGL_1"];
myFields[37] = rs.Fields["QDDJXX_EDGL_2"];
myFields[38] = rs.Fields["QDDJXX_SCQY_1"];
myFields[39] = rs.Fields["QDDJXX_SCQY_2"];
myFields[40] = rs.Fields["QDDJXX_XH_1"];
myFields[41] = rs.Fields["QDDJXX_XH_2"];
myFields[42] = rs.Fields["QDDJXX_XTJG_1"];
myFields[43] = rs.Fields["QDDJXX_XTJG_2"];
myFields[44] = rs.Fields["RLDCXX_EDGL"];
myFields[45] = rs.Fields["RLDCXX_GMJG"];
myFields[46] = rs.Fields["RLDCXX_SCQY"];
myFields[47] = rs.Fields["RLDCXX_XH"];
myFields[48] = rs.Fields["RLDCXX_ZBNX"];
myFields[49] = rs.Fields["JZNF"];
myFields[50] = rs.Fields["BGLHDL"];
myFields[51] = rs.Fields["CLCMYCDNGXSLC"];
myFields[52] = rs.Fields["CLYCCMDSXSJ"];
myFields[53] = rs.Fields["CLYXDW"];
myFields[54] = rs.Fields["JKPDXXDW"];
myFields[55] = rs.Fields["LJCDL"];
myFields[56] = rs.Fields["LJJQL"];
myFields[57] = rs.Fields["LJJQL_G"];
myFields[58] = rs.Fields["LJJQL_L"];
myFields[59] = rs.Fields["LJJYL"];
myFields[60] = rs.Fields["LJXSLC"];
myFields[61] = rs.Fields["PJDRXYSJ"];
myFields[62] = rs.Fields["SFAZJKZZ"];
myFields[63] = rs.Fields["YJXSLC"];
myFields[64] = rs.Fields["ZDCDGL"];
for (int i = 0; i < dtTemp2.Rows.Count; i++)
{
string vin = dtTemp2.Rows[i]["VIN"].ToString().Trim();
string clpz = dtTemp2.Rows[i]["CLPZ"].ToString().Trim();
try
{
var sel3 = (from t3 in dtTemp3.AsEnumerable()
where t3.Field <string>("CLPZ").Equals(clpz)
select t3).CopyToDataTable();
rs.AddNew();
myFields[0].Value = dtTemp2.Rows[i]["VIN"];
myFields[1].Value = string.Empty;
myFields[2].Value = dtTemp2.Rows[i]["CLZL"];
myFields[3].Value = dtTemp2.Rows[i]["GCSF"];
myFields[4].Value = dtTemp2.Rows[i]["GCCS"];
myFields[5].Value = dtTemp2.Rows[i]["CLYT"];
myFields[6].Value = dtTemp2.Rows[i]["CLXH"];
myFields[7].Value = string.Empty;
myFields[8].Value = dtTemp2.Rows[i]["CLPZ"];
myFields[9].Value = string.Empty;
myFields[10].Value = dtTemp2.Rows[i]["GMJG"];
myFields[11].Value = dtTemp2.Rows[i]["SQBZBZ"];
myFields[12].Value = dtTemp2.Rows[i]["FPHM"];
myFields[13].Value = dtTemp2.Rows[i]["FPSJ"];
myFields[14].Value = dtTemp2.Rows[i]["XSZSJ"];
myFields[15].Value = dtTemp2.Rows[i]["FPTP"];
myFields[16].Value = dtTemp2.Rows[i]["XSZTP"];
myFields[17].Value = dtTemp2.Rows[i]["FPTP_PICTURE"];
myFields[18].Value = dtTemp2.Rows[i]["XSZTP_PICTURE"];
myFields[19].Value = dtTemp2.Rows[i]["CJDRXX_CXXH"];
myFields[20].Value = dtTemp2.Rows[i]["CJDRXX_DRZRL"];
myFields[21].Value = dtTemp2.Rows[i]["CJDRXX_DRZSCQY"];
myFields[22].Value = dtTemp2.Rows[i]["CJDRXX_DTSCQY"];
myFields[23].Value = dtTemp2.Rows[i]["CJDRXX_DTXH"];
myFields[24].Value = dtTemp2.Rows[i]["CJDRXX_XTJG"];
myFields[25].Value = dtTemp2.Rows[i]["CJDRXX_ZBNX"];
myFields[26].Value = dtTemp2.Rows[i]["CLSFYCJDR"];
myFields[27].Value = dtTemp2.Rows[i]["CLSFYQDDJ2"];
myFields[28].Value = dtTemp2.Rows[i]["CLSFYRLDC"];
myFields[29].Value = dtTemp2.Rows[i]["DCDTXX_SCQY"];
myFields[30].Value = dtTemp2.Rows[i]["DCDTXX_XH"];
myFields[31].Value = dtTemp2.Rows[i]["DCZXX_SCQY"];
myFields[32].Value = dtTemp2.Rows[i]["DCZXX_XH"];
myFields[33].Value = dtTemp2.Rows[i]["DCZXX_XTJG"];
myFields[34].Value = dtTemp2.Rows[i]["DCZXX_ZBNX"];
myFields[35].Value = dtTemp2.Rows[i]["DCZXX_ZRL"];
myFields[36].Value = dtTemp2.Rows[i]["QDDJXX_EDGL_1"];
myFields[37].Value = dtTemp2.Rows[i]["QDDJXX_EDGL_2"];
myFields[38].Value = dtTemp2.Rows[i]["QDDJXX_SCQY_1"];
myFields[39].Value = dtTemp2.Rows[i]["QDDJXX_SCQY_2"];
myFields[40].Value = dtTemp2.Rows[i]["QDDJXX_XH_1"];
myFields[41].Value = dtTemp2.Rows[i]["QDDJXX_XH_2"];
myFields[42].Value = dtTemp2.Rows[i]["QDDJXX_XTJG_1"];
myFields[43].Value = dtTemp2.Rows[i]["QDDJXX_XTJG_2"];
myFields[44].Value = dtTemp2.Rows[i]["RLDCXX_EDGL"];
myFields[45].Value = dtTemp2.Rows[i]["RLDCXX_GMJG"];
myFields[46].Value = dtTemp2.Rows[i]["RLDCXX_SCQY"];
myFields[47].Value = dtTemp2.Rows[i]["RLDCXX_XH"];
myFields[48].Value = dtTemp2.Rows[i]["RLDCXX_ZBNX"];
myFields[49].Value = dtTemp2.Rows[i]["JZNF"];
myFields[50].Value = sel3.Rows[0]["BGLHDL"];
myFields[51].Value = sel3.Rows[0]["CLCMYCDNGXSLC"];
myFields[52].Value = sel3.Rows[0]["CLYCCMDSXSJ"];
myFields[53].Value = dtTemp2.Rows[i]["CLYXDW"];
myFields[54].Value = sel3.Rows[0]["JKPDXXDW"];
myFields[55].Value = sel3.Rows[0]["LJCDL"];
myFields[56].Value = sel3.Rows[0]["LJJQL"];
myFields[57].Value = sel3.Rows[0]["LJJQL_G"];
myFields[58].Value = sel3.Rows[0]["LJJQL_L"];
myFields[59].Value = sel3.Rows[0]["LJJYL"];
myFields[60].Value = sel3.Rows[0]["LJXSLC"];
myFields[61].Value = sel3.Rows[0]["PJDRXYSJ"];
myFields[62].Value = sel3.Rows[0]["SFAZJKZZ"];
myFields[63].Value = sel3.Rows[0]["YJXSLC"];
myFields[64].Value = sel3.Rows[0]["ZDCDGL"];
rs.Update();
}
catch (Exception ex)
{
msg += String.Format("车辆识别代码(VIN)：{0}的异常信息{1}，操作异常{2}", vin, ex.Message, Environment.NewLine);
continue;
}
}
rs.Close();
db.Close();
return(msg);
}
