Hi everybody
I have my custom database that has one table that contains x, y coordinates. Now I trying to find out how I can programatically retieve the records from the table and plot the points on the feature layer and then use one of the attributes column from the same table for labling the points on the created layer.
Can any one help me with a sample code or a web page url where I can get sample code or description of how to go about this.
Best Regards,
Vincent
This is a common request to be able to plot on the map a point and label it based on some table that has X and Y information. We have a project in the Code Community Moving Vehicle with Label that shows how to retrieve X and Y information from a regular text file and plot it and label it on the map. In this project, we use the IO functions for retrieving data from a text file. The only difference for you, is that you will need to use the API for your own database which is general/database programming.
You can check the project out at: code.thinkgeo.com/projects/movingvehiclelabel
Vincent,
To Answer the database question we have a sample that does exactly what you need. The sample gets x & y coordinates from any oledb database and exposes them as a layer. The complete code is provided so you can see the internals of what is going on and modify as you see fit. The sample goes against ms access but you just need to change the connection string to make it work for other databases.
code.thinkgeo.com/projects/oledbpointfeature
David
hi
in sample oledbpointfeature project if work in getboundbox() function that ok or not. because i test not work that
Hi,
There is a property which named “HasBoundingBox”, it is a virtual property in base class “layer”, if you want to get the layer’s bounding box, you must override this property, like following statements:
public override bool HasBoundingBox
{
get { return true; }
}
I guess we must append these codes into OledbFeatureLayer.cs in OledbFeatureSource project.
Best Regards,
Johnny