This is a migrated thread and some comments may be shown as answers.

Loading SQL values into RadMap

2 Answers 42 Views
Map
This is a migrated thread and some comments may be shown as answers.
Brian
Top achievements
Rank 1
Brian asked on 14 Aug 2013, 03:17 PM
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

2 Answers, 1 is accepted

Sort by
0
Andrey
Telerik team
answered on 16 Aug 2013, 03:01 PM
Hi Brian,

Unfortunately it is not quite clear from Yan's post what a kind of the WktDataRow class he used. it looks like it is custom class, but not a SQL result set, just as it is returned.

It is very complicated and it is hard to reproduce the problem without your solution. I have attached a working version SQLReaderWCF example. It works OK without any conversion of SQL result to a collection.
Could you please try it as a base for your project? Also could you, please, provide us with your solution or with a small sample solution which reproduces the problem if it appears again?

Regards,
Andrey Murzov
Telerik

TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
0
Thnghi
Top achievements
Rank 1
answered on 28 Aug 2013, 06:21 AM
Hi all,

I have a issue with using RadMap control of telerik silverlight. I use Telerik.Windows.Controls version 2013.2.724.1050, 

I found RadMap examples work well with old version: 2012.2.607.1050

Have any one can help me?

Thanks you very much
Tags
Map
Asked by
Brian
Top achievements
Rank 1
Answers by
Andrey
Telerik team
Thnghi
Top achievements
Rank 1
Share this question
or