I am using Infragistics Ultrawebgrid on my asp page,now I need to sort data based on user clicked columns but every time i don't want to fetch the records from the table.
I have enabled the in-build sorting property but at certain situations the sorting is not in sorted order ,here when the user clicks a specific column of the Grid, the data must be sorted based on the column not from the database query..can any one help me to find solution .......
-Anbuselvan
Hi anbusel,
I would suggest that you set the "AllowSortingDefault" property in your grid's DisplayLayout to "OnClient" to allow for client-side sorting. If you are experiancing additional issues with sorting I would need a more detailed description of the behaviors you are experiencing along with information regarding your product version.
Please feel free to contact me if you have any additional questions.
Best Regards,
Petar IvanovDeveloper Support EngineerInfragistics, Inc.http://www.infragistics.com/support
Please feel free to contact me if you need further assistance regarding your scenario.
Hi Petar Ivanov,pages are not having this sorting performance issue as we have LoadOnDemandXml property and server-side sorting and rest of grid pages are having client-side sorting. Client-side sorting will not work with LoadOnDemand property hence this property is removed in these pages which can improve only page load performance. How to improve the client-side sorting performance in Infragistics Web Grid.
Hi Viviek,
Thank you for your reply.
In order to try and improve the client-side sorting performance you may want to use a different sorting algorithm:
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/Infragistics4.WebUI.UltraWebGrid.v11.1~Infragistics.WebUI.UltraWebGrid.SortingAlgorithm.html
You can also define a custom sorting algorith for either serverside or clientside sorting:
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/WebGrid_Defining_a_Custom_Sorting_Algorithm_Client_Side.html
http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/WebGrid_Defining_a_Custom_Sorting_Algorithm_Server_Side.html
Please note 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/
Do not hesitate to contact me with any questions.
Hi Petar Ivanov,
Thanks for reply. i need one more clarification.
Client-Side Sorting (performance issue)
I'm using an UltraWebGrid to display data, with client-side sorting. but the performance is low and it take more time to sort.
Broswer="Xml"; LoadOnDemand="Xml"; AllowSortingDefault="OnClient";
i need the clarification of why taking more time to sort and how to resolve the issue.