Datatable select method ORDER BY clause

Question

I 'm trying to sort the rows in my datatable using select method. I know that i can say

datatable.select("col1='test'") 

which in effect is a where clause and will return n rows that satisfy the condition.

I was wondering can i do the following

datatable.select("ORDER BY col1") ---col1 is the name of the column

I tried datatable.defaultview.sort() but didnt work

Any ideas on how to get around this issue. thanks

Answer 1

Have you tried using the DataTable.Select(filterExpression, sortExpression) method?