Why does CopyToDataTable unsort the DataRow Array

Question

I've got a datatable that I need to sort and place back into another datatable. On the face of this its easy as below:

 DataTable sortme = getdata();
 sortme.Select("col1 = 'something'", "sortbyme ASC").CopytoDataTable();

However, I've found as soon as I pass the DataRow array created by select() to CopytoDataTable(), the new datatable is no longer sorted by sortbyme.

How do I fix this without creating a loop to push each DataRow into a datatable? And what is causing the sorting to be lost?

score 0 · Answer 1 · edited May 23 '17 at 11:51

0

There is already a question asked and solved about how to sort DataTables by row, please look at it here, it might help you:

Sorting rows in a data table

edited May 23 '17 at 11:51

Community

1
1

answered Sep 29 '15 at 23:10

Pedro Esteban

21
5

This does not answer my question. I want to know why CopytoDataTable is not working as expected, because I need to do more than sort. – sunrunner20 Sep 30 '15 at 14:45
Could you give me a little bit more insight? What is the current outcome of it? – Pedro Esteban Sep 30 '15 at 22:46

Why does CopyToDataTable unsort the DataRow Array

1 Answers1