I have attached a solution with the bug reproduced. I added a CHECKBOX control to the page to turn the bug on/off as well as a BUTTON to refresh the page.  This bug is really odd.  I am not sure how this is all connected but adding a SplitButton/DropDownButton to the ToolBar dramatically hurts performance to the point that we cannot use ANY of our applications. Furthermore, I am not sure why changing the WebToolBar's IntegrateTo and WebGrid's AutoFitColumns properties bring the performance back as expected? 

Please let me know as this is extremely high priority. Thank you!

This problem has resurfaced! The previous fix for us was to put the WebToolBar's CSS within a CSS file as suggested within this thread which fixed the problem. However, after upgrading to the current version of Intersoft, the performance bug is back and it's system wide across multiple applications. Here's another user with a similiar issue: 

http://www.intersoftpt.com/Community/WebGrid/WebGrid-7---Render-Performance-Extremely-Slow-When-WebMenuBar-On-Page/

The bug still exists even after removing *ALL* of the CSS (for testing) so I am not sure what's causing the problem. However, the performance is back if you:

1) Remove WebToolBar's IntegratedTo property which was set to "NONE"

     This causes the WebToolBar to have multiple JavaScript exceptions (this.CommandStyle is null or not an object) and the UI to be skewed

2) Set the WebGrid's AutoFitColumns to TRUE

    This is not desireable as we want to specify the column widths.

Please help as this is a major production issue making ALL of our applications unusable.

Thank you!

This issue is actually not WebGrid’s issue. It is caused by the rendering engine that belongs to the browser itself. Render a table that has thousands of rows is not that easy for web application. Not only WebGrid, but I believe event an HTML table itself.

You could improve WebGrid’s performance by disable WebGrid’s data caching, set PagingMode to Virtual Load and set WebGrid’s ViewStateStorage to none. Another option that you may try is probably the load on demand data retrieval concept. Child rows data of its parent row will not be rendered to client on each loaded table. The child rows of a table will be retrieved transparently when users click on “+” sign to expand the child rows. This results in efficient information delivery by displaying necessary information and load more information transparently when needed, all without leaving the current state of the working page.

Hope this helps.

Did you even read my thread? First of all, the VirtualLoad is MUCH slower by over ~45 seconds vs ClassicPaging. Furthermore, the ViewStateStorage is set to None per the markup I posted. Can you elaborate on how to disable the Data Caching?

In regards to your comment about this not being a WebGrid issue but a browser issue. I strongly disagree. It should not take nearly 2 minutes to load 3,500 records w/ a 200 page size. There is a tremendous difference in performance just changing from VirtualLoad to ClassicPaging and from changing the page size from 200 to 50.  Why would changing the page size from 200 to 50 result in over a ~46 second difference using ClassicPaging? Why does the rendering differ soo much between these settings? I work with other 3rd party controls such as Telerik, Infragistics, and even the base ASP DataGrid and *NONE* of them take nearly 2 minutes to load only 3,500 records w/ a page size of ~200 so I am not sure what those competitor products are are doing different. 

Hello Shawn,

You can set the culture in IntializeLayout or in PageLoad event. Please see the attached sample.
In my test, I am using WebGrid 7 build 416 and WebUIFramework build 767. However, I could not replicate the issue. So, would you mind to send us a simple runable sample that replicates the issue?

Regards,
Handy

