Datatable.Select sort expression with some sql function

Question

I want to use some function in Sort Expression of Datatable.Select.
I try by this-

string strSelect="";
///Some code
string strSort="RIGHT(TESTID,2) DESC,SUBSTRING (TESTID,3,5) DESC, TESTDATE DESC";
dtOld.Select(strSelect,strSort );

but,I think there is something wrong by using sql function(eg.SUBSTRING) in Sort Expression. SO, How can I sort my datatable by this sort expression? Is it possible?
Thanks.

If there is impossible to use SUBSTRING in Datatable.Select,is there any other ways to do this problem?? — nnnn, Jan 25 '13 at 02:13

score 0 · Answer 1 · answered Jan 24 '13 at 07:11

0

Do you get any error message?

Not sure that will do but you have a space after SUBSTRING, SHOULD BE SUBSTRING(...,,).

I tested below for mysql and SQL server 2012 and it works:

SELECT SUBSTRING('AAA BBBCCC',3,5);

Result: A BBB

answered Jan 24 '13 at 07:11

Anda Iancu

530
1
3
9

I want to use this SUBSTRING() in Sort Condition but it is wrong. – nnnn Jan 24 '13 at 07:15

score 0 · Answer 2 · answered Jan 24 '13 at 07:25

0

string strSelect="RIGHT(TESTID,2) AS T1, SUBSTRING(TESTID,3,5) AS T2";
///Some code
string strSort="T1 DESC, T2 DESC, TESTDATE DESC";
dtOld.Select(strSelect, strSort);

answered Jan 24 '13 at 07:25

Anda Iancu

530
1
3
9

http://stackoverflow.com/questions/4939518/sorting-string-column-containing-numbers-in-sql – Anda Iancu Jan 24 '13 at 07:30

Datatable.Select sort expression with some sql function

2 Answers2