MapForums

Elbarto · #1 (**permalink**) 03-02-2006

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:

Quote:

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

**Wilfried** · #2 (**permalink**) 03-03-2006

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.

Elbarto · #3 (**permalink**) 03-04-2006

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

**Wilfried** · #4 (**permalink**) 03-04-2006

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();
                }
            }

Elbarto · #5 (**permalink**) 03-06-2006

Thanks it's ok

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

I use this code:

Quote:

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 ?

**Wilfried** · #6 (**permalink**) 03-06-2006

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.

Elbarto · #7 (**permalink**) 03-06-2006

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 )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Block group geographies	bcimapr	Wish List	1	12-01-2004 02:05 PM
Printing a corresponding list of addresses from pushpins	Anonymous	MapPoint 2006/2009 Discussion	0	10-26-2004 02:54 PM
Finding the center of a group of pushpins	Anonymous	MapPoint 2006/2009 Discussion	3	04-07-2004 04:51 PM
Select pushpins list	tanguy_laverdure	MapPoint 2006/2009 Discussion	0	02-20-2004 09:59 AM
Is it possible to group several pushpins together,....	Anonymous	MapPoint 2006/2009 Discussion	1	08-27-2001 01:03 PM

MapForums

How to list the name of all group of pushpins ?

How to list the name of all group of pushpins ?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads

MapForums

How to list the name of all group of pushpins ?

How to list the name of all group of pushpins ?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads