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

End Sub

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

End Sub

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()

Dim intColCount, intIndex As Integer

intColCount = dsSearchResult.Tables(1).Columns.Count

For intIndex = 0 To intColCount - 1

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

Next

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>

<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>

</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://es.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 Engineer
Infragistics
www.infragistics.com/support