Hi
I am working on Webgrid v10.3. It was working fine. Recently database has more than one lakh of records. So when user started to scroll, it is taking long time. Users like the scrolling things.So i have to keep the scrolling instead of pageing.
So is there any possibilities of that i can get the range of records instead of get all the record at a time from database on scrolling.
I have tried with this with Paging. But users want scrolling.
Please advice.
Thanks
Hi anjaimaity1,
Please do not hesitate to contact me if you have any further questions.
Best Regards,
Petar IvanovDeveloper Support EngineerInfragistics, Inc.http://ko.infragistics.com/support
Thank you for your reply.
Although I can see no issues with your code, please keep in mind that XML virtual scrolling works on the top band only (Load-on-demand for the child rows fetches all child rows for the respective parent). Please ensure that your datasource is initialized in the InitializeDataSource event as prescribed at:
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2010.1/CLR3.5/html/WebGrid_Using_XML_Load_On_Demand.html
Do not hesitate to contact me if you have any questions.
Thanks for reply.
I have used
GridLines =
UltraGridLines
.Both;
DisplayLayout.Name = id;
DisplayLayout.OptimizeCSSClassNamesOutput = Infragistics.WebUI.Shared.
DefaultableBoolean
.False;
DisplayLayout.GridLinesDefault =
DisplayLayout.AllowUpdateDefault =
AllowUpdate
.No;
DisplayLayout.BorderCollapseDefault =
BorderCollapse
.Separate;
DisplayLayout.CellClickActionDefault =
CellClickAction
.RowSelect;
DisplayLayout.RowHeightDefault =
Unit
.Pixel(21);
DisplayLayout.SelectTypeRowDefault =
SelectType
.Single;
DisplayLayout.SelectTypeCellDefault =
DisplayLayout.StationaryMarginsOutlookGroupBy =
true
;
DisplayLayout.StationaryMargins =
StationaryMargins
.Header;
DisplayLayout.TableLayout =
TableLayout
.Fixed;
DisplayLayout.UseFixedHeaders =
DisplayLayout.AutoGenerateColumns =
false
DisplayLayout.AllowSortingDefault =
AllowSorting
.OnClient;
DisplayLayout.FilterOptionsDefault.AllowRowFiltering =
RowFiltering
DisplayLayout.ScrollBar =
ScrollBar
.Auto;
DisplayLayout.ScrollBarView =
ScrollBarView
DisplayLayout.ViewType =
ViewType .Hierarchical;
DisplayLayout.HeaderClickActionDefault =
HeaderClickAction .SortSingle;
DisplayLayout.EnableProgressIndicator =
true ;
Browser =
BrowserLevel .Xml;
DisplayLayout.LoadOnDemand =
LoadOnDemand .Xml;
and also tried with LoadOnDemand event.
This event is not firing , whiling i am scrolling.
Hi anjanmaity,
Thank you for posting in the community.
You can implement virtual scrolling for your UltraWebGrid in order to achieve your requirement. In order to do that you need to set the grid's Browser property to XML and also the LoadOnDemand property in DisplayLayout to XML. You may also wish to set the XmlLoadOnDemandType property in DisplayLayout to Accumulative so that data is accumulatively added to the grid and users can scroll back up without the need for an Ajax callback.
Note however, that the UltraWebGrid control is now outdated and as of .NetAdvantage 2011 Volume 2 is no longer included in our product package. I would suggest that you consider switching to the WebDataGrid/WebHieararchicalDataGrid. More information regarding these controls is available at:
http://help.infragistics.com/NetAdvantage/ASPNET/2011.2/CLR4.0/?page=Web_WebDataGrid_WebDataGrid.html
Additional samples demonstrating the features of these grids can be found at:http://samples.infragistics.com/aspnet/
Please let me know if this helps.