初学mapInfo，部分笔记1-数据绑定_mapinfo热链接-优快云博客

本文介绍了一种从Oracle数据库的elloworld表获取数据，并将其绑定到MapInfo格式的worldTable的方法。通过使用ADO.NET和MapInfo API，实现了数据的顺利迁移。

部分关键代码：

constr = ConfigurationManager.ConnectionStrings["sqlcnstr"].ToString(); conn.Close(); conn.ConnectionString = constr; conn.Open(); //获得oracle中eworld表数据 SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "Select * from eworld"; //建立mapinfo格式worldTable并与oracle数据库eworld表进行数据绑定 TableInfoAdoNet ti = new TableInfoAdoNet("eworld"); StringCollection sc = new StringCollection(); sc.Add("Pop_1994"); //ti.Alias = "wordtable"; ti.KeyColumns = sc; ti.SequentialCommand = cmd; MapInfo.Data.MIConnection Connection = new MapInfo.Data.MIConnection(); Connection.Open(); Table eworldtable = Connection.Catalog.OpenTable(ti); //用于数据绑定的字段和集合 Column col0 = MapInfo.Data.ColumnFactory.CreateDoubleColumn("Pop_1994"); col0.ColumnExpression = eworldtable.Alias + "." + "Pop_1994"; Column col1 = MapInfo.Data.ColumnFactory.CreateIntColumn("Pop_Male"); col1.ColumnExpression = eworldtable.Alias + "." + "Pop_Male"; Column col2 = MapInfo.Data.ColumnFactory.CreateIntColumn("Pop_Fem"); col2.ColumnExpression = eworldtable.Alias + "." + "Pop_Fem"; Columns cols = new Columns(); cols.Add(col0); cols.Add(col1); cols.Add(col2); //绑定已存在的world图层 MapInfo.Data.Table worldTable = MapInfo.Engine.Session.Current.Catalog["world"]; //将数据添加到world图层中 worldTable.AddColumns(cols, BindType.DynamicCopy, eworldtable, "Country", Operator.Equal, "Country");

---------------------------------

广告：俺的淘宝小店，赚点零花钱，请大家支持：http://lovehealthylife.taobao.com