topic Re: How do I Add pushpins and Polygon's from SQL Server? in ArcGIS API for Silverlight Questions

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

BrianCook — Tue, 19 Apr 2011 12:07:26 GMT

Morning all,

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

Thanks,

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

JenniferNery — Tue, 19 Apr 2011 20:30:09 GMT

Have you looked into this blog post? http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlight-and-the-server-using-WCF.aspx

I think you can use WCF service to get geometries from your SQL Server. Then it would be as simple as creating Graphics, setting their Geometry (Polygon or MapPoint), applying appropriate symbol (Fill or Marker), and adding them to your GraphicsLayer. http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#AddGraphicsXAML

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

BrianCook — Wed, 20 Apr 2011 15:24:50 GMT

Yes, I have a WCF Service, just was not sure how ESRI tag is supposed to look like to pull it from the DB.

With Bing Maps it would look like this;

<m:Pushpin m:MapLayer.Position="{Binding Location}" Background="Blue">

So i guess I should have asked; How do I do the above in ESRI?

Thanks,

Have you looked into this blog post? http://blogs.esri.com/Dev/blogs/silverlightwpf/archive/2010/03/11/Sending-geometry-between-Silverlight-and-the-server-using-WCF.aspx

I think you can use WCF service to get geometries from your SQL Server. Then it would be as simple as creating Graphics, setting their Geometry (Polygon or MapPoint), applying appropriate symbol (Fill or Marker), and adding them to your GraphicsLayer. http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#AddGraphicsXAML

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

JenniferNery — Sat, 11 Dec 2021 07:06:51 GMT

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

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

BrianCook — Sat, 11 Dec 2021 07:06:54 GMT

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!

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

JenniferNery — Thu, 21 Apr 2011 19:23:22 GMT

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