topic Re: Creating Graphics from Table with XY in ArcGIS API for Silverlight Questions

Creating Graphics from Table with XY

JayKappy — Mon, 07 Nov 2011 13:29:39 GMT

Is there a way to interact with a stand alone table in SQL server if the table has an XY...
I am able to retrieve results in a simple datagrid/dataform in silverlight but want to add a graphic componemt...
What I want to do (dont know if its possible)

1. Is create graphics points from the XY fields in the table
2. Allow the user to select the graphic point and retrieve attribute information
3. eventually edit the values

This possible? An examples out there?

THanks

Re: Creating Graphics from Table with XY

RobertBurke — Mon, 07 Nov 2011 14:25:22 GMT

Have you had a look at the samples to add graphics and work with Map Tips?

http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#AddGraphicsXAML

http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#GraphicsMapTip

Is your SQL Server database a geodatabase?

Re: Creating Graphics from Table with XY

JayKappy — Tue, 08 Nov 2011 13:42:05 GMT

I will look at those links...I have done that before...but only with Data that was from a MapServive/Geodatabase

As to your second question...NO...this is a SQL Server table....its just information with an XY...I am populating the XY from another table....A standalone table with XY...NOT a geodatabase or data being pushed from a MapService...

possible?

Re: Creating Graphics from Table with XY

JenniferNery — Thu, 10 Nov 2011 16:37:25 GMT

Sure you can use WCF Service to connect to your SQL Server. This might help:http://mscoder.wordpress.com/2010/07/11/datagrid-binding-and-crud-operations-in-silverlight-4-using-wcf-service/

Once you can get the X,Y values, you can add it to your GraphicsLayer, just as in this SDK sample: http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#AddGraphics.

Re: Creating Graphics from Table with XY

IgressT — Thu, 10 Nov 2011 19:26:06 GMT

I had a similar requirement. However the size of the SQL server XY tabe was very huge and I had to retrieve all the points to show them on the map. Connecting with WCF and returning
all the data was not going to work because of the size o the data.

I ended up using Query Layer

Re: Creating Graphics from Table with XY

dotMorten_esri — Fri, 06 Jan 2012 19:09:05 GMT

Also see this sample: http://www.arcgis.com/home/item.html?id=6d28a606369c43fd9a6f929541ae7c93
For large datasets, you are going to need to use paging though to iterate over multiple queries and incremently load the data. However I do believe that if you need to send that much data down to the client, you are doing it wrong 🙂 Try to be smart about what data you load, and keep as much as possible on the server until needed.