How to sort a datatable

[Udayachal]

I am trying to sort on a datatable in vb.net 2003 but the sorting is not working. I use the following code "DTPROD.DefaultView.Sort = ("Animal, DPROD DESC")".

When I view the information in a datagrid sorting is done. If I use a loop to check my column my datatable "Animal" is not sorted.

Is there someone who can explain why I see the sorts in the datagrid although my loop on my datatable gives me no rows sorted?

[DotNetUser]

I guess the property DefautView is just a sort of view when the data are displayed in a DataGrid. If you want your datatble sorted, you can not do it directly in your query, if as I suppose your data from a database?

[Udayachal]

Thank you very much for answering me. Actually I also believe that the sorting is only for display in a datagrid. My data does not come from a comic. It comes from an XML file. I transferred into the datatable, I do some manipulation before transferring everything into a comic. The key for me is being able to sort the data before making my manipulations.

[DotNetUser]

So I guess you'll have to sort by manually. You use two DataTables and use String.Compare (to sort by alphabetical order)

[Udayachal]

Do you think I could send my data in more than a datatable to my sort? Is it that there would be another component that would allow me to make a sort of 2 columns? And who could then be transferred to a datatable.

Example array, ArrayList, or another dataset?

[fellah]

You must use your defautview of dataTable and not directly

datatable.rows(index).item

if my memory is correct it should be something like this:

datatable.defautview.item(index).item

[$tatic]

You can always use the DefaultView as DataTable. One can modify your code:

DTPROD.DefaultView.Sort = "Animal, DPROD DESC"

and then try to do this:

yourDataGrid.DataSource = DTPROD.DefaultView.ToTable();