i am using Ultra web grid
i am displaying records with parent child relationship
parent grid is having 58k+ records
And child grid is having 2lak + records
grid is working file if i need less then 20 k records (parent+ child records)
But if i want to display all records it is giving an error
please guide me if i am doing wrong
Sorry forgot to add code
aspx.vb file----
Protected Sub uwgAuditTrail_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles uwgAuditTrail.PreRender
If uwgAuditTrail.Rows.Count = 0 Then uwgAuditTrail.Columns.Clear()
End Sub
End Class
Protected Sub uwgAuditTrail_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles uwgAuditTrail.Init
Private Sub uwgAuditTrail_InitializeLayout(ByVal sender As Object, ByVal e As LayoutEventArgs) Handles uwgAuditTrail.InitializeLayout
SetParentBandColumnsProperties()
SetChildBandColumnsProperties()
With uwgAuditTrail.DisplayLayout
.AllowAddNewDefault = AllowAddNew.No
.AllowDeleteDefault = AllowDelete.No
.AllowColumnMovingDefault = AllowColumnMoving.None
.AllowUpdateDefault = AllowUpdate.No
End With
e.Layout.Pager.AllowPaging = True
'Set the display of pages through a combo box.
e.Layout.Pager.StyleMode = Infragistics.WebUI.UltraWebGrid.PagerStyleMode.ComboBox
e.Layout.Pager.PageSize = 25
End Sub 'uwgAuditTrail_InitializeLayout
Protected Sub uwgAuditTrail_InitializeRow(ByVal sender As Object, ByVal e As Infragistics.WebUI.UltraWebGrid.RowEventArgs) Handles uwgAuditTrail.InitializeRow
e.Row.Cells.FromKey("Item").TargetURL = "2"
If Trim(e.Row.Cells.FromKey("Type").Value).ToString.ToUpper = "U" Then
e.Row.Style.BackColor = Drawing.Color.AliceBlue
e.Row.Cells.FromKey("ID").TargetURL = "1"
Else
e.Row.Style.BackColor = Drawing.Color.White
End If
Private Sub SetParentBandColumnsProperties()
Dim intColCount, intIndex As Integer
intColCount = dsSearchResult.Tables(0).Columns.Count
For intIndex = 0 To intColCount - 1
uwgAuditTrail.DisplayLayout.Bands(0).Columns(intIndex).Header.Style.Font.Name = "Verdana"
uwgAuditTrail.DisplayLayout.Bands(0).Columns(intIndex).Header.Style.Font.Size = FontUnit.Smaller
uwgAuditTrail.DisplayLayout.Bands(0).Columns(intIndex).Header.Style.Font.Bold = True
uwgAuditTrail.DisplayLayout.Bands(0).Columns(intIndex).CellStyle.Font.Name = "Verdana"
uwgAuditTrail.DisplayLayout.Bands(0).Columns(intIndex).CellStyle.Font.Size = FontUnit.XSmall
Next
uwgAuditTrail.Bands(0).FilterOptions.AllowRowFiltering = RowFiltering.OnClient
uwgAuditTrail.Bands(0).HeaderClickAction = Infragistics.WebUI.UltraWebGrid.HeaderClickAction.SortMulti
uwgAuditTrail.Bands(0).HeaderStyle.CssClass = "HeaderStyle"
uwgAuditTrail.Bands(0).FooterStyle.CssClass = "FooterStyle"
uwgAuditTrail.Bands(0).RowExpAreaStyle.CssClass = "RowExpStyle"
uwgAuditTrail.Bands(0).RowSelectorStyle.CssClass = "RowSelectorStyle"
uwgAuditTrail.Bands(0).SelectedRowStyle.CssClass = "SelectedRowStyle"
uwgAuditTrail.Bands(0).RowStyle.TextOverflow = TextOverflow.Ellipsis
Private Sub SetChildBandColumnsProperties()
intColCount = dsSearchResult.Tables(1).Columns.Count
uwgAuditTrail.DisplayLayout.Bands(1).Columns(intIndex).Header.Style.Font.Name = "Verdana"
uwgAuditTrail.DisplayLayout.Bands(1).Columns(intIndex).Header.Style.Font.Size = FontUnit.Smaller
uwgAuditTrail.DisplayLayout.Bands(1).Columns(intIndex).Header.Style.Font.Bold = True
uwgAuditTrail.DisplayLayout.Bands(1).Columns(intIndex).CellStyle.Font.Name = "Verdana"
uwgAuditTrail.DisplayLayout.Bands(1).Columns(intIndex).CellStyle.Font.Size = FontUnit.XSmall
aspx file-----
<igtbl:UltraWebGrid ID="uwgAuditTrail" runat="server" Width="100%">
<DisplayLayout AllowAddNewDefault="Yes" RowHeightDefault="18px" Version="3.00" SelectTypeRowDefault="Single"
ViewType="Hierarchical" SelectTypeCellDefault="NotSet" BorderCollapseDefault="Separate"
AllowColSizingDefault="Free" Name="uwgAuditTrail" TableLayout="Fixed" SelectTypeColDefault="Single"
HeaderClickActionDefault="NotSet" CellClickActionDefault="Edit" IndentationDefault="12"
StationaryMargins="Header" AllowSortingDefault="OnClient" EnableInternalRowsManagement="True"
RowsRange="10">
<RowStyleDefault CssClass="RowStyle">
</RowStyleDefault>
<ImageUrls CurrentEditRowImage="~/images/Grid/arrow_brown2_beveled.gif" ExpandImage="~/images/Grid/ig_treeXPPlus.GIF"
CollapseImage="~/images/Grid/ig_treeXPMinus.GIF" CurrentRowImage="~/images/Grid/arrow_brown2_beveled.gif">
</ImageUrls>
<RowSelectorStyleDefault BorderStyle="None" CssClass="RowSelectorStyle">
</RowSelectorStyleDefault>
<ClientSideEvents CellClickHandler="UG1_CellClickHandler" />
<SelectedRowStyleDefault CssClass="SelectedRowStyle">
</SelectedRowStyleDefault>
<HeaderStyleDefault CssClass="HeaderStyle">
</HeaderStyleDefault>
<EditCellStyleDefault CssClass="EditCellStyle">
</EditCellStyleDefault>
<FrameStyle Width="100%" Cursor="Hand" BorderWidth="1px" Font-Size="8pt" Font-Names="Verdana"
BorderStyle="Solid" BorderColor="#396799">
</FrameStyle>
<FilterOptionsDefault>
<FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"
CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"
Font-Size="11px" Width="200px">
<Padding Left="2px" />
</FilterDropDownStyle>
<FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
</FilterHighlightRowStyle>
</FilterOptionsDefault>
<Pager Alignment="Center" AllowPaging="True" ChangeLinksColor="True" PageSize="20">
</Pager>
</DisplayLayout>
<Bands>
<igtbl:UltraGridBand>
<AddNewRow View="NotSet" Visible="NotSet">
</AddNewRow>
<FilterOptions>
</FilterOptions>
</igtbl:UltraGridBand>
</Bands>
</igtbl:UltraWebGrid>
Hello Sunil,Thank you for posting your inquiry to the Infragistics ASP.NET forums. When binding a large amount of data to the UltraWebGrid, the best approach is to use Partial DataBinding, where only a subset of the bound data is retrieved for display.In the information regarding Partial Data Binding found in the following link to the Infragistics NetAdvantage Online Help for ASP.NET, it explains how a subset of data is initially loaded and retrieved each time the UltraWebGrid scrolls out of the loaded rows range, giving the developer total control on the number of rows to retrieve: Partial Data Binding <https://ko.infragistics.com/help/aspnet/webhierarchicaldatagrid-data-binding>Information and sample code may be found in the above link, demonstrating the functionality of Partial Data Binding. Please take a look at the provided information and let me know if you have any questions.Thank you.Sincerely,Mike D.Developer Support EngineerInfragisticswww.infragistics.com/support