topic Re: Query from mutliple Field in ArcGIS API for Silverlight Questions

Query from mutliple Field

MuhammadWaqar_ul_islam — Thu, 03 Mar 2011 05:37:27 GMT

I Want to query the DATA in different feilds of a layer
exmaple
feild1; Address = 'F.B.Area' or
feild2; Block = 'BLOCK 4' or
Feild3; Name = 'Waqar'

This Query Structure is in Arcgis server application for Query the Data

i need code for Query the data using different operation "and', "or" from different feild

thanks

Re: Query from mutliple Field

JenniferNery — Thu, 03 Mar 2011 18:04:55 GMT

You can update the Where property http://help.arcgis.com/en/webapi/silverlight/apiref/ESRI.ArcGIS.Client~ESRI.ArcGIS.Client.Tasks.Query~Where.html

It can be any number for condition like:
query.Where = "SUB_REGION = 'Pacific' or STATE_ABBR like 'A%' and POP2007 < 1000000"

You can try the query above on this service:
http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Demographics/ESRI_Census_USA/MapServer/5

Re: Query from mutliple Field

MuhammadWaqar_ul_islam — Fri, 04 Mar 2011 09:45:56 GMT

Thanks jenefer
thats Work
One more thing to ask
I have a textbox for input value and i want to used it in the query below but no result occurs
query.Where = "FEILD1 like '%Textbox1.Text%' and FEILD2='TOWN BORDER STATION'"

i have done Serval Method like that
no result appers
query.Wo reshere = string.Format("Field1 = 'Textbox1.Text' and Field2 'Textbox2.Text'");

q.Where = "FEILD1 = '" & Textbox1.Text.Trim() & "' AND
FEILD2 = '" & Textbox2.Text.Trim() & "'"

it gives error on & operator

i m working on C#

How textbox values will be used in the query.where

Re: Query from mutliple Field

JenniferNery — Fri, 04 Mar 2011 16:15:50 GMT

You can use string.Format() http://msdn.microsoft.com/en-us/library/system.string.format(v=VS.95).aspx

query.Where = string.Format("FEILD1 like '%{0}%' and FEILD2='TOWN BORDER STATION'", Textbox1.Text.Trim());

Re: Query from mutliple Field

MuhammadWaqar_ul_islam — Mon, 07 Mar 2011 03:39:33 GMT

thanks jenniferdnery
its working

Another thing to ask
i have selected record from query that appers in DATAGRID
i want to used FeatureDataGRID instead of DATAGRID (is this possible)?
if not
then how selected DATGRID value zoom to feature (on click event)
required code C#
thanks
regards
Waqar

Re: Query from mutliple Field

JenniferNery — Mon, 07 Mar 2011 14:04:10 GMT

If you return query results to a GraphicsLayer, you can use this GraphicsLayer to set FeatureDataGrid.GraphicsLayer property. Very similar to this sample except you will be using the GraphicsLayer that contain your query results. http://help.arcgis.com/en/webapi/silverlight/samples/start.htm#ToolkitFeatureDataGrid

If your DataGrid contain GraphicCollection as its ItemsSource, you can use SelectionChanged event to get the selected row (which is a graphic) and call Map.ZoomTo(graphic.Geometry).