nice work!

Yes, it does require SP3. I built it with those assemblies. You should be able to crack open the code and change all the references back to an earlier version and rebuild, but it is likely easier just to apply SP3.

Where is GridResults_Display.js

I don't see it in the source?

This is a nice tool. Can you tell me how we can link this up to the identify tool and use it for that as well?

add in line 31 of display_mapidentify.js fpBody.innerHTML = ""; So the taskresult will refresh before a new identify. The identify is great. Thanks. But it works only for one resource... Can someone help me to make it working by more resources?

Any chance that anyone has modified Bryan Baker's PrintTask to work with this GridResults?

The "Hyperlinking in task results" blog from July shows an example (in C++ though I'm using VB) of how to override the ExecuteTask method to create a hyperlink in the results.  Can this be done with the GridResults Control also?

mika, Sorry I only wrote the code in C#. The control will work with C# and VB.NET code but you can only modify the control using C#. Perhaps an online utility like the following would help. http://labs.developerfusion.co.uk/convert/csharp-to-vb.aspx

Gabriela, You are getting this message because the GridResults control is not a type of TaskResults, it is an implementation of ITaskResultsContainer. TaskResults is a separate implementation of ITaskResultsContainer. The GridResults control does not extend the TaskResults like Rex and my post for the ZoomToResults control http://blogs.esri.com/Dev/blogs/arcgisserver/archive/2007/08/28/Automatically-zooming-to-task-results.aspx. All of the standard tasks interact with the results control via the ITaskResultsContainer interface so both controls should work fine for all out-of-the-box ADF tasks controls. The identify tool is a little different in that it looks for a TaskResults type which is what lead to my response above on October 30th. Custom tasks may also be looking for a TaskResults type but these should be easy to change to ITaskResultsContainer.

Michael,

Yes it looks like my code doesn't do sorting well when there are multiple table results.  Currently the control just tracks column and sort order but it should store a collection of objects with info for how each table should be sorted.  I'm not sure if I will have time to fix this but if you want to tackle it yourself RefreshGrid in gridresults.cs is a good place to start.  If I get a chance to fix it, I'll repost.

I get an error "An unhandled exception has occurred: Object reference not set to an instance of an object" when I try to zoom or pan to any of the results in the table. Everything else works great. Any help would be great. Thanks

Is it possible to use this with the Common Select and Buffer Tool?

You need to add the table to a Dataset, then send the dataset to the DisplayResults function of ITaskResultsContainer. Here is the code:

     System.Data.DataTable datatable = qfunc.Query(null, lids[layer_index], queryfilter);
        DataSet ds = new DataSet();
        ITaskResultsContainer tskRC = GridResults1;

        if (datatable.Rows.Count > 0)
        {
            ds.Tables.Add(datatable);
            tskRC.DisplayResults(null, null, null, ds);
        }
        else
        {
            string heading = "No results found";
            string detail = "No results found";
            SimpleTaskResult str = new SimpleTaskResult(heading, detail);
            tskRC.DisplayResults(null, null, null, str);
        }

TToutant,

You can limit the number of fields a couple of ways. If you're not coding, use the mxd by going into the layer properties and choosing the fields that should be visible. Or, using .NET you can list the fields you'd like to return:

string list = "Field1,Field2,Field3";

       String[] flds = list.Split(',');

       ESRI.ArcGIS.ADF.StringCollection scoll = new ESRI.ArcGIS.ADF.StringCollection(flds);

       queryfilter.SubFields = scoll;

You need to add the table to a Dataset, then send the dataset to the DisplayResults function of ITaskResultsContainer. Here is the code:

    System.Data.DataTable datatable = qfunc.Query(null, lids[layer_index], queryfilter);

       DataSet ds = new DataSet();

       ITaskResultsContainer tskRC = GridResults1;

       if (datatable.Rows.Count > 0)

       {

           ds.Tables.Add(datatable);

           tskRC.DisplayResults(null, null, null, ds);

       }

       else

       {

           string heading = "No results found";

           string detail = "No results found";

           SimpleTaskResult str = new SimpleTaskResult(heading, detail);

           tskRC.DisplayResults(null, null, null, str);

       }

I'm trying to use this code to display the dataset to the gridviewResults but getting the following error.

No parameterless constructor defined for this object.

It works fine with the identify tool but doesn't work for the query.

Has anyone tried to combine this with the Custom Select Tool Task (http://arcscripts.esri.com/details.asp?dbid=15133)? I am trying to incorporate this now, but it doesn't like it when it get to the GetTaskResultsControls function.

Nipa,

Which object is your error refering to?

What I'm trying to do is run a Query by selecting parameters from the drop down list and then I would like to display that results in gridresults as a table. When I try to use the below code I'm getting error in DisplayResults line. No parameterless constructor defined for this object. I was able to get this to work for Identify tool but I like to do the same thing from the seperate query that I'm building. Any ideas? Nipa Parikh

How can I see in gridresults domain values?

I got this application to work with Identify tool. When the user clicks on checkbox that feature displays on the map. I've a seperate button that should read the values of each checkbox. How do I do that? How can I read the gridresults checkbox values so see which one is turned on or off. Nipa Parikh

I'd like to have the table launch in a new popup window - is this possible?

Tom, On postback the results of my gridView WebControl are lost whereas if the results are contained within a Task Results WebControl they persist across the postback. What am I missing?

How would I go about adding the zoom and/or select tools to an ASP .Net Gridview? I need the flexibility of a standard Gridview (hyperlinks, template fields, nested gridviews) with the functionality of zooming to and/or selecting records like you have in this GridResults control. Any guidance would be appreciated.

Also, is there an easy way to make the selected column a radiobutton? I tried modifying the gridViewCheckBoxTemplate to use a radiobutton instead of a checkbox, but I can still select many of the results. I made sure the radiobuttons were using the same groupname too.

My goal here is to have only one result selected at any given moment.

Any ideas?

I got the following error while running a coded ? tskRC.DisplayResults(Nothing, Nothing, Nothing, ds) Can someone help me? Exception occurred: The given key was not present in the dictionary

i too am trying to get the Custom Select Tool Task (http://arcscripts.esri.com/details.asp?dbid=15133) to work with gridResult. works fine in taskresult. i get a callback error but more specifically this seems to be the problem... "unable to cast object of type esri.sample.gridResult to type ESRI.ArcGIS.ADF.UI.WebControls.TaskResults" any help would be appreciated. thanks

Several of you have asked about using the GridResults with a tool on a toolbar (not a task). As has already been mentioned, you need to call DisplayResults on the ITaskResultsContainer interface and pass in a DataSet with the results you want displayed.  The trick is that you need to get a reference to the GridResults control from the tool.  To do this there is a FindControl function in the Utils static class.  Then after you've called DisplayResults you need to send the callbacks generated by the GridResults back to the client using the map control.  Below is some sample code.  In this code "ds" is the dataset with my results.

//Get the GridResults from the page

       esri_samples.gridResults gResults = esri_samples.Utils.FindControl<esri_samples.gridResults>(pMap.Page, "GridResults1");

       ITaskResultsContainer pTaskRes = gResults as ITaskResultsContainer;

       //Start the activity indicator to get the floating panel to expand.

       pTaskRes.StartTaskActivityIndicator(null, "");

       //Send the dataset to the DisplayResults method

       pTaskRes.DisplayResults(null, "", null, ds);

       //Add the callbacks of the GridResults to the callback of the map (referenced by pMap).

       //since all tools are processed through the map control, the map control

       //itself is in a callback and will take care of updating the grid for us.

       pMap.CallbackResults.CopyFrom(pTaskRes.CallbackResults);

       //Clear the callbacks in the grid so they don't get sent twice

       pTaskRes.CallbackResults.Clear();

I hope this helps.  Happy coding!

Okay, changing the html tag from esri.arcgis.adf.web.ui.webcontrols.buddycontrol to esri:buddycontrol worked. But that was auto populated when I chose the control as the task container. Thanks for the code snip to limit the return fields, worked like a charm.

I want to implement same technology in JAVA If anybody has Java so;ution for this scenerio, Please provide the same.

Thanks

Tom, I had a quick question regarding the GridResults control. When I buddy up a QueryAttributesTask with GridResults1 (for example) the results are returned. However, if I pan or zoom I get the error that Aaron & Rocky from above got "An unhandled exception has occurred: Object reference not set to an instance of an object". But if I use the SearchAttributesTask the zoom and pan work great. FYI - I am on sp3. Any Ideas. Thanks! JB

FYI, who ever has been getting the zoom/pan errors with this control--one thing that worked for me: Make sure your shape field is not hidden in your MXD.

Dim ds As New DataSet()

           Dim gResults As esri_samples.gridResults = esri_samples.Utils.FindControl(Of esri_samples.gridResults)(Map1.Page, "GridResults1")

           Dim pTaskRes As ITaskResultsContainer = TryCast(gResults, ITaskResultsContainer)

 If datatable.Rows.Count > 0 Then

               ds.Tables.Add(datatable)

               '    'Me.GridResults1.FindControl("GridView1")

               pTaskRes.DisplayResults(Nothing, "", Nothing, ds)

           Else

               Dim heading As String = "No results found"

               Dim detail As String = "No results found"

               Dim str As New SimpleTaskResult(heading, detail)

               pTaskRes.DisplayResults(Nothing, "", Nothing, str)

           End If

When I tried the above code I'm getting the following error.

No parameterless constructor defined for this object.

Any help is appreciated.

Thanks.

Hi Nipa,

I was able rectify the issue of no parameterless query...  the grid view control takes input as graphic dataset and in your code you are sending the system.data.dataset..so it throws an error..

please check the code below which i am using it.. it does not throw any error.

Dim datatable As System.Data.DataTable = qfunc.Query(Nothing, lids(layer_index), spatialfilter)

                   Dim graphicslayer As ESRI.ArcGIS.ADF.Web.Display.Graphics.GraphicsLayer = ESRI.ArcGIS.ADF.Web.Converter.ToGraphicsLayer(datatable, System.Drawing.Color.Yellow, System.Drawing.Color.Yellow)

                   Dim selresource As ESRI.ArcGIS.ADF.Web.DataSources.Graphics.MapResource = Nothing

                   For Each gfunc In gfc

                       If gfunc.Resource.Name = "Selection" Then

                           selresource = CType(gfunc.Resource, ESRI.ArcGIS.ADF.Web.DataSources.Graphics.MapResource)

                           selresource.Graphics.Tables.Clear()

                       End If

                   Next

                   If selresource Is Nothing Then

                       Return "Nothing"

                   End If

                   'selresource.Graphics.Tables.Add(graphicslayer)                    '''''''

                   Dim gds As New ESRI.ArcGIS.ADF.Web.Display.Graphics.GraphicsDataSet

                   Dim gResults As esri_samples.gridResults = esri_samples.Utils.FindControl(Of esri_samples.gridResults)(m_page, "GridResults1")

                   Dim pTaskRes As ITaskResultsContainer = TryCast(gResults, ITaskResultsContainer)

                   If datatable.Rows.Count > 0 Then

                       'ds.Tables.Add(datatable)

                       gds.Tables.Add(graphicslayer)

                       pTaskRes.DisplayResults(Nothing, "", Nothing, gds)

                       selresource.Graphics = gds

                   Else

                       Dim heading As String = "No results found"

                       Dim detail As String = "No results found"

                       Dim str As New SimpleTaskResult(heading, detail)

                       pTaskRes.DisplayResults(Nothing, "", Nothing, str)

                       pTaskRes.Refresh()

                   End If

But I have a issue..after this the Grid results are not displayed.. the Results pnale does not refresh..can anyone help

Hi Surender,

  Thanks for your code but I'm having the same issue of not displaying Gridresults.  Please let me know if you find any solution.

Thanks.

Nipa

Hi Surender, Map1 is my map control name and I added Could you please more about "Return Map1.CallbackResults.ToString()" Where the returned string goes? I tried to put it into the function involved after clicking a button. But the gridresults is still not displayed. Thanks! Nipa

Hi Nipa, There two call back statements for refreshing the grid once the spatial query is completed (i.e the data is added to datatable..please make sure datatable.rows.count is greater than zero) the two call back statemetns are 1. pTaskRes.StartTaskActivityIndicator(Nothing, "") this will start the Indicator Gif in grid control. 2.pTaskRes.DisplayResults(Nothing, "", Nothing, gds)..this will add the data to grid control these two should be in this if loop If datatable.Rows.Count > 0 Then here.... else endif after if loop use objmapselection.CallbackResults.CopyFrom(pTaskRes.CallbackResults) pTaskRes.CallbackResults.Clear() Return objmapselection.CallbackResults.ToString() This should work..

Hi Nipa, Please find the code for Polygon Search and place the results to Grid view.. Note: My GridView control is in "TableResuls" Panel and Grid Control name is "GridRwesult1" Code below: Dim gResults As esri_samples.gridResults = esri_samples.Utils.FindControl(Of esri_samples.gridResults)(m_page, "GridResults1") Dim pTaskRes As ITaskResultsContainer = TryCast(gResults, ITaskResultsContainer) If eventArg = "polygon" Then Dim ims_map_points As Object = Session("ims_map_points") Dim ring As ESRI.ArcGIS.ADF.Web.Geometry.Ring = New ESRI.ArcGIS.ADF.Web.Geometry.Ring() Dim mappoly As ESRI.ArcGIS.ADF.Web.Geometry.Polygon = New ESRI.ArcGIS.ADF.Web.Geometry.Polygon() Dim rings As ESRI.ArcGIS.ADF.Web.Geometry.RingCollection = New ESRI.ArcGIS.ADF.Web.Geometry.RingCollection() Dim mf As ESRI.ArcGIS.ADF.Web.DataSources.IMapFunctionality = Nothing Dim gisresource As ESRI.ArcGIS.ADF.Web.DataSources.IGISResource = Nothing Dim qfunc As ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality = Nothing Dim graphicslayer As ESRI.ArcGIS.ADF.Web.Display.Graphics.FeatureGraphicsLayer = Nothing Dim gds As New ESRI.ArcGIS.ADF.Web.Display.Graphics.GraphicsDataSet Dim spatialfilter As ESRI.ArcGIS.ADF.Web.SpatialFilter = Nothing Dim datatable As System.Data.DataTable = Nothing Dim heading As String = "No results found" Dim detail As String = "No results found" Dim lids() As String = Nothing Dim lnames() As String = Nothing Dim mapResItemval As Integer Dim layer_index As Integer = 0 Dim layerCount As Integer ring.Points = ims_map_points rings.Add(ring) mappoly.Rings = rings For mapResItemval = 0 To objmapselection.MapResourceManagerInstance.ResourceItems.Count - 1 If objmapselection.MapResourceManagerInstance.ResourceItems(mapResItemval).Name = ConfigurationManager.AppSettings("MapResourceItemName") Then mf = CType(objmapselection.GetFunctionality(mapResItemval), _ ESRI.ArcGIS.ADF.Web.DataSources.IMapFunctionality) End If Next ' end of for loop gisresource = mf.Resource qfunc = CType(gisresource.CreateFunctionality(GetType(ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality), Nothing), ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality) qfunc.GetQueryableLayers(Nothing, lids, lnames) For layerCount = 0 To lnames.Length - 1 Step layerCount + 1 If lnames(layerCount) = HttpContext.Current.Session("ActiveLayerName") Then 'targetlayername Then layer_index = layerCount Exit For End If Next spatialfilter = New ESRI.ArcGIS.ADF.Web.SpatialFilter() spatialfilter.ReturnADFGeometries = True spatialfilter.MaxRecords = 500 spatialfilter.Geometry = mappoly spatialfilter.SearchOrder = SearchOrder.Spatial datatable = qfunc.Query(Nothing, lids(layer_index), spatialfilter) graphicslayer = ESRI.ArcGIS.ADF.Web.Converter.ToGraphicsLayer(datatable, Drawing.Color.Cyan, Drawing.Color.Cyan) // gds.DataSetName = [String].Format("{0} - {1} ({2})", "Selection", graphicslayer.TableName, datatable.Rows.Count) pTaskRes.CallbackResults.Clear() If datatable.Rows.Count > 0 Then gds.Tables.Add(graphicslayer) pTaskRes.StartTaskActivityIndicator(Nothing, "") pTaskRes.DisplayResults(Nothing, "", Nothing, gds) Else Dim str As New SimpleTaskResult(heading, detail) pTaskRes.StartTaskActivityIndicator(Nothing, "") pTaskRes.DisplayResults(Nothing, "", Nothing, str) End If gds.Clear() spatialfilter = Nothing qfunc = Nothing End If objmapselection.CallbackResults.CopyFrom(pTaskRes.CallbackResults) pTaskRes.CallbackResults.Clear() Return objmapselection.CallbackResults.ToString() Hope this will help to fix your errror Regards, Surender rao k

Hi Surender, Thanks for your code but I've pasted my function that I'm calling from a button pressed. I'm really confused and can definately use your help to figure out why the gridresults is not showing. Please give me some guidance. Thanks. CODE: Public Function SelectFeatures() Dim WhereClauseString As String = "" Dim EmulsionString As String = "" Dim sensorTypeString As String = "" Dim o As ListItem Dim resource_index As Integer = 2 'Index of resource in MapResourceManager Dim targetlayername = "Photo Footprints" Dim mf As ESRI.ArcGIS.ADF.Web.DataSources.IMapFunctionality = CType(Map1.GetFunctionality(resource_index), ESRI.ArcGIS.ADF.Web.DataSources.IMapFunctionality) Dim gisresource As ESRI.ArcGIS.ADF.Web.DataSources.IGISResource = mf.Resource Dim supported As Boolean = gisresource.SupportsFunctionality(GetType(ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality)) If supported Then Dim qfunc As ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality = CType(gisresource.CreateFunctionality(GetType(ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality), Nothing), ESRI.ArcGIS.ADF.Web.DataSources.IQueryFunctionality) Dim lids() As Object = Nothing Dim lnames() As String = Nothing qfunc.GetQueryableLayers(Nothing, lids, lnames) Dim layer_index As Integer = 0 Dim i As Integer For i = 0 To lnames.Length - 1 If lnames(i) = targetlayername Then layer_index = i Exit For End If Next i Dim adfEnvelope As ESRI.ArcGIS.ADF.Web.Geometry.Envelope adfEnvelope = Map1.Extent Dim spatialfilter As New ESRI.ArcGIS.ADF.Web.SpatialFilter() spatialfilter.ReturnADFGeometries = True spatialfilter.Geometry = adfEnvelope spatialfilter.MaxRecords = 1000 WhereClauseString = "STATE=" & "'" & Me.state.SelectedValue & "' and (" WhereClauseString &= "year(exposedate) between " & Me.ExposeDateFrom.SelectedValue & " and " & Me.ExposeDateTo.SelectedValue & ")" For Each o In emulsion.Items If o.Selected = True Then EmulsionString &= "Emulsion=" & "'" & o.Value & "' OR " End If Next If EmulsionString.Length > 0 Then WhereClauseString &= " and (" & Left(EmulsionString, EmulsionString.Length - 4) & ")" End If For Each o In sensortype.Items If o.Selected = True Then sensorTypeString &= CommonFunctions.getCameraList(o.Value) End If Next If sensorTypeString.Length > 0 Then WhereClauseString &= " and (" & Left(sensorTypeString, sensorTypeString.Length - 4) & ")" End If 'for Debugging purpose only WhereClauseString = "STATE='FL' and (year(exposedate) between 2006 and 2006) and (Emulsion='11' OR Emulsion='1') and (sensortype='1' OR sensortype='2' OR sensortype='3' OR sensortype='4' OR sensortype='5' OR sensortype='6' OR sensortype='7' OR sensortype='8' OR sensortype='9' OR sensortype='10' OR sensortype='11' OR sensortype='12' OR sensortype='13' OR sensortype='14' OR sensortype='15' OR sensortype='16' OR sensortype='17' OR sensortype='18' OR sensortype='19' OR sensortype='20' OR sensortype='21' OR sensortype='22')" spatialfilter.WhereClause = WhereClauseString 'spatialfilter.WhereClause = "State='FL'" Dim flds As String() = qfunc.GetFields(Nothing, lids(layer_index)) Dim scoll As New ESRI.ArcGIS.ADF.StringCollection(flds) spatialfilter.SubFields = scoll Dim datatable As System.Data.DataTable = qfunc.Query(Nothing, lids(layer_index), spatialfilter) Dim gfc As IEnumerable = Map1.GetFunctionalities() Dim gResource As ESRI.ArcGIS.ADF.Web.DataSources.Graphics.MapResource = Nothing Dim gfunc As IGISFunctionality For Each gfunc In gfc '***Exercise 5 Step 3.a: Get the GraphicsLayer Resource by name If gfunc.Resource.Name = "Selection" Then gResource = CType(gfunc.Resource, ESRI.ArcGIS.ADF.Web.DataSources.Graphics.MapResource) End If Next gfunc If gResource Is Nothing Then Exit Function End If Dim glayer As ESRI.ArcGIS.ADF.Web.Display.Graphics.ElementGraphicsLayer = Nothing Dim dt As System.Data.DataTable For Each dt In gResource.Graphics.Tables If TypeOf dt Is ESRI.ArcGIS.ADF.Web.Display.Graphics.ElementGraphicsLayer Then glayer = CType(dt, ESRI.ArcGIS.ADF.Web.Display.Graphics.ElementGraphicsLayer) Exit For End If Next dt If glayer Is Nothing Then '***Exercise 5 Step 3.b: Create a new ElementGraphicsLayer glayer = New ESRI.ArcGIS.ADF.Web.Display.Graphics.ElementGraphicsLayer() '***Exercise 5 Step 3.c: Add the GraphicsLayer to the GraphicsDataSet gResource.Graphics.Tables.Add(glayer) End If glayer.Clear() Dim drs As DataRowCollection = datatable.Rows Dim shpind As Integer = -1 'Dim i As Integer For i = 0 To datatable.Columns.Count - 1 If datatable.Columns(i).DataType Is GetType(ESRI.ArcGIS.ADF.Web.Geometry.Geometry) Then shpind = i Exit For End If Next i Try Dim dr As DataRow For Each dr In drs Dim geom As ESRI.ArcGIS.ADF.Web.Geometry.Geometry = CType(dr(shpind), ESRI.ArcGIS.ADF.Web.Geometry.Geometry) '***Exercise 5 Step 3.d: Create a new GraphicElement Dim ge As New ESRI.ArcGIS.ADF.Web.Display.Graphics.GraphicElement(geom, System.Drawing.Color.DarkRed) Dim pSimpleFill As New ESRI.ArcGIS.ADF.Web.Display.Symbol.SimpleFillSymbol pSimpleFill.BoundaryColor = Drawing.Color.DarkRed pSimpleFill.Transparency = 100 ge.Symbol = pSimpleFill '***Exercise 5 Step 3.e: Add the GraphicElement to GraphicsLayer glayer.Add(ge) Next dr Catch ice As InvalidCastException End Try If Map1.ImageBlendingMode = ImageBlendingMode.WebTier Then Map1.Refresh() Else If Map1.ImageBlendingMode = ImageBlendingMode.Browser Then '***Exercise 5 Step 3.f: Refresh the Graphics Resource Map1.RefreshResource(gResource.Name) End If End If 'Dim drow As DataRow If (Not datatable Is Nothing) Then 'For Each drow In drs ' drow("NGS_PHOTOS.NGS_PHOTOS.FLORIDA_FOOTPRINTS.State") = "" & drow("NGS_PHOTOS.NGS_PHOTOS.FLORIDA_FOOTPRINTS.State") & "" 'Next 'GridView1.DataSource = datatable 'Session("datatable") = datatable 'GridView1.DataBind() For Each c As DataColumn In datatable.Columns c.ColumnName = c.ColumnName.Replace("NGS_PHOTOS.NGS_PHOTOS.FLORIDA_FOOTPRINTS.", "") Next Session("datatable") = "" Me.RadGrid1.DataSource = datatable Session("datatable") = datatable ' Me.RadGrid1.DataBind() End If 'This part is not working to copy the resultsset to the gridresults. 'the gridresults is not displayed Dim gds As New DataSet Dim gResults As esri_samples.gridResults = esri_samples.Utils.FindControl(Of esri_samples.gridResults)(Map1.Page, "GridResults1") Dim pTaskRes As ITaskResultsContainer = TryCast(gResults, ITaskResultsContainer) If datatable.Rows.Count > 0 Then Dim layer = ESRI.ArcGIS.ADF.Web.Converter.ToGraphicsLayer(datatable, System.Drawing.Color.Empty, System.Drawing.Color.Black) If Not (layer Is Nothing) Then gds.Tables.Add(layer) pTaskRes.StartTaskActivityIndicator(Nothing, "") pTaskRes.DisplayResults(Nothing, "", Nothing, gds) Else gds.Tables.Add(datatable) End If End If Map1.CallbackResults.CopyFrom(pTaskRes.CallbackResults) pTaskRes.CallbackResults.Clear() End If Return Map1.CallbackResults.ToString() End Function

Hi Surender,

  I was looking at your code and trying to compare with mine and I see two differences.

I'm using dropdown list to build my query and hit a submit button that actually calls the function and then display the result in the grid results.

Can you please tell me how should I have my button_click event display the gridresults.

Map1.CallbackResults.ToString() has the whole gridresults content but just not displaying it.

I can really use some help because I'm stuck and can't move forward.

Nipa

Hi Powell, As requested please find the code for Export to Excel. I have added one more Case called "gridiewExport" in the GridTool Code in c#... this works Great for me. Code below -----------------------------------------

case "gridViewExport":
                    //This is the Export Link above the Grid Resutls and 
                    //below code exports the gridview results to Excel file
		   GridView gv = (GridView)Page.Session["gview"];
                    // this for loop is to hide the Zoom,Pan, Report, Check box fields 
                    // while exporting the excel sheet                    
                    foreach (TemplateField dColumn in gv.Columns)
                     {
                       if (dColumn.HeaderText == "Selected")
                       {   dColumn.Visible = false;
                           break;
                       }
                       dColumn.Visible = false;
                     }                  
                    string strFileName = String.Empty, strFilePath = String.Empty;
                    
                    strFileName = (HttpContext.Current.Session["HttpSessionID"] + "Report.xls");                   
                    strFilePath = HttpContext.Current.Server.MapPath("./ExportData/") + strFileName;
                    if (File.Exists(strFilePath))
                    {
                        File.Delete(strFilePath);
                    }
                    System.IO.StringWriter oStringWriter = new StringWriter();
                    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
                    StreamWriter objStreamWriter;
                   ////string strStyle = @" .text { mso-number-format:\@; }";
                    objStreamWriter = File.AppendText(strFilePath);
                    //Utils.ClearControls();
                   // Utils.PrepareGridViewForExport(gv);                    
                    gv.RenderControl(oHtmlTextWriter);
                    //objStreamWriter.WriteLine(strStyle);
                    objStreamWriter.WriteLine(oStringWriter.ToString());
                    objStreamWriter.Close();
                    
                    string strScript = "window.open('./ExportData/" + strFileName + "','Export');";                 
                    CallbackResults.Add(new CallbackResult(Parent, "javascript", strScript));                   
                    break;

Hi I have trouble using this control. To me it displays result in gridview but when I click zoomto selected feature it zooms to full extent. Anybody knows why it is happening.

Hallom LParson, look in the gridResults.cs file, line 590-593 look like this: if (dc.ColumnName != pGl.GraphicsIDColumn.ColumnName && dc.ColumnName.ToUpper() != "IS_SELECTED" && dc.ColumnName.ToUpper() != "SHAPE" && dc.ColumnName != c_sTableIdColumnName) here the colums "IS_SELECTED" and "SHAPE" are set to unvisible. Add your columns there to hide them. Does nobody knows how to solve the scroll problem? Bye