| Visit the Wiki | Find us on:

Discussion Forums

The online community for users of Map Suite GIS components

Unanswered Active Topics

Forums Search

Forums > Map Suite 2.x Legacy Support > Map Suite Desktop 2.x Support

MS SQL Connecting to DBF

Last Post 02-01-2009 09:09 PM by Scott. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

Kherrent Jayc User is Offline

Level 1
Posts:4
Avatar

01-22-2009 12:13 PM

Can anyone help i am using visual studio 2005, i made a database on MSSQL now when i converted the Shape file using CAD2Shape it generated Shp,Shx and Dbf now i want to connect the Database on the MSSQL to the Dbf, what i want to happen is when i put a color code on the MSSQL database it will also register on the Dbf database where i am using a foreign key for that database can you help me please

Val

MVP
Posts:1634
Avatar

01-23-2009 04:19 PM

I suggest you look at the sample app "Custom Data". This sample apps shows how to link up your own custom data with data from a shapefile. In this case, the external data comes from a DataTable but it could be in any other format including MSSQL. You can see in the method LoadCustomFields how the external data is linked to the dbf of the shapefile using the properties CustomData and LinkFieldName. If you need further help, let us know.

Kherrent Jayc User is Offline

Level 1
Posts:4
Avatar

01-27-2009 02:22 AM

Can you send me a sample of dbf manifulation where i can edit the dbf of the map and add and also delete dbf using vb.net 2005 i'am using mapsuite desktop 2.0 here is the database i will send you a link of my dbf ( http://www.fileden.com/files/2006/10/2/255217/StFrancisMap_lot.zip ) dbf,shp,shx

Scott

MVP
Posts:732
Avatar

02-01-2009 09:09 PM

Kherrent Jayc,

Thers is a sample application that names EditShapeFileApp to show you how to add, edit and delete the record from DBF file, in this sample, you can see, if you want to add, edit or delete records from DBF file, you have to use the BeginEdit() function to allow these write operations, then you can add, edit or delete the DBF, at last, you must to CommitEdit so that these changes are commited.

Thanks,

You are not authorized to post a reply.

Forums > Map Suite 2.x Legacy Support > Map Suite Desktop 2.x Support

Active Forums 4.2