How do I Add pushpins and Polygon's from SQL Server?

Question

Morning all,

How do I add Pushpins to the Graphics layer from an SQL database?

Thanks,

JenniferNery · Answer

In the code-snippet, mp is the MapPoint retrieved from your DataService. This defines the location of the push pin.

BrianCook · Answer

Hi Jennifer.

Placing the symbol on the XAML I got. If you have a pushpin image, you can create a PictureMarkerSymbol. You can download the SDK to get this image. This will be your Graphic.Symbol.
<esri:PictureMarkerSymbol x:Key="PinPictureMarkerSymbol" OffsetX="11" OffsetY="39" Source="/Assets/images/i_pushpin.png" />

Assuming you have already defined a map with GraphicsLayer, a push pin symbol and have retrieved the map coordinates (mp) from SQL Server.
GraphicsLayer l = this.MyMap.Layers["MyGraphicsLayer"] as GraphicsLayer;
Graphic g = new Graphic()
{
 Geometry = new MapPoint(mp.X, mp.Y, MyMap.SpatialReference),
 Symbol = this.LayoutRoot.Resources["PinPictureMarkerSymbol"] as Symbol
};
l.Graphics.Add(g);

How is the code portion reading/getting the positions from my DataService?

Thanks!

JenniferNery · Answer

If you have a pushpin image, you can create a PictureMarkerSymbol. You can download the SDK to get this image. This will be your Graphic.Symbol.
<esri:PictureMarkerSymbol x:Key="PinPictureMarkerSymbol" OffsetX="11" OffsetY="39" Source="/Assets/images/i_pushpin.png" />

Assuming you have already defined a map with GraphicsLayer, a push pin symbol and have retrieved the map coordinates (mp) from SQL Server.
GraphicsLayer l = this.MyMap.Layers["MyGraphicsLayer"] as GraphicsLayer;
Graphic g = new Graphic()
{
 Geometry = new MapPoint(mp.X, mp.Y, MyMap.SpatialReference),
 Symbol = this.LayoutRoot.Resources["PinPictureMarkerSymbol"] as Symbol
};
l.Graphics.Add(g);