Currently i m working as developer. i am new to infragisitcs Ultraweb grid tool.
facing some techinical issue in ultraweb grid. i have 100,000 records in the database. if i load the all the records from the server. it cause time out error. i planning to show only 20 records record per pages but the paging should be 100,000. for ex 100,000/20 = 5000. i want to get the records when i select the paging controls in ultraweb grid.
Is there any possiable to customize the ultrawebgrid control as per my request.
Reg
Ramesh P.
<%@ 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.
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
http://ko.infragistics.com/gethelp/default.asp
If we have a repro, it will be easier to figure out what is going on.
It seems to error around 3100 records for me. Anything below, is ok. Am I missing a setting or something?
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?