Sort Radgrid with column header contains comma (,) for auto generate column

[Ranjith]

Hi,

Im using Radgrid with AutoGenerateColumns="True" and the column header will be like "Firstname, Lastname" (with Comma). While sorting the grid on column (Firstname, Lastname) with sort expression field name it throws error like "Cannot find column Firstname". Im using the following code in RadGrid1_SortCommand.

GridSortExpression sortExpr = new GridSortExpression();
switch (e.OldSortOrder)
        {
            case GridSortOrder.None:
                sortExpr.FieldName = e.SortExpression;
                sortExpr.SortOrder = GridSortOrder.Descending;
                e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
                Session["GridSort"] = GridSortOrder.Descending;
                break;
            case GridSortOrder.Descending:
                sortExpr.FieldName = e.SortExpression;
                sortExpr.SortOrder = GridSortOrder.Ascending;
                e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
                Session["GridSort"] = GridSortOrder.Ascending;
                break;
            case GridSortOrder.Ascending:
                sortExpr.FieldName = e.SortExpression;
                sortExpr.SortOrder = GridSortOrder.Descending;
                e.Item.OwnerTableView.SortExpressions.AddSortExpression(sortExpr);
                Session["GridSort"] = GridSortOrder.Descending;
                break;
        }
e.Canceled = true;
RadGrid1.Rebind();

Sample Grid: (2nd Column Header contains Comma)

S.No	FirstName, LastName	DOB	City
1	XXX, X	11/11/1111	NJ
2	YYY, Y	11/11/1111	NJ
3	ZZZ, Z	11/11/1111	NJ

Please Reply ASAP.
Thanks in Advance.

Thanks,
Ranjith J

[Princy]

Hello Ranjith,

The following forum thread discusses the same scenario. As far as I know special characters are not supported in RadGrid field names. Check the thread for more details.

Sorting issue in RadGrid - columns start and end with brackets.

Thanks,
Princy.

[Ranjith]

Thanks Princy.

Is there any alernate source to overcome the current scenario.

Thanks,
Ranjith J

[Tsvetoslav]

Hello Ranjith,

What you are actually doing for the problematic column is assigning its DataField property to a coma separated string and that is not acceptable. Therefore, when retrieving the data from your underlying data-source just change the string containing field to another name. For example, if you have a SQL select statement, you should change it as follows:

Select S.No,    [FirstName, LastName] as FirstName_LastName,    DOB,    City FROM [yout table name goes here]

 Hope it helps.

All the best,
Tsvetoslav
the Telerik team