How do I sort an ASP.NET DataGrid by the length of a field?

Question

Hi all,

I have a DataGrid where each column has a SortExpression. I would like the sort expression to be the equivalent of "ORDER BY LEN(myField)".

I have tried

SortExpression="LEN(myField)"

but this throws an exception as it is not valid syntax. Any ideas?

Answer 1

I'm out of my element here, but what if you try SortExpression="myField.Length"

No - it gives the same error of "Cannot find column myField.Length". Thanks though :-)

Answer 2

What about returning the len by the query already, but don't show that column, only use it as your original column's sortexpression?

I don't think that your idea is supported by default.

Answer 3

Depending on your SQL flavor the following could work:

SELECT
 ColumnA as FieldA
 , ColumnB as FieldB
 , LEN(ColumnA) as FieldL
FROM TableName
ORDER BY L

And then do

SortExpression="FieldL"

Answer 4

The SortExpression parameter specifies the name of the column to sort, followed by "ASC" or "DESC" to control the order.

You could change the DataType property of the column to specifiy a user defined type whose comparer function compares string lengths. It won't be a trivial task.

Skizz

Answer 5

Using Linq, you could write your query like:

query.OrderBy(column => column.MyField.Length);

Answer 6

Hmmm. Had some time to test. I was able to get SortExpression="Description.Length" to work. Is this 1.1, 2.0 or 3.5?