Table操作示例

2015-06-11 09:50:24 访问(1362) 赞(0) 踩(0)


MapInfo.Data.TableInfodBase tableInfodBase = 
   new MapInfo.Data.TableInfodBase("myTable");
tableInfodBase.TablePath = @"c:\temp\myTable.Tab";
tableInfodBase.Columns.Add
  (MapInfo.Data.ColumnFactory.CreateStringColumn("ID", 10));
tableInfodBase.Columns.Add
  (MapInfo.Data.ColumnFactory.CreateDoubleColumn("Longitude"));
tableInfodBase.Columns.Add
  (MapInfo.Data.ColumnFactory.CreateDoubleColumn("Latitude"));
MapInfo.Data.SpatialSchemaXY miSpatialSchemaXY 
   = new MapInfo.Data.SpatialSchemaXY();
miSpatialSchemaXY.CoordSys = 
   MapInfo.Engine.Session.Current.CoordSysFactory.CreateLongLat
   (MapInfo.Geometry.DatumID.WGS84);
miSpatialSchemaXY.NullPoint = "0.0, 0.0";
miSpatialSchemaXY.XColumn = "LONGITUDE";
miSpatialSchemaXY.YColumn = "LATITUDE";
tableInfodBase.SpatialSchema = miSpatialSchemaXY;
MapInfo.Data.Table table = 
  MapInfo.Engine.Session.Current.Catalog.OpenTable(table InfodBase);
mapControl1.Map.Layers.Add(new FeatureLayer(table));


System.Data.DataTable dataTable = new System.Data.DataTable("WorldData");
dataTable.Columns.Add("CountryCode", typeof(string));
dataTable.Columns.Add("NumWidgets", typeof(double));
dataTable.Rows.Add(new object[]{"USA", 100000});
dataTable.Rows.Add(new object[]{"DEU", 672394});
dataTable.Rows.Add(new object[]{"CAN", 209310});
MapInfo.Data.Table tableReceive = MapInfo.Engine.Session.Current.Catalog.OpenTable(@"c:\ data\WorldWithCountryCodes.Tab");
MapInfo.Data.TableInfoAdoNet tableInfo = new MapInfo.Data.TableInfoAdoNet("Give", dataTable);
MapInfo.Data.Table tableGive = MapInfo.Engine.Session.Current.Catalog.CreateTable(tableInfo);
MapInfo.Data.Columns cols = new MapInfo.Data.Columns();
MapInfo.Data.Column col = new MapInfo.Data.Column("NumWidgets", MapInfo.Data.MIDbType.String);
cols.Add(col);
tableReceive.AddColumns(cols, MapInfo.Data.BindType.Static, tableGive, "CountryCode", MapInfo.Data.Operator.Equal, "WorldCountryCode")