Loading SQL values into RadMap

3 posts, 0 answers
  1. Brian
    Brian avatar
    1 posts
    Member since:
    Aug 2013

    Posted 14 Aug 2013 Link to this post

    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. Andrey
    Admin
    Andrey avatar
    1681 posts

    Posted 16 Aug 2013 Link to this post

    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 >>
  3. DevCraft banner
  4. Thnghi
    Thnghi avatar
    9 posts
    Member since:
    Feb 2013

    Posted 28 Aug 2013 Link to this post

    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
Back to Top