Hello,

I've created DataSet based on a requery witch is the following :
Num_FDT (primary key), ADRESS, ZIPCODE, CITY

When I display any of the matching pushpins, name of the
pushpin is the STREET !

Code:

    Dim objDS As MapPoint.DataSet
    Dim strXNC As String
    With Me.ctrlMP.ActiveMap.DataSets
        strcnx = gBDD_LOCAL & "!" & "ReqSQL"
        Set objDS = .LinkData(strcnx, "NUM_FDT", , geoCountryFrance, , geoImportAccessQuery)
        objDS.Symbol = 26
        arArray = Array(objDS.Fields(1), objDS.Fields(2), objDS.Fields(3), objDS.Fields(4))
        objDS.SetFieldsVisibleInBalloon arArray
    End With

How to set the primary key in the pushpin's name ?

It's very important because I've to use the .Find method...

King regards,

Vincent BENNER

You'll have to specify the optional [ArrayOfFields] parameter in LinkData before calling LinkData. Something like this in your case ...

Dim objDS As MapPoint.DataSet
Dim strXNC As String
Dim myFieldArray(1 To 4, 1 To 2) As Variant
With Me.ctrlMP.ActiveMap.DataSets
strcnx = gBDD_LOCAL & "!" & "ReqSQL"

myFieldArray(1, 1) = "NUM_FDT"
myFieldArray(1, 2) = geoFieldName

myFieldArray(2, 1) = "ADDRESS"
myFieldArray(2, 2) = geoFieldAddress1

myFieldArray(3, 1) = "ZIPCODE"
myFieldArray(3, 2) = geoFieldPostal1

myFieldArray(4, 1) = "CITY"
myFieldArray(4, 2) = geoFieldCity

Set objDS = .LinkData(strcnx, "NUM_FDT", myFieldArray, geoCountryFrance, , geoImportAccessQuery)

objDS.Symbol = 26
arArray = Array(objDS.Fields(1), objDS.Fields(2), objDS.Fields(3), objDS.Fields(4))
objDS.SetFieldsVisibleInBalloon arArray
End With

Thank you very much for your help ! It's exactly what I need.

King regards,

Vincent BENNER

What is the ArArray in the code?

How can i do the same thing in C#.. i just need to know how to create the Array as u did above please.

Thank you very much and hope to hear from you asap