User Profile & Activity

Mike Dearman Member
Page
of 3

Thanks Niven.

The grid really needs to have a LayoutSet or GridTable property controlling whether to automatically remove hidden columns from the GrouppedColumns and FilteredColumns collections.

I cannot go back and re-query the database based on the user using the filter row.  Additionally, I can't obviously group in SQL and then display a hidden column groupped in the grid with this issue.

 

Mike

Very strange.  Are you using Windows 7 64 bit with IIS7 and .NET 3.5?  That is my development environment.   You're not launching the sample from within Visual Studio with Development Server are you?  When I launch that way, the sample does work.

I have those HTTP handlers listed in both system.web and system.webServer sections.  IIS7 does require them to be in the system.webServer section.   I just have it in system.web too for IIS6 compatibility.

I will push the code onto one of our application servers running Windows 2008 with IIS 7.5 and see if the problem exists there too.

 

It really feels like a permission issue because of the "'WebDev.WebServer.EXE' (Managed): Loaded 'C:\Users\miked\AppData\Local\Temp\{85c02c6d-73d3-438c-a622-6f46d42eec70}\Xceed.Chart.GraphicsGL.dll'" loading message when debugging from the Development Server, not IIS.

I did just grab that DLL and tried to place it into my application's bin folder.  It looks it may be a 32bit only DLL.  I get the following message when I start my application:

Server Error in '/sys7' Application.
--------------------------------------------------------------------------------
Could not load file or assembly 'Xceed.Chart.GraphicsGL' or one of its dependencies. An attempt was made to load a program with an incorrect format.

 

Does it have a problem with a 64bit application pool?  That would explain why DevServer runs (it runs in 32bit mode I think)

Mike

I have attached your sample, but built it as a Web Application Project connected to an IIS virtual directory (not the ASP.NET Dev Server).  I am using Windows 7 running IIS 7, which may make the difference.  The attached sample runs through the VS Development Server, but not IIS, which leads me to believe its either an IIS 7 issue or a strict permission issue between NETWORK SERVICE and my local account.

Steps to reproduce:

  1. Copy sample somewhere
  2. Create virtual directory in IIS for sample
  3. Run sample (either through VS or standalone) after modifying the virtual directory you use (mine is located at http://localhost/TestChartingPrj).
  4. View chart
  5. Drag OrderID column into Data series
  6. Change chart type to Basic 3D Pie or any other 3D chart.
  7. You should see the grid error window with the DLL error.

Looking in .NET Reflector, the ISNET.WebGrid.ISChartEngine does have dependencies/references to 2 Xceed DLLs (GraphicsCore and Utilities).

Mike

From above, I am using WebGrid version 7.0.7200.404 which is the latest patch I see is available through the Update Manager.

Does the chart dynamically compile/write the GraphicsGL DLL to the temp directory?

Thanks,

Mike

Well, the sample works to show 3d charts somehow.  I've been looking for differences between the sample and my project and I'm not seeing any so far.  I know the sample is using the WebSiteProject and mine is the Web Application Project style in Visual Studio, but both have the WebGrid/Chart DLLs in the bin folder.  They seem to have the same DLL versions (but different file dates 7/22 in the sample and 7/26 in my DLLs).

I debugged both applications, I see the assembly binding call that's different, but don't know why its different.

 

Sample App:

'WebDev.WebServer.EXE' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\WebGrid.Charting.Web\6.0.7200.100__3e60b85fb8502d5e\WebGrid.Charting.Web.dll'
'WebDev.WebServer.EXE' (Managed): Loaded 'Xceed.Chart.GraphicsCore'
'WebDev.WebServer.EXE' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\WebGrid.Charting.Kernel\6.0.7200.100__3e60b85fb8502d5e\WebGrid.Charting.Kernel.dll'
'WebDev.WebServer.EXE' (Managed): Loaded 'Xceed.Chart.Utilities'
'WebDev.WebServer.EXE' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\WebGrid.Charting.Common\6.0.7200.100__3e60b85fb8502d5e\WebGrid.Charting.Common.dll'
'WebDev.WebServer.EXE' (Managed): Loaded 'Xceed.Chart.Graphics2D'
'WebDev.WebServer.EXE' (Managed): Loaded 'C:\Users\miked\AppData\Local\Temp\{85c02c6d-73d3-438c-a622-6f46d42eec70}\Xceed.Chart.GraphicsGL.dll'

 

My Application:

'w3wp.exe' (Managed): Loaded 'Xceed.Chart.GraphicsCore'
'w3wp.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\WebGrid.Charting.Web\6.0.7200.100__3e60b85fb8502d5e\WebGrid.Charting.Web.dll'
'w3wp.exe' (Managed): Loaded 'Xceed.Chart.Utilities'
'w3wp.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\WebGrid.Charting.Kernel\6.0.7200.100__3e60b85fb8502d5e\WebGrid.Charting.Kernel.dll'
'w3wp.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\WebGrid.Charting.Common\6.0.7200.100__3e60b85fb8502d5e\WebGrid.Charting.Common.dll'
'w3wp.exe' (Managed): Loaded 'Xceed.Chart.Graphics2D'
A first chance exception of type 'System.Web.HttpException' occurred in System.Web.dll
A first chance exception of type 'System.Web.HttpException' occurred in System.Web.dll
A first chance exception of type 'System.Web.HttpException' occurred in System.Web.dll

 

No binding after the Graphics2D to the GraphicsGL in my application.  I see the DLL is being stored (dynamically copied) into 'C:\Users\miked\AppData\Local\Temp\{85c02c6d-73d3-438c-a622-6f46d42eec70}" which is strange.

I'm wondering if its a permission issue because the sample is running under WebDev.WebServer.EXE and is running under my credentials as Full Trust.  But my application is running through IIS under the NETWORK SERVICE credentials, which isn't Full Trust.

Any ideas?

Mike

Thank you very much - I have confirmed this works now in both the FilterRow and NewRow.

Mike

Yup, that's what I figured.  I have submitted this in Developer Network, Product Feedback as a feature request (aka. the black hole :-)   Hopefully it will get reviewed and resolved along with the other requests I need from there.

Thanks,

Mike

Thank you Handy.

I am already using that method to customize part of what I need, but it can't handle all of it.

In the row/column/export context menu events, I update the WebContextMenu.ClientSideEvents properties to attach to the ShowMenu, Select and Click events.   It works very well.  I just need the OnFilterContextMenu event so I can do the same for the filter menu too - without it, nothing lets me know the filter menu just opened.

Mike

Any update on the fix for this?

Thanks.  Do you know when the permanent fix will be available?  The users need to be able to ungroup.

All times are GMT -5. The time now is 10:58 PM.
Previous Next