[Solved] Error AsyncSqlGeospatialDataReader

[Renier Pretorius]

Hi,

 

I have successfully used the AsyncSqlGeospatialDataReader to read shape data stored in a geometry column in SQL. I first read the geometry objects into a local collection and then assign that collection to the reader

var readerRail = new Telerik.Windows.Controls.Map.SqlGeospatialDataReader();
readerRail.Source = RailShapes;
readerRail.ToolTipFormat = "{SegmentLabel}";
readerRail.GeospatialPropertyName = "ShapeWKT";
readerRail.PreviewReadCompleted += readerRail_PreviewReadCompleted;

 

However, while this has worked on three previous collections on this specific one I get a "Non-static method requires a target" error. It seems as if some of the shape data must then be an issue but I have no idea where to start looking.

 PS: SQL Management studio can query the data and display it

 

[Renier Pretorius]

Hi,

Please ignore. I found my error. A bit embarrassed for not picking it up before posting. I am merging some database business object with shape data from shapefiles imported into SQL Server. Not all business objects where matched, hence the Geospatial Property of some was null causing the error. 

[Romell]

Hi...

I have a question...in this example how can I add the object called "readerRail" to a new layer and after that to a RadMap control?

Thanks

[Dinko | Tech Support Engineer]

Hi ,

You can create a new InformationLayer in code behind and set its Reader property to the "readerRail" object of type SqlGeospatialDataReader(). Then you can add the InformationLayer to the Items collection of your map.

public MainWindow()
{
    InitializeComponent();
    var readerRail = new Telerik.Windows.Controls.Map.SqlGeospatialDataReader();
    var infLayer = new InformationLayer();
    infLayer.Reader = readerRail;
    this.myMap.Items.Add(infLayer);
}

In addition, you can take a look at the SQL Geospatial Data help article in our documentation where the SqlGeospatialDataReader object is further described.

Regards,
Dinko
Telerik by Progress