Hello-  I know all the developers get busy but I really need to know how and where to add code to this application that will "Total" the Shape_Length field and display it in a label..

Thanks for any help...

Regards,

All,

I fixed a problem with the gridResults control where sorting didn't work right when there are multiple results.  This problem is most evident  when you use the gridResults control with the identify tool.  This new control is available on ArcScripts here: http://arcscripts.esri.com/details.asp?dbid=15452 .

Hi Tom, thanks for your great work for excellent tool. It helped me a lot. I am integrating your gridResults controls with my custom search task.Every thing is worked fine until I added more than one  search tasks to my application. I added 2 search tasks and 2 gridResults to display the results of each search task in separate gridResults. when I executed the first search task it worked fine and displayed the results in associated gridResults. However when I executed the second search task, it successfully return the result and displayed in the 2nd gridResults, but results in 1st gridResults is replaced with the new results. Basically i want separate results for each search task.

I would be thankful, if someone can help me.

Thanks in advance.

Krishna

                    string tieURL = "";
                    if (table.TableName == "Projects")
                    {
                        tieURL = "<a href="http://mywebpage/basic.aspx?selProjectID=%22" table.rows[0][="" project="" id="" ]="" +="" target="_blank">" + table.Rows[0]["Project ID"] + "</a>";
                        table.Rows[0]["Project ID"] = tieURL;
                    }

Tom Brenneman,

I tried appending the additional case statement to the gridresults.cs file and recompiling a new dll.

However, I get the following error:

Unable to cast object of type 'System.Data.DataColumn' to type 'System.Web.UI.WebControls.TemplateField'

Is there anyway you can send me your edited/updated gridresults.cs file s othat I can use this feature in my web application?

My email is nelsonrj@hotmail.com.

Thank you.

Hi All,

I have implemented the Export 2 Excel and please find the code

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;

Hello,

Can anyone help me with some code on how to write the selected rows from the gridresults to an access or sql table?

Thanks.

Could not load file or assembly 'gridResults, Version=1.3.1.0, Culture=neutral, PublicKeyToken=4117b0729e6ae73a' or one of its dependencies. The system cannot find the file specified

It wants me to make a registry change - but I don't want to do that to all my users?

Surender,

I am unable to use your sample to get the excel export to work.

Is there anyway you can email me your gridresults.cs file (nelsonrj@hotmail.com).

Please let me know.

Thanks.

Josh,

 Here is the code I use to loop thru gridresults gridview and get the value of selected checkbox.  I'm creating a session variable and pass that list to the next page.

I hope this helps.

Function SubsetSelectionFromGridResults()

If Not Me.GridResults1.ResultsGraphicsDataset Is Nothing Then

           Dim recMumView As DataView = GridResults1.ResultsGraphicsDataset.Tables(0).DefaultView

           Dim recNumDataTable As DataTable

           Dim i, j As Integer

           Dim tmp As String = ""

           Dim selected As Boolean

           Dim recNumList As New ArrayList

           Dim SelRecnum As String = ""

           recNumDataTable = recMumView.Table

           For i = 0 To recNumDataTable.Rows.Count - 1

               selected = recNumDataTable.Rows(i)("IS_SELECTED")

If selected = True Then

                   recNumList.Add(recNumDataTable.Rows(i)("RecNum"))

               End If

           Next

           If recNumList.Count > 0 Then

               For j = 0 To recNumList.Count - 1

                   tmp &= recNumList(j).ToString + ","

               Next

           End If

            If tmp.Length >= 2 Then

               SelRecnum = Left(tmp, tmp.Length - 1)

           End If

           Session("SelRecnum") = SelRecnum

           Dim aURL As String = "buildOrderform.aspx"

           Dim returnstring As String

           Dim sw As New System.IO.StringWriter()

           Dim htw As New HtmlTextWriter(sw)

   htw.Flush()

           returnstring = sw.ToString()

           Dim sb As New System.Text.StringBuilder

           sb.Append("OpenWindow=window.open('" + aURL + "', 'CustomPopUp',")

           sb.Append("'width=800, height=800, menubar=yes, resizable=1,scrollbars=1');")

           Dim cr As New CallbackResult(Nothing, Nothing, "javascript", sb.ToString)

           Map1.CallbackResults.Add(cr)

           Dim jsChangeCursor As String = "map.divObject.style.cursor = map.cursor"

           Dim cursorCallbackResult As ESRI.ArcGIS.ADF.Web.UI.WebControls.CallbackResult = New ESRI.ArcGIS.ADF.Web.UI.WebControls.CallbackResult(Nothing, Nothing, "javascript", jsChangeCursor)

           Map1.CallbackResults.Add(cursorCallbackResult)

           Return Map1.CallbackResults.ToString()

       End If

