Hi Sudheer

Setting DataSource dynamically is supported by the SqlShapeReader and should work. I have built a sample application which loads and unloads geo-data from SQL Server:

In XAML:

 <StackPanel x:Name="LayoutRoot">
 <Button Content="Load" Click="Button_Click" Width="120"/>
 <Button Content="Unload" Click="Button_Click_1" Width="120"/>
 <Map:XamMap x:Name="xamMap">
  <Map:XamMap.Layers>
   <Map:MapLayer LayerName="CountryLayer" Fill="Gray" FillMode="None" >
    <Map:MapLayer.Reader>
     <Map:SqlShapeReader DataMapping="Data=TheGeomDataColumn;Id=gid;Name=STATE_NAME;Caption=STATE_NAME"/>
    </Map:MapLayer.Reader>
   </Map:MapLayer>              
  </Map:XamMap.Layers>
 </Map:XamMap>
</StackPanel>

And in Code behind:

private void Button_Click(object sender, RoutedEventArgs e)
{           
 var connString = "Data Source=localhost; Initial Catalog=spatialTest; Integrated Security=true";
 var countryData = new Service1Client();
 countryData.GetDataCompleted += roadData_GetDataCompleted;
 countryData.GetDataAsync(connString, "SELECT * FROM usa_st");
}

private void Button_Click_1(object sender, RoutedEventArgs e)
 for (int i = xamMap.Layers[0].Elements.Count - 1; i >= 0; i--)
 {
  xamMap.Layers[0].Elements.RemoveAt(i);
 }
}

private void roadData_GetDataCompleted(object sender, GetDataCompletedEventArgs e)
{
 SqlShapeReader sqlReader = xamMap.Layers["CountryLayer"].Reader as SqlShapeReader;
 if (sqlReader != null)
 {
  sqlReader.DataSource = e.Result;
  xamMap.Layers["CountryLayer"].ImportAsync();
 }
}

It might be that there is some issue with data coming from the SQL Server or WCF service. Can you confirm that you are getting data in e.Result (in  the GetDataCompleted method), also is there any information for exceptions in Visual Studio's Output window ?

Could you provide the code for setting "Sample" Layer's DataSource. In your previous sample you are setting dynamically only xamMap.Layers[0], which is the "Region" layer. 

Hi Ivan,

I am able to implement multiple layers if I bind the Data Source to Section layer initially, but my requirement is to bind the DataSource at later stage depending upon the Region that User selected. So initially I am not aware of the Section information to bind. I am able to implement this functionality using Shapefiles, but it is causing problems using GeoSpatialData.

What I want to do is, to create Map Layer initially but need to bind the Data Source dynamically at a later stage.

Thanks,

Sudheer CV.

Hi Sudheer

The code looks fine. Can you load only the "Section" layer ? Just checking, but you are setting the right DataMapping and DataSource for Section' SqlShapeReader and MapLayer's Visibility to "Visible" and not to "Collapsed" ?

Can you provide sample data from the SQL server?

Thanks.

Ivan Kotev

Hi Iwan,

this is my Mark Up. 

<igMap:XamMap Name="xamMap" >

<igMap:XamMap.Layers>

<igMap:MapLayer Name="Region" FillMode="Choropleth" >

<!--ToolTip="{}{Name}"-->

<igMap:MapLayer.Reader>

<igMap:SqlShapeReader DataMapping="Data=SpatialData;Name=ShapeID;Caption=ShapeID;Value=ShapeID;"></igMap:SqlShapeReader>

</igMap:MapLayer.Reader>

</igMap:MapLayer>

<igMap:MapLayer Name="Section" FillMode="Choropleth" Fill="Transparent" Visibility="Collapsed" VisibleFromScale="6" VisibleToScale="15">

<igMap:MapLayer.Reader>

<igMap:SqlShapeReader ></igMap:SqlShapeReader>

</igMap:MapLayer.Reader>

</igMap:MapLayer>

</igMap:XamMap.Layers>

</igMap:XamMap>

here is my code.

public partial class MultiLayers_GeoSpatial : UserControl

{

InfragisticsServiceClient svc = new InfragisticsServiceClient();

string connString = "Data Source=IRSDSK068\\SQLEXPRESS;Initial Catalog=GeoSpatialData;uid=igtest;pwd=igtest;";

public MultiLayers_GeoSpatial()

{

InitializeComponent();

svc.GetDataCompleted += new EventHandler<GetDataCompletedEventArgs>(svc_GetDataCompleted);

svc.GetDataAsync(connString, "select ShapeID,SpatialData from tblSpatialData_US where shapeid<19");

}

void svc_GetDataCompleted(object sender, GetDataCompletedEventArgs e)

{

SqlShapeReader reader = xamMap.Layers[0].Reader as SqlShapeReader;

reader.DataSource = e.Result;

xamMap.Layers[0].ImportAsync();

}

 It is working good without "Section" layer.

I am using Sql Server as GeoSpatial Data with Geography data type.

Hi Sudheer

Could you provide some sample code so we can investigate this issue? Are you using SQL Server as a GeoSpatial Data Source ?

Best Regards,

Ivan Kotev