Hi Telerik team,
I'm working on a project that will display zip code mapping by state in the RadMap control.
I've loaded the entire US SHP values into our SQL Server. I've built a value table that has linked enhanced values to the geom column.
From there - I was able to build out an SSRS that used the MS VS "Map" control. Pretty easy, using their wizard.
We want to have advanced functionality that it looks like the RadMap and other Telerik tools can provide.
I've followed the examples on your website, and have a page that has the RadMap on it. Using the sample with the SHP file, I can display the counties, etc. I'm now trying to use my backend SQL records, and map those onto the RadMap.
Lots of talk about the "SqlGeospatialDataReader". I've downloaded and installed the latest Telerik set of controls. I'm at the stage of linking my SQL record set to the RadMap.
So far the best post is by another customer, "Yan", in
http://www.telerik.com/community/forums/silverlight/map/how-to-set-sqlgeospatialdatareader-programatically.aspx
It talks about creating the infolayer at run time and using a custom "ReadDataFromSQL();" function that loads the rows into "MyCollection".
Does the Collection<WktDataRow>() take a SQL result set, just as it is returned? Or do I need to do any special mapping for the columns?
- Brian
I'm working on a project that will display zip code mapping by state in the RadMap control.
I've loaded the entire US SHP values into our SQL Server. I've built a value table that has linked enhanced values to the geom column.
From there - I was able to build out an SSRS that used the MS VS "Map" control. Pretty easy, using their wizard.
We want to have advanced functionality that it looks like the RadMap and other Telerik tools can provide.
I've followed the examples on your website, and have a page that has the RadMap on it. Using the sample with the SHP file, I can display the counties, etc. I'm now trying to use my backend SQL records, and map those onto the RadMap.
Lots of talk about the "SqlGeospatialDataReader". I've downloaded and installed the latest Telerik set of controls. I'm at the stage of linking my SQL record set to the RadMap.
So far the best post is by another customer, "Yan", in
http://www.telerik.com/community/forums/silverlight/map/how-to-set-sqlgeospatialdatareader-programatically.aspx
It talks about creating the infolayer at run time and using a custom "ReadDataFromSQL();" function that loads the rows into "MyCollection".
Does the Collection<WktDataRow>() take a SQL result set, just as it is returned? Or do I need to do any special mapping for the columns?
- Brian