Intersoft Community - WebGrid Enterprise - WebGrid Batch Update

WebGrid Batch Update

acunningham — Fri, 06 Nov 2009 10:29:21 GMT

James,

Thanks for this. I've tried it out on the sample and there is a definite performance improvement.

I can't try it out on my actual application till next week as we've rolled back the controls for this release so I'll confirm if it solve my problem when I upgrade again next week.

Regards,

Adrian.

WebGrid Batch Update

james — Thu, 05 Nov 2009 05:23:53 GMT

Adrian,

Yes, the issue occurred in IE7 as well. The solution can be achieved by assigning all menu styles to external classes. Please find the attached sample for the working menu bar and Grid inside WebPaneManager.

Note: Please pay attention on the styles definition under <MenuStyleSettings> in the WebMenuBar control. Then take a look at the MenuBarStyles.css which contains the definition of each styles assigned in the CssClass. All these styles must be assigned as it is to resolve the IE performance issue.

Hope this helps,
James.

WebGrid Batch Update

acunningham — Tue, 03 Nov 2009 08:54:45 GMT

James,

We are currently using IE 7 and not IE8.

How many styles exactly are we talking about having to override? I assume this is a bug with the control since we can't use it out of the box with these performance issues? Even using the standard out of the box styles we get this problem.

Currently one of our proposed workarounds is simply to ditch the Intersoft MenuBar completely until such times as there is a fix for this issue or we find another more suitable MenuBar that doesn't cause us these issues.

Regards,

Adrian.

WebGrid Batch Update

james — Tue, 03 Nov 2009 08:50:07 GMT

Hi Adrian,

It appears to be performance issue in IE8, where the runtime styles take ages to create. The same sample worked fine in other browsers.

A working solution to this issue is by assigning the CssClass of all menu styles in the StyleSettings.MenuStyles. When the CssClass of all styles are assigned, the control will quickly look over the classes defined in your pages (can be inline styles defined in the <style> tag or in external css file). This should resolve the IE 8 performance issue associated with WebMenu control.

Let me know if that helps in your case. Thanks!

Regards,
James.

WebGrid Batch Update

acunningham — Tue, 03 Nov 2009 07:58:26 GMT

Handy,

I also think an issue I posted to the Devloper Network earlier in the year is possibly connected to this as the "IntegratedTo" property was causing me the same issue then.

WebToolBar Crashes IE [IS-F0A149C8-A17F-44F6-88F5-B90718928C4F]

Regards,

Adrian.

WebGrid Batch Update

acunningham — Tue, 03 Nov 2009 07:56:28 GMT

Handy,

A combination of Intersoft controls appears to be causing the performance issue that we are experiencing, and I can confirm Shawn's issue. The level of performance resulting is completely unacceptable for a web application hence our need to rollback to the previous version which is not ideal as there are many features in the new release that we need.

In fact Shawn's sample perfectly demonstrates the issue we are having. The control that appears to be causing the issue is the WebMenuBar control, and more specifically the "IntegratedTo" property being set to none.

By simply changing the value of the "IntegratedTo" property to "DesktopManager", the page in the sample loads immediately, however with the value set to "None" it takes considerably longer, almost 30 seconds.

If I remove the "IntegratedTo" property altogether it also loads fast but I get JavaScript errors when I hover on the menu. The error received is "this.CommandStyle is null or not an object".

Regards,

Adrian.

WebGrid Batch Update

handy@intersoftpt.com — Tue, 03 Nov 2009 05:42:20 GMT

Hello Adrian,

I am glad that the workaround wokrs fine on yours. But may i know why you need to revert back to previous 2008 release? I think i also got the same report from Shawn. But we need to replicate the issue first to investigate the issue.

Regards,
Handy

WebGrid Batch Update

acunningham — Mon, 02 Nov 2009 07:47:00 GMT

James,

I did use this approach to preserve batch update changes and it worked fine.

However in the end we had to revert back to the previous 2008 release of your controls as we were experience performance issues with the Grid in combination with WebPaneManager and MenuBar controls, which meant that the page response times were unacceptable.

Regards,

Adrian.

WebGrid Batch Update

james — Sat, 31 Oct 2009 01:48:50 GMT

Hi Adrian,

You can get the pending changes data in server-side by handling the BatchUpdate server-side event.

First, you can access all modified rows through e.PendingChanges, and then loop through the list of the modified cell data in the Data property of each row change.

Here's the C# code example that shows how to achieve this scenario.

protected void Page_Load(object sender, EventArgs e)
{
     WebGrid1.BatchUpdate += new EventHandler<BatchUpdateEventArgs>(WebGrid1_BatchUpdate);
}
void WebGrid1_BatchUpdate(object sender, BatchUpdateEventArgs e)
{
    foreach (WebGridRowChanges changes in e.PendingChanges)
    {
        foreach (WebGridCellData cellChanges in changes.Data)
        {
            string newText = cellChanges.NewText;
               
            // TODO: update your data row to the new text
        }
    }
}

Let me know if the above sample works for you.

Hope this helps,
James.

WebGrid Batch Update

handy@intersoftpt.com — Thu, 29 Oct 2009 23:52:21 GMT

I assume you knew how to bind your DataTable into WebGrid. For your issue, could you let me know what you used to get the pending changes return value? Normally, i used e.PendingChanges[0].Data[0].NewText or OldText in BatchUpdate server side event to get pending changes value.

Regards,
Handy

WebGrid Batch Update

acunningham — Wed, 21 Oct 2009 16:25:03 GMT

Hi,

Questions:

Will the BatchUpdate feature of the WebGrid Update a DataTable constructed in the Code Behind of the ASPX page that is not connected in any way to the physical database?
If so at which point is the DataTable updated as I can't see the changes in the BatchUpdate method? And will need to iterate through the DataTable to actually write the changes to the database.

Context:
DataTable is used to flatten out a complex data structure so each value can be display on a row.

Top level Data Object (Region Object) contains a nested List of data, each element is a Data Object (Factor Object)

Each element (Factor Object) of the nested list also contains a nested list of data, each elemtn is a data object (LOBFactor object).

Each element (LOBFactor Object) of nested list contains a list of data objects (FactorValue Object) which contains the actual data values.

Here is data structure:

Factor Object
...
private int _factorID
private string _Description
private int _months;
private decimal _rate;
private List<LOBFactor> _lobFactors // Contains a list of 7 objects.
...

LOBFactor Data Object: (7 instances of this object, i.e. 7 ColumnSets)

LOBFactor Object
...
private int _lobID;
private string _lobName;
private List<FactorValues> _factorValues; // Contains list of 5 objects
...

Factor Value Object:
...

private int _factorID;
private int _lobID;
private decimal _factorValue;

...

- I basically need to flatten this structure to display all the nested values on a Grid row.
- Be able to make changes to any cell in the grid using the batch update mechanism.
- Have those changes saved to my DataTable in the code behind
- Then transfer those changes back to my nested data structure before sending to database.

Regards,
Adrian