I tried your issue with a 30000 row DataTable and could not reproduce your issue, could you provide more info on the type of data, maybe post a stack trace of the issue?
If you have a compact sample, you could submit it to Developer Support and let them debug it as well.
I am currently having this issue. I have a grid that is loaded based on a menu selection. I select a particular menu item, the grid loads and also another grid loads for searching purposes. I have a column that is text and when I place a '(' in the cell and tab, the error comes up. But it is only this particular menu item. There really is no stack trace in the error message. Could someone please help me?
I believe that it will be very hard to figure this out here without any error or reproduction information. On the other hand, it is good that you have a website where you can reproduce that, so in this case I believe the best approach would be to contact our Developer Suport guys, sending them a small subset of your project reproducing the issue - this they will have a repro and will surely be able to provide additional clues.
You can contact Developer Support via this link:
http://ko.infragistics.com/gethelp/default.asp
Well I shrunk my dataset size and the issue seemed to go away. But why is there a limit? And why is the paging size not helping?
It seems to error around 3100 records for me. Anything below, is ok. Am I missing a setting or something?
I does not seem right, I've seen the grid work with thousands and even millions of records (with the correct datasource management) and even in this case - the end result would be slowness rather than exception.
The best way to proceed in this situation I believe is to send a small subset of your project reproducing the issue to our Developer Support folks - they can be reached via this link
If we have a repro, it will be easier to figure out what is going on.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register assembly="Infragistics35.WebUI.UltraWebGrid.v8.1, Version=8.1.20081.2013, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid" tagprefix="igtbl" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
<script type="text/javascript" id="igClientScript">
<!--
alert("In Mouse Down")
//Add code to handle your event here.
}
{
// -->
</head>
<body>
<form id="form1" runat="server">
<div>
Width="325px">
<bands>
<igtbl:UltraGridBand>
<addnewrow view="NotSet" visible="NotSet">
</addnewrow>
</igtbl:UltraGridBand>
</bands>
allowdeletedefault="Yes" allowsortingdefault="OnClient"
enableinternalrowsmanagement="True" headerclickactiondefault="SortMulti"
selecttyperowdefault="Extended" stationarymargins="Header"
stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00">
font-names="Microsoft Sans Serif" font-size="8.25pt" height="200px"
width="325px">
</framestyle>
<ClientSideEvents MouseDownHandler="UltraWebGrid1_MouseDownHandler" />
<pager allowpaging="True" minimumpagesfordisplay="2" pagesize="50">
<PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
widthtop="1px" />
</PagerStyle>
</pager>
<editcellstyledefault borderstyle="None" borderwidth="0px">
</editcellstyledefault>
<footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">
</footerstyledefault>
horizontalalign="Left">
</headerstyledefault>
borderwidth="1px" font-names="Microsoft Sans Serif" font-size="8.25pt">
<padding left="3px" />
<borderdetails colorleft="Window" colortop="Window" />
</rowstyledefault>
<groupbyrowstyledefault backcolor="Control" bordercolor="Window">
</groupbyrowstyledefault>
<groupbybox>
<boxstyle backcolor="ActiveBorder" bordercolor="Window">
</boxstyle>
</groupbybox>
<addnewbox hidden="False">
borderwidth="1px">
</addnewbox>
<activationobject bordercolor="" borderwidth="">
</activationobject>
<filteroptionsdefault>
borderwidth="1px" customrules="overflow:auto;"
width="200px">
<padding left="2px" />
</filterdropdownstyle>
<filterhighlightrowstyle backcolor="#151C55" forecolor="White">
</filterhighlightrowstyle>
borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;"
font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">
</filteroperanddropdownstyle>
</filteroptionsdefault>
</displaylayout>
</igtbl:UltraWebGrid>
Text="Button" />
</div>
</body>
</html>
Private Function GetGridData(Optional ByVal ExcelAll As Boolean = False) As Boolean
'***********************************************************************************************
' GetGridData -
' This function retrieves List data based on a particular List ID
'
' Created by: Elizabeth Ware, SolutionWerx
Dim dsLists As New DataSet
UltraWebGrid1.DisplayLayout.Pager.PageSize = 50
UltraWebGrid1.Width = Unit.Percentage(100)
UltraWebGrid1.Height = Unit.Percentage(100)
UltraWebGrid1.DisplayLayout.SelectTypeRowDefault = Infragistics.WebUI.UltraWebGrid.SelectType.Single
UltraWebGrid1.DataSource = dsLists
UltraWebGrid1.DataKeyField = "pkAuthorityID"
UltraWebGrid1.DataBind()
Return True
End Function
This calles a simple select * from and binds it.
Thanks.