Hi, I have a RadGrid in my page and one of the columns is Size. Size is a combination of dimensions. Let's say, for the sake of simplicity, we have three dimensions - length, width, and height..When displaying, it will not always be in the format of [length x width] or [length x width x height], some might need to be displayed as [width x height] only or ]width x length x height]. We already have appropriate sql function that formats the display appropriately.
Another thing is this field is of string type. So when sorting, we will have issues.In terms like 12 can come up before 9. So what we have done is create another sql function that helps sort it appropriately. We have a varchar(30) columns where we plug in 10 length value for each dimension - 1st five is for the whole number part, 2nd five for decimal part, multiplied by three dimensions so 30 characters length always. Eg.
Length Width Height Display SortValue
10 12.125 7 10 x 12.125 x 7 000100000000012125000000700000
5 7.75 9.5 7.75 x 5 x 9.5 000077500000005000000000950000
8.5 9 2.0125 8.5 x 9 x 2.0125 000085000000009000000000201250
2.5 8 2.5 x 8 000025000000008000000000000000
I am getting data using NeedDataSource. My sql query gets only as much data as is needed to show in the page. So if grid page size is 10, I get first 10 rows only for page 1. When user navigates to second page, code calls NeedDataSource again to get the next 20 rows of data.
In SortCommand method, all I do is populate a SortDictionary with appropriate field name and sort order and rebind grid again.
Dictionary<String, String> SortByDictionary
>() : (Dictionary<String, String>)ViewState[
] = value; }
sender, GridSortCommandEventArgs e)
var key = e.CommandArgument.ToString();
(e.NewSortOrder == GridSortOrder.None)
SortByDictionary[key] = e.NewSortOrder == GridSortOrder.Ascending ?
e.Item.OwnerTableView.DataSource = GetData(
In the GetData function, to create the order by part of the sql query, I loop through all the keys in SortDictionary and change order column to SortValue if I see Display there. Sql query comes up fine and executing it in SSMS presents me the results correctly. For example, from the data example above, it gives me line 5 first, then 3, 4 and 2 as expected.
However, problem lies when displaying in grid. Because user had clicked sort by Display column, grid resorts the data again. So the data gets displayed as line 2, 5, 3, and 4.
My question is - is there a way to prevent grid from resorting? I am using Telerik.Web.UI version 2013.3.1324.40.