Print Page | Close Window

Data Lost in Infragistics WebGrid during paging

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=889
Printed Date: 11-Jun-2026 at 12:00am


Topic: Data Lost in Infragistics WebGrid during paging
Posted By: Rajan
Subject: Data Lost in Infragistics WebGrid during paging
Date Posted: 15-Jul-2008 at 6:33am
We are using AspDataSource and bind the same to the Infragistics grid. When we try to bind 450 rows, the application is very slow, so we tried to use the pagination. After implementing the pagination, we have got the first page and when we navigate to next page the grid is empty. Please find below the code that we implemented. Is there anything wrong in the code?
<igtbl:UltraWebGrid ID="uwgABCResults" runat="server" Width="99%" DataSourceID="mABCAspDataSource"

OnInitializeRow="uwgABCResults_InitializeRow" >

<DisplayLayout AutoGenerateColumns="false" SelectTypeRowDefault="Single" Name="ctl00xUltraWebGrid1"

AllowSortingDefault="OnClient" AllowDeleteDefault="No" AllowUpdateDefault="No"

AllowColSizingDefault="Free" RowHeightDefault="20px" TableLayout="Fixed"

RowSelectorsDefault="No" AllowColumnMovingDefault="None" HeaderClickActionDefault="SortMulti"

StationaryMargins="Header" BorderCollapseDefault="Separate" Version="4.00" ScrollBarView="Both">

<FrameStyle Width="99%" Wrap="false" Height="230">

</FrameStyle>

<Pager AllowPaging="true" PageSize="25" StyleMode="ComboBox" >

<PagerStyle BackColor="LightGray" BorderWidth="1px" BorderStyle="Solid">

<BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" WidthTop="1px">

</BorderDetails>

</PagerStyle>

</Pager>

<cc1:AspDataSource ID="mABCAspDataSource" runat="server"

AdapterManagerTypeName="ABC.Adapters.ABCAdapterManager"

AdapterManagerAssemblyName="ABC.Adapters, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null">

</cc1:AspDataSource>




Replies:
Posted By: davidklitzke
Date Posted: 15-Jul-2008 at 11:31am
I would try to measure how much time is being spent by the AdapterManager retrieving the data and how much time is spent by by the grid displaying the data,  You should be able to set breakpoints in the Adapter Manager code to do this.
 
It might also be useful to compare with another WebGrid such as the .NET GridView.
 
It might also be useful to see if the Adapter Manager has lost the data or has the grid lost the data.


Posted By: Rajan
Date Posted: 16-Jul-2008 at 7:50am
I would try to measure how much time is being spent by the AdapterManager retrieving the data and how much time is spent by by the grid displaying the data,  You should be able to set breakpoints in the Adapter Manager code to do this.
First time the adapter manager takes 4-5 seconds and next time onwards it is from the cache so it is very less.
 
It might also be useful to compare with another WebGrid such as the .NET GridView. 
Tried with .NET Grid view with less columns it is rendering fast when compare to .NET Infragistics.
It might also be useful to see if the Adapter Manager has lost the data or has the grid lost the data.
Need to check, during the pagination the SelectEntities event is not firing.
 
Further investigation to the performance issue, i noticed that columns having TypeDescriptors are taking more time. i.e We have nested entities/classes and we are adding type descriptor columns and binding to the grid. The same infragistics control renders fast without these columns. Please find below the code we are using to add the type descriptor.
 
IdeaBlade.Util.PropertyDescriptorList pdl = IdeaBlade.Util.PropertyDescriptorList.Get(typeof(ABC));

pdl.Add("BusinessAddress1", "BusinessAddress.Address1");

ABCD.Business.DevForceTypeDescriptionProvider provider = new ABCD.Business.DevForceTypeDescriptionProvider(typeof(ABC));

System.ComponentModel.TypeDescriptor.AddProvider(provider, typeof(ABC));

Let us know if there is any known issues or any solution for this and the total page render takes more than 3 minutes to display which is un-acceptable to anybody.

Thanks for your time in looking into this.

Rajan R.G


Posted By: davidklitzke
Date Posted: 16-Jul-2008 at 4:33pm
It looks like most of the performance problems are comiong from the Grid, and not the DevForce code, so I don't know if there is a lot you can do.
 
My first thought is to talk to Infragistics and see what they can do for you.  You might get a more favorable response from them if you can show them that performance is a lot better with a different grid.



Print Page | Close Window