惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

爱范儿
爱范儿
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
WordPress大学
WordPress大学
Apple Machine Learning Research
Apple Machine Learning Research
小众软件
小众软件
雷峰网
雷峰网
博客园 - 聂微东
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
博客园 - 三生石上(FineUI控件)
博客园_首页
博客园 - 司徒正美
博客园 - 叶小钗
IT之家
IT之家
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Hugging Face - Blog
Hugging Face - Blog
Last Week in AI
Last Week in AI
博客园 - 【当耐特】
宝玉的分享
宝玉的分享
有赞技术团队
有赞技术团队
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
T
Tailwind CSS Blog
V
V2EX
The Cloudflare Blog

博客园 - RayG

How to get data from Oracle DB in silverlight via WCF ? [Ray]How to use CString to create a font family - RayG [Copied] 80 VC++ tips [Copied]The GDI Coordinate Systems My Cheating Death solution in VC++ 3 given points, get the angle between two lines 计算几何常用算法(转) Trouble shooting about installation of ArcSDE 9.2 File type transform between ArcGIS and other major type - RayG [Tips] How to converting a Coverage to a Shapefile ? - RayG [Tips] How to Add New field into Shapefile attribute table in ArcGIS ? 子非鱼,安知鱼之乐? [GuanRui] My program implement on Symbian S60 (#1: File IO) - RayG My XNA HitBee small game [GuanRui]How to open Path browse dialog in VBA of ArcGIS Desktop ? [Ray] My GPS (卫星定位接收器) tracker program on Symbian OS Binary Tree ANSI C Implement (2) - RayG Binary Tree ANSI C Implement (1) Graph & Topology & Shortest path
trouble shoot about using BindLayer in MapX with C# [原创]
RayG · 2008-11-01 · via 博客园 - RayG

If you have problem about using BindLayer in MapX with C#, check this out. it may help.  

My Enviroment:Microsoft Visual Studio.NET 2005 (C#)  + Mapinfo MapX 5.02

Keywords: BindLayer ,DataSet,ADO,MapX,C#

Let's cut the bullshit, If you want to follow the VB6 sample to add a new bindlayer into your application, 

congrats, you will make most of your time waste. the .NET make things different. the old good time

passed away and never back again. 

Step 1: you have to add 2 COM reference into your application : ADODB also named Microsoft ActiveX Data Object 2.8

      MapX 5.0,why ADODB, cause the fucking .NET dataset will not work with MapX.

Setp 2: If you want to set you bindlayer style to miBindLayerTypeXY ,you need modify you database firstly, for example, you have to add new primary key columen into you database named like "MYID" in this sample . if you dont do so, there will be an error like "NOT FOUND GeoField or BindLayer".i bet you wont like that. 

Step 3: Copy these code into your program.you may change a little bit to fit your request.

Done! 

========================================================================

private string m_strConnString; 

private ADODB.Connection m_cnn; 

private ADODB.Recordset m_rds;

private ADODB.Recordset RetriveDataFromDB(string pConnString)

{

         m_strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Fart\\DB\\TestDB.mdb";

         m_bndlyrName = "MyBindlayer"; //Set your bindlayer name here

       m_cnn = new ADODB.Connection();

         m_rds = new ADODB.Recordset();

         m_cnn.Open(m_strConnString, null, null, -1);

         m_rds.ActiveConnection = m_cnn;

         m_rds.Open("SELECT MYID, Longitude_X,Latitude_Y FROM GUANRUI_TEST_TBL", m_cnn, ADODB.CursorTypeEnum.adOpenStatic, 

                    ADODB.LockTypeEnum.adLockOptimistic, 1);

         return m_rds;

 }

private void DoBindLayer(ADODB.Recordset pDs)

{

            MapXLib.BindLayer BindLyr;
            MapXLib.Dataset miDS;
            MapXLib.FieldsClass flds;

            miDS = null;
            flds = new MapXLib.FieldsClass();
            BindLyr = new MapXLib.BindLayer();

            flds.Add("MYID", "MYID", MapXLib.AggregationFunctionConstants.miAggregationIndividual, 
                        MapXLib.FieldTypeConstants.miTypeNumeric);
            flds.Add("Longitude_X", "Longitude_X", MapXLib.AggregationFunctionConstants.miAggregationIndividual, 
                        MapXLib.FieldTypeConstants.miTypeNumeric);
            flds.Add("Latitude_Y", "Latitude_Y", MapXLib.AggregationFunctionConstants.miAggregationIndividual, 
                        MapXLib.FieldTypeConstants.miTypeNumeric);
            BindLyr.LayerType = MapXLib.BindLayerTypeConstants.miBindLayerTypeXY;
            BindLyr.RefColumn1 = "Longitude_X";
            BindLyr.RefColumn2 = "Latitude_Y";
            BindLyr.LayerName = m_bndlyrName;
            //BindLyr.FileSpec = Application.StartupPath+ "\\DB\\Test.tab";
            //BindLyr.OverwriteFile = true;
            miDS = axMap1.DataSets.Add(MapXLib.DatasetTypeConstants.miDataSetADO, pDs, BindLyr.LayerName,
                "MYID", System.Reflection.Missing.Value, BindLyr, flds, false);

}