MapForums

Hi.

I have a vb6 application that uses mappoint control. I have another pocket pc application that reads gps coordinates and store the generated data in a sql server table.

I need to know how to:

1. draw the path in a map based on collected gps coordinates;
2. import sql server data using a query (I used a udl file and used "file.udl!TableName" and it works fine but I need to use "file.udl!SqlServerQuery" or other method to import the data);
3. having a mappoint dataset with data (latitude,longitude, value1, value2), how to show a column chart in all the locations?
4. how to define the color for each column;

Thanks in advance.

RAPZ.

I think you can do everything except #4, it does not let you set the colors.

#1, see the AddLine method.
#2, you might need to use a View?
For #3 you will use the DisplayDataMap method. For me DisplayDataMap is almost always a pain to deal with but after trial and error I eventually get it to work.

hope this helps.

For general programming help, besides the Help File which is great, both the MapPoint for Dummies and Programming MapPoint in .NET books will help you get up to speed with MapPoint and give you ideas of what it is capable of...

Eric

Thanks for the reply.

I will try your tips...but I really need to choose the colums color for columns chart. If someone know how...more tips will be nice!

Thanks again.
RAPZ.

I had looked in the Data Mapping Wizard and it didn't look like it gave you the option to change the color ?

I started poking through the DisplayDataMap method options, and in the ColorScheme property it looks like there are options for the Series Column Chart, see the bottom graphic -- "Color schemes available with Series Column Chart maps". So you can set the color, but the Series Column Chart always has bars of all the same color.

It does not look like there is a way to set the colors of the bars of the regular "Column Chart".

One thing you might consider is to use MapInfo Pro to map your data on top of MapPoint using the tool "Map-In-A-Box" to tie them together.

You can see some examples of what is possible in this article --

Map-In-A-Box Puts MapPoint Maps Into MapInfo

Eric