I'm trying to add a bottom panel below the map that will automatically expand when results are posted - similar to the side panel

Anyone able to get the results to display below the map in a panel that can be hidden, similar to the side panel.

Or like Tony asked about having the results show in a new window

I loaded the gridResults project source into my own map viewer project so that I could customize it. I was able to do so and can compile as a new version (1.3.1.1), make changes, etc. and they are reflected in my map viewer.  However to avoid any version conflicts with the version provided in this blog (v1.3.1.0), I uninstalled v1.3.1.0 first and then added v1.3.1.1 to my VS Toolbar. Again, everything in my project works fine.

<br>

However, when I try to start the ArcGIS Manager console (the compiled web app that gets installed w/ ArcGIS Server and which runs on the same dev machine) I get the following exception:

<br><hr><br>

An error has occurred at: http://localhost/ArcGIS/Manager/login.aspx?ReturnUrl=/ArcGIS/Manager/GISServer/Default.aspx.

<br>

Could not load file or assembly 'gridResults, Version=1.3.1.0, Culture=neutral, PublicKeyToken=4117b0729e6ae73a' or one of its dependencies. The system cannot find the file specified.

<br>

For more details, check Manager's web server application event log.

<br><hr><br>

The IIS logs contain no additional information (at least not anything helpful). The Manager app is pre-compiled and contains no references to gridResults in the web.config or anywhere else, so I'm not sure where it's picking up this dependency.

<br>

Has this happened to anyone else?

Aaron:

Here's what I did (I may have the order slightly off since I'm going off of memory but overall it should work for you):

1. Remove the grid from your toolbar: right-click in toolbar and select 'Choose Items...', then uncheck 'gridResults' box in 'Choose Toolbox Items' window

2. Uninstall the version of the control on your dev server using the uninstaller that was laid down when you installed the control, e.g. <INSTALL_ROOT>\GridResultsInstall\Debug\setup.exe (I might have the name wrong since I've already uninstalled and the uninstaller itself was removed, so there might be an uninstall program named something other than 'setup.exe').  BEWARE:  If your dev server also hosts your ArcGIS Manager web app, it may break Manager. This happened to me and I've yet to find a fix (see 'error invoking Manager after modifying gridResults' post immed. above yours).

3. Download the latest (v1.3.1) source from the ArcScripts link above or here:  http://arcscripts.esri.com/details.asp?dbid=15452

4. In Visual Studio in your map viewer project, select 'File > Add > Exiting Project...', browse to your gridResults source and add the project 'gridResults.csproj'.  The 'gridResults' project should appear in Solution Explorer.

5. Compile the project (you can do so either by right-clicking the 'gridResults' and selecting 'Build' or by building your whole project).

6. Add the control to your toolbox using the steps in #1 above and selecting 'Browse', browse to gridResults.dll.  This step may not be necessary since you may not need the control in your toolbox to add it to your project if you've added the gridResults to the same solution where you're using it.

I figured out a quick hyperlink fix for the grid results and thought I'd share. This is a really long thread so I'm not sure if a solution was found yet. I need to wrap all my zoning and land use codes within my parcel layer with links to site to look up the codes:

   // Create hyperlink for parcel data on zoning & land use fields

                   if (dt.TableName == "Parcels")

                   {

                       foreach (DataRow dr in dt.Rows)

                       {

                           foreach (DataColumn dc in dt.Columns)

                           {

                               switch (dc.ToString())

                               {

                                   case "Zoning":

                                       dr[dc] = "<a href=\"http://municipalcodes.lexisnexis.com/codes/sonomaco/ \" onClick=\"window.open(this.href); return false \" title=\"External Link: opens web site in a new browser window. \" target= \"_blank \">" + dr[dc].ToString() + "</a>";

                                       break;

                                   case "Land Use":

                                       dr[dc] = "<a href=\"http://www.sonoma-county.org/prmd/docs/gp/index.htm\" onClick=\"window.open(this.href); return false \" title=\"External Link: opens web site in a new browser window. \" target= \"_blank \">" + dr[dc].ToString() + "</a>";

                                       break;

                                   default:

                                       break;

                               }

                           }

                       }

                   }

I place this in the addResultsGridToPanel method. = )

We're happy to see that many of you are making use of this control. Also, the community that has grown around this thread is impressive. We have no wish to break it up. However, since this thread has grown a little unweildy we would like to ask that you continue discussion of this GridResults control on the ArcGIS Server ESRI User Forums at http://forums.esri.com/Forums.asp?c=158. We suggest that you post your threads about this control in the ArcGIS Server .Net: Web ADF category.

If there's more information about the control that becomes available, we'll post it here. But new comments to this particular post have been disabled.

Thanks and hope to see you on the forums,

-The ArcGIS Server Development Team