访问Acess的Table一个例子

2015-06-11 09:45:18 访问(1412) 赞(0) 踩(0)


TableInfoMSAccess TableInfoAccess = new TableInfoMSAccess("Office");

//Establish path and table information
TableInfoAccess.AccessTableName = "Offices";
TableInfoAccess.TablePath = @"C:\Program Files\MapInfo\MapXtreme\6.0\Samples\Data\SampleData.mdb";


TableInfoAccess.Columns.Add(ColumnFactory.CreateIntColumn("ID"));
TableInfoAccess.Columns.Add	 (ColumnFactory.CreateStringColumn("Office", 50));
TableInfoAccess.Columns.Add	 (ColumnFactory.CreateStringColumn(“Region", 50));
TableInfoAccess.Columns.Add	(ColumnFactory.CreateDecimalColumn("Long", 18, 6));
TableInfoAccess.Columns.Add	(ColumnFactory.CreateDecimalColumn("Lat", 18, 6));
TableInfoAccess.Columns.Add	 (ColumnFactory.CreateStringColumn("Country", 50));
TableInfoAccess.Columns.Add	 (ColumnFactory.CreateDecimalColumn("TrainingRev", 18, 2));

//返回Access数据
MapInfo.Engine.Session.Current.Catalog.OpenTable
	(TableInfoAccess);