Hello

I developp an add-in for MapPoint 2004 in C sharp and I want to list all the pushpin's name that are in the map

for example I load an excel file that have 5 groups of pushpins and I want to enumerate all of them in a listbox, how can I do this ?

whith this code I can only access to the first pushpin, but not the others:

object o = 1;


MapPoint.DataSet ds = app.ActiveMap.DataSets.get_Item(ref o);
MapPoint.Recordset rs = ds.QueryAllRecords();
rs.MoveFirst();
while (!rs.EOF)
{
MapPoint.Location loc = rs.Pushpin.Location;
MessageBox.Show(loc.Name);
rs.MoveNext();
}

thanks

Hi,

I just tryed exacly the same (check my code eventually), and it display's all pushpins currently on the map:

Code:

    object o = 1;
    MapPoint.DataSet ds = mp.ActiveMap.DataSets.get_Item(ref o);
    Recordset rs = ds.QueryAllRecords();
    rs.MoveFirst();
    while (!rs.EOF) {
        Location loc = rs.Pushpin.Location;
        Console.WriteLine(rs.Pushpin.Name.ToString());
        Console.WriteLine(loc.Name); // both are the same
        rs.MoveNext();
    }

Showing a messagebox non modal should give the same result.

But this code doesn't show all of the group of pushpin ( "clicks-infos" in my french version of MapPoint ), it show only the first group of "click info"

for example you can see in this screenshot 7 "clicks-infos" ( group of pushpin ) :



the source code in my first message shows only the first "click info" ( pushpin AGF in the screenshot ),

But I want to list all of the pusphin in the map ( the 7 "clicks infos" )

do you have an idea to do this ?

thanks

Hi,

I hope I understeand all now
I think they are in different datasets. So you have to parse trough all datasets. Something like this should work. I did test it, but did not checked it with several datasets:

Code:

            MapPoint.DataSets dataSets = mp.ActiveMap.DataSets;
            foreach (MapPoint.DataSet ds in dataSets) {
                Recordset rs = ds.QueryAllRecords();
                rs.MoveFirst();
                while (!rs.EOF) {
                    Location loc = rs.Pushpin.Location;
                    Console.WriteLine(loc.Name);
                    rs.MoveNext();
                }
            }

Thanks it's ok

but now I want to retrieve adress, postalcode and city from the pushpin,

I use this code:

string sParamPushpin;

//street name
sParamPushpin+=loc.StreetAddress.Street + ";";

//postalcode
sParamPushpin+=loc.StreetAddress.PostalCode +";";

//City
sParamPushpin+=loc.StreetAddress.City + ";";

//Country
sParamPushpin+=loc.StreetAddress.Country;

but this code doesn't work for some pushpin, for example for "postalcode" the value is incorrect ( 00014 instead of 44000 ), I don't understand

what is the correct syntax for retrieving the street adress, postalcode and city from a pushpin ?

Hi,

You do the correct code. But I recall other post that sometime the postcode is not the right one. Also you can get (I think) incorrect results if your pushpin is not on a known street.

It's very strange, because when I export the data to Excel ( with a right click on the "clic-info" in the screenshot ) then I can see the correct adress in the excel file

theses pushpins in my example come from an import data process ( file TXT or excel file )