Sorting the dataset object using dataset.tables.select method

Question

please help me regarding this block of code... i have a table that has these fields (cCLID,cCLID,nLID) nLID is a numeric, but when I sort it the result show this sequence (1,10,2,3,4,5...) but i want to sort it this way (1,2,3,4,5...10)

sDataSet.Tables(tmp(0).Name).Select("cCLID='" & _cCLID.Text_Value & "'", "Convert(Numberic(18,0),nLID) ASC")

Ivan Ferić · Accepted Answer · 2013-01-29 09:59:28Z

1

Use a temp-Field like Sort_NLID and fill it in SQL like:

CASE WHEN ISNUMERIC(NLID) = 1 THEN CAST(NLID AS INTEGER) ELSE -1 END AS Sort_NLID

then sort

sDataSet.Tables(tmp(0).Name).Select("cCLID='" & _cCLID.Text_Value & "'", "Sort_NLID, nLID")

edited Jan 29, 2013 at 9:59

Ivan Ferić

4,76311 gold badges40 silver badges47 bronze badges

answered Jan 29, 2013 at 9:34

Volker Niemeyer

261 bronze badge

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

Collectives™ on Stack Overflow

Sorting the dataset object using dataset.tables.select method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related