I've got a grid bound to a dataset that contains a column named "[$Colld]". The brackets are actually a part of the column name.
For this column on my grid, I've got
For this column on my grid, I've got
DataField="[$Colld]" |
and that works fine, the data shows in the grid. However, I've also got
SortExpression="[$Colld]" |
and when I click on the column header to sort by that column, I get this error:
Cannot find column $Colld.
It's like the brackets get ignored when they are in the SortExpression.
So I tried:
SortExpression="[[$Colld]]" |
but I get this error:
[[$Colld]] is neither a DataColumn nor a DataRelation for table ICRData.
How can I escape the brackets so that the SortExpression is accurately interpreted as "[$Colld]" ??