topic Re: Binding Query Result To FeatureDataGrid in ArcGIS API for Silverlight Questions

Binding Query Result To FeatureDataGrid

ManojrajTeli — Tue, 26 Jul 2011 08:24:24 GMT

I am trying to bind the query result returned from by query to the FeatureDataGrid but instead of attributes the geometry of the result is getting bound to Feature datagrid.Please suggest the code to bind attributes to FeatureDataGrid.Thank you in advance.

Re: Binding Query Result To FeatureDataGrid

JenniferNery — Sat, 11 Dec 2021 06:24:18 GMT

FeatureDataGrid will display fields that are in your graphic.Attributes. If your FeatureDataGrid.GraphicsLayer contain the results of your query and you have specified query.OutFields, these should be the same fields contained in the FeatureDataGrid.

Your FeatureDataGrid.Map and GraphicsLayer need to be set, similar to this:

        <esri:FeatureDataGrid Grid.Row="2" x:Name="MyDataGrid" 
    Map="{Binding ElementName=MyMap}"
    GraphicsLayer="{Binding ElementName=MyMap, Path=Layers.[MyGraphicsLayerID]}" />

Re: Binding Query Result To FeatureDataGrid

ManojrajTeli — Wed, 27 Jul 2011 03:23:16 GMT

Oh thank you but this is during initialization that i have done already i want the part QueryTask_ExecutionCompleted event.
This is the Piece of Code what i have done.
Void queryTask_ExecuteCompleted(Object sender,ESRI.ArcGIS.Client.Task.QueryEventArgs e)
{
          FeatureSet featureset=e.FeatureSet;
          if(featureset != null && featureSET.Feature.Count>0)
          {
                   MyDataGrid.ItemsSource = featureSet.Features;//Here the attributed I have to bind
                                                                                   //Geometry is getting binded
           }
}
Suggest some way to bind attribute from feature set to FeatureDataGrid

Re: Binding Query Result To FeatureDataGrid

DominiqueBroux — Wed, 27 Jul 2011 10:58:53 GMT

The ItemsSource of your FeatureDataGrid must reference the graphics instance that are inside the layer.
So instead of setting the ItemsSource directly to the result of the query, you have to project the query result in order to get graphics instances in the feature layer (by using the objectID).
There is a sample in this thread : http://forums.arcgis.com/threads/18708-Problem-selecting-features-from-a-Feature-Layer

Re: Binding Query Result To FeatureDataGrid

ManojrajTeli — Thu, 28 Jul 2011 06:55:53 GMT

Can please elaborate ...I am new at this and i tried those codes and not working and i want to show all the fields in feature datagrid depending on records selected by query and result returned...Its urgent.Thanks in advance.

Re: Binding Query Result To FeatureDataGrid

JenniferNery — Thu, 28 Jul 2011 16:55:34 GMT

Actually, you should not be setting FeatureDataGrid.ItemsSource property.

As long as FeatureDataGrid.Map and GraphicsLayer are set. All you have to do in the Query.ExecuteCompleted event handler is add the results to your GraphicsLayer.Graphics.

Re: Binding Query Result To FeatureDataGrid

ManojrajTeli — Fri, 29 Jul 2011 08:42:12 GMT

I am directlly fetching the Featuredatagrid from query on featureservice and i can see geometry,map tip etc columns but i don't know how to bind only features columns from query result.If you have code then please share. thanks its urgent.Thank you in advance.

Re: Binding Query Result To FeatureDataGrid

JenniferNery — Fri, 29 Jul 2011 17:52:19 GMT

Code is in post#2 This is all the Binding you will need for FeatureDataGrid.

This SDK sample shows how you can add results as graphic to your GraphicsLayer (see code-behind QueryTask_ExecuteCompleted):
http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#SpatialQuery

Re: Binding Query Result To FeatureDataGrid

EzequiasRodrigues_da_Rocha — Wed, 27 Mar 2013 21:41:05 GMT

Hi,

Have someone solve the problem of showing the attribute table yet? Actually I do not have fixed attribute columns. I just want to display the attribute table of one layer with all values as I can see in ArcMap, but in my case I want to display using Silverlight.

Here is the code that retrieves the FeatureSelection:

QueryTask queryTask = new QueryTask(url);
queryTask.ExecuteCompleted += new EventHandler<QueryEventArgs>(queryTask_ExecuteCompleted);

Query query = new Query();
query.ReturnGeometry = true;

// Use textbox text as query condition.
query.Where = "1=1";
query.OutFields.Add("*");
queryTask.ExecuteAsync(query);

And the population I was trying to make:

void queryTask_ExecuteCompleted(object sender, QueryEventArgs e)
{
attribWidget.featureDataGrid1.Map = this.MapControl;
attribWidget.featureDataGrid1.ItemsSource = e.FeatureSet.Features;
}

But I have no success neither with DataGrid nor FeatureDataGrid

ps: I don't want to make any previous selection on the map, so I don't need a graphic layer. I just want to display attributes on FeatureDataGrid

Re: Binding Query Result To FeatureDataGrid

EzequiasRodrigues_da_Rocha — Wed, 27 Mar 2013 22:04:47 GMT

Code is in post#2 This is all the Binding you will need for FeatureDataGrid.

This SDK sample shows how you can add results as graphic to your GraphicsLayer (see code-behind QueryTask_ExecuteCompleted):
http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#SpatialQuery

Is it possible to bind without making a spatial selection? I just want to bind the attribute table of my layer.

Any suggestion will be welcomed.

Regards
Ezequias Rocha

Re: Binding Query Result To FeatureDataGrid

PhilipKnight1 — Thu, 04 Apr 2013 12:29:29 GMT

void queryTask_ExecuteCompleted(object sender, QueryEventArgs e)
{
attribWidget.featureDataGrid1.Map = this.MapControl;
attribWidget.featureDataGrid1.ItemsSource = e.FeatureSet.Features;
}

But I have no success neither with DataGrid nor FeatureDataGrid

ps: I don't want to make any previous selection on the map, so I don't need a graphic layer. I just want to display attributes on FeatureDataGrid

Did you add a breakpoint in queryTask_ExecuteCompleted? is e.FeatureSet.Features returning results? If it's not returning anything then there's your problem. But if it is returning some features the problem might have to do with how the FeatureDataGrid is set up. For isntance, if you have AutoGenerateColumns=FALSE, then it might be unable to create the needed collumns and therefore not create any rows (just a guess).

Also, A bit of advice: If it is just not working at all remove/change pieces of the example slowly and test after each one until it breaks so that way you can figure out where it's breaking and what you are doing to break it. Good luck!

Re: Binding Query Result To FeatureDataGrid

EzequiasRodrigues_da_Rocha — Wed, 24 Apr 2013 11:19:55 GMT

I got the solution on this thread.

http://forums.esri.com/Thread.asp?c=93&f=2455&t=283850&g=1#top

Sincerely
Ezequias Rocha

Re: Binding Query Result To FeatureDataGrid

ELIZABETH50 — Fri, 26 Apr 2013 20:39:10 GMT

hi Ezequias, you were able to run the code inside VS2010 Silverlight.