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
– nnnn, Commented Jan 25, 2013 at 2:13

Anda Iancu · Accepted Answer · 2013-01-24 07:11:13Z

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, 2013 at 7:11

Anda Iancu

5301 gold badge3 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

nnnn Over a year ago

I want to use this SUBSTRING() in Sort Condition but it is wrong.

Anda Iancu · Accepted Answer · 2013-01-24 07:25:11Z

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, 2013 at 7:25

Anda Iancu

5301 gold badge3 silver badges9 bronze badges

1 Comment

Anda Iancu Over a year ago

stackoverflow.com/questions/4939518/…

Collectives™ on Stack Overflow

Datatable.Select sort expression with some sql function

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related