I have attached a screen shot showing 3 DateFields with an alert box showing the field's value which is 1/5/2011, 1-5-2011, and 1.5.2011 respectfully. You will notice the first field is not rendered properly (05-Jan-2011) but the others are 01-May-2011. I have also enclosed both the client and server-side code.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UKCultureBug.aspx.cs" Inherits="UKCultureBug" %>
<%@ Register TagPrefix="iswebgrid" Namespace="ISNet.WebUI.WebGrid" Assembly="ISNet.WebUI.WebGrid" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
	<HEAD runat=server>
		<title>UKCultureBug</title>
		<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
		<meta name="CODE_LANGUAGE" Content="C#">
		<meta name="vs_defaultClientScript" content="JavaScript">
		<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
		 
          <script type="text/javascript">
              function DoRowSelect(controlId, tblName, rowIndex, rowEl)
               {
                  var grid = ISGetObject(controlId);
                  var table = grid.Tables[tblName];
                  var currentRow = table.ToRowObject(rowEl); // convert from element to WebGridRow object.
                  var cells = currentRow.GetCells();
                  var field1 = cells.GetNamedItem("ClaimDateOfLossFrom");                  
                  var field2 = cells.GetNamedItem("ClaimAdvisedDate");
                  var field3 = cells.GetNamedItem("DateOfEvent");
                  window.alert(field1.Value + " - " + field2.Value + " - " + field3.Value);
              }
          </script>
	
	</HEAD>
	<body MS_POSITIONING="GridLayout">
		<form id="Form1" method="post" runat="server">
		
			<iswebgrid:webgrid id=WebGrid1 runat="server"
			    DefaultStyleMode="Elegant"
                Height="100%" Width="100%" UseDefaultStyle="True" EnableViewState="false" ViewStateStorage="None"
                OnInitializeDataSource="WebGrid1_OnInitializeDataSource" OnInitializeLayout="WebGrid1_OnInitializeLayout"
                
                 
              >
                <LayoutSettings AllowBatchUpdate="true" BatchUpdateSettings-PromptUnsavedChanges="false" NewRowLostFocusAction="AlwaysUpdate"
                    AllowAddNew="Yes" AllowEdit="Yes" AllowDelete="Yes" EditOnClick="True" AutoHeight="false" RowHeightDefault="22px"
                    AutoWidth="false" AllowColumnFreezing="Yes" AllowExport="No" AllowFilter="No"
                    AllowSelectColumns="Yes" AllowSorting="No" AlwaysShowHelpButton="False" ApplyFiltersKey="Enter"
                    CellPaddingDefault="0" FilterBarVisible="True" HideColumnsWhenGrouped="Default"
                    InProgressUIBehavior="ChangeCursorToHourGlass"
                    PagingExportMode="ExportAllData" PagingMode="VirtualLoad" ResetNewRowValuesOnError="False"
                    ShowFilterStatus="True" VerboseEditingInformation="False" VirtualPageSize="200">
                    <ClientSideEvents OnRowSelect="DoRowSelect"  />
                    <FrameStyle>
                        <BorderSettings>
                            <Top Style="none" />
                            <Bottom Style="none" />
                            <Left Color="#6593cf" Style="solid" Width="1" />
                            <Right Color="#6593cf" Style="solid" Width="1" />
                        </BorderSettings>
                    </FrameStyle>
                    <HeaderStyle CssClass="WebGridHeaderStyle" />
                    <StatusBarStyle CssClass="WebGridStatusBarStyle" />
                    <StatusBarCommandStyle Active-CssClass="WebGridStatusBarCommandStyleActive" Normal-CssClass="WebGridStatusBarCommandStyleNormal"
                        Over-CssClass="WebGridStatusBarCommandStyleOver">
                        <Normal CssClass="WebGridStatusBarCommandStyleNormal" />
                        <Over CssClass="WebGridStatusBarCommandStyleOver" />
                        <Active CssClass="WebGridStatusBarCommandStyleActive" />
                    </StatusBarCommandStyle>
                    <FilterRowStyle CssClass="WebGridFilterRowStyle" />
                    <PreviewRowStyle CssClass="WebGridRowStyle" />
                    <RowStyle CssClass="WebGridRowStyle" />
                    <QuickFilterBarStyle CssClass="WebGridRowStyle" />
                    <RowHeaderStyle CssClass="WebGridRowHeaderStyle" />
                    <SelectedRowStyle CssClass="WebGridSelectedRowStyle" />
                    <EditFocusCellStyle CssClass="WebGridRowStyle" />
                    <FocusCellStyle CssClass="WebGridRowStyle" />
                    <LostFocusRowStyle CssClass="WebGridRowStyle" />
                    <NewRowStyle CssClass="WebGridRowStyle" />
                    <SortedColumnStyle CssClass="WebGridSortedColumnStyle" />
                    <AlternatingRowStyle CssClass="WebGridAlternatingRowStyle" />
                    <EditTextboxStyle CssClass="WebGridEditTextboxStyle" />
                    <FreezePaneSettings AbsoluteScrolling="True" ActiveFrozenColumns="3" MaxFrozenColumns="3"
                        ShowInContextMenu="False" ShowSplitterLine="False" SplitterLineColor="ActiveBorder"
                        SplitterLineWidth="1" />
                </LayoutSettings>
                <RootTable Caption="Claims Transaction" DataKeyField="UniqueID" ColumnFooters="Yes"> 
					  	 		<Columns>	
					  	 		  <ISWebGrid:WebGridColumn Caption="UniqueID" Name="UniqueID" DataType="System.Integer"
                                                 ColumnType="Text" EditType="NoEdit" NewRowEditType="NoEdit" FilterEditType="NoEdit"
                                                 Width="0px" Visible="false">
                        </ISWebGrid:WebGridColumn>
                        
 <ISWebGrid:WebGridColumn Caption="Date of Loss" Name="ClaimDateOfLossFrom" DataMember="ClaimDateOfLossFrom"
                            DataFormatString="dd-MMM-yyyy" DataType="System.String" ColumnType="Text" EditType="CalendarCombo"
                            NewRowEditType="CalendarCombo" FilterEditType="CalendarCombo" Width="75px">
                        </ISWebGrid:WebGridColumn>                                                                                                                
                        <ISWebGrid:WebGridColumn Caption="Reported Date" Name="ClaimAdvisedDate" DataMember="ClaimAdvisedDate"
                            DataFormatString="dd-MMM-yyyy" DataType="System.String" ColumnType="Text" EditType="CalendarCombo"
                            NewRowEditType="CalendarCombo" FilterEditType="CalendarCombo" Width="90px">
                        </ISWebGrid:WebGridColumn>   
                        <ISWebGrid:WebGridColumn Caption="Event Date" Name="DateOfEvent" DataMember="DateOfEvent"
                            DataFormatString="dd-MMM-yyyy" DataType="System.String" ColumnType="Text" EditType="CalendarCombo"
                            NewRowEditType="CalendarCombo" FilterEditType="CalendarCombo" Width="90px">
                        </ISWebGrid:WebGridColumn>

					</Columns>
				</RootTable>
			</iswebgrid:webgrid>
			 
		</form>
	</body>
</HTML>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
using System.Globalization;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using ISNet.WebUI.WebGrid;

public partial class UKCultureBug : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }

    protected void WebGrid1_OnInitializeLayout(object sender, ISNet.WebUI.WebGrid.LayoutEventArgs e)
    {
        // Set the user's culture
        this.SetUserCulture();
    }

    protected void WebGrid1_OnInitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
    {

        List<MyClass> data = new List<MyClass>();
        data.Add(new MyClass());
        data.Add(new MyClass());
        data.Add(new MyClass());
        e.DataSource = data;
    }

    private void SetUserCulture()
    {
        // Get/Set culture's format
        CultureInfo culture = new CultureInfo("en-GB");
        this.WebGrid1.LayoutSettings.Culture = culture;
        this.WebGrid1.LayoutSettings.TextSettings.Language = LanguageMode.UseCulture;
        this.WebGrid1.LayoutSettings.TextSettings.UseLanguage = culture.ToString();
    }

    /// <summary>
    /// Perform batch update on the Inurings WebGrid control's source
    /// </summary>
    /// <param name="source">Source to update</param>
    /// <returns>Updated source after batch update</returns>
    public void PerformInuringsGridBatchUpdate(object sender, EventArgs e)
    {
        // Get changes
        List<WebGridRowChanges> rowChanges = this.WebGrid1.GetChanges();

        // Perform change updates
        foreach (WebGridRowChanges rowChangesItem in rowChanges)
        {
            if (rowChangesItem.KeyValue != null)
            {
                switch (rowChangesItem.RowState)
                {
                    // Add
                    case RowState.Added:

                        break;
                    // Update
                    case RowState.Modified:

                        break;
                    // Delete
                    case RowState.Deleted:
                        break;
                }
            }
        }
    }

    private class MyClass
    {
       #region Variables
        private string _uniqueID = Guid.NewGuid().ToString();      
        private DateTime? _claimDateOfLossFrom = null;
        private DateTime? _claimAdvisedDate = null;
        private DateTime? _dateOfEvent = null;

        #endregion Variables

        #region Properties

        public string UniqueID
        {
            get { return this._uniqueID; }
            set { this._uniqueID = value; }
        }

        /// <summary>
        /// Claims Date Of Loss From
        /// </summary>
        public DateTime? ClaimDateOfLossFrom
        {
            get { return this._claimDateOfLossFrom; }
            set { this._claimDateOfLossFrom = value; }
        }

        /// <summary>
        /// Claim Advised Date
        /// </summary>
          public DateTime? ClaimAdvisedDate
        {
            get { return this._claimAdvisedDate; }
            set { this._claimAdvisedDate = value; }
        }

        /// <summary>
        /// Date Of Event
        /// </summary>
         public DateTime? DateOfEvent
        {
            get { return this._dateOfEvent; }
            set { this._dateOfEvent = value; }
        }

        #endregion Properties

        #region Constructors

        /// <summary>
        /// GeniusClaimAmountMaster constructor
        /// </summary>
        public MyClass()
        {
            this._claimDateOfLossFrom = DateTime.Now;
            this._claimAdvisedDate = DateTime.Now;
            this._dateOfEvent = DateTime.Now;
        }

        #endregion Constructors
    }    
}

I proprose applying a custom attribute during the WebGrid_SetRowBackgroundColor and re-apply the custom style during the AfterExitEditMode if the custom attribute exist.

I also found an alternative if you do not wish to have the modified row style in the Grid at all, you could just disable it in the BatchUpdate settings.

<BatchUpdateSettings HighlightChanges="false" />

This way, you do not have to implement the AfterExitEditMode event handler.

I don't see how making ANY changes within the AfterExitEditMode event will work given the background color is changed after? I provided sample code above to prove that.