Datatable select method ORDER BY clause

Question

HI, 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 hte 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?

Answer 2

Nope i didnt :( thanks for the help