Sorting a Data Table

Question

I tried to sort a data table with following two ways  table DefaultView Sort    Town ASC  Cutomer ASC   table Select      Town ASC  Cutomer ASC     But none of them wasn t worked  It always displays data in original order  Do you have any idea to solve the problem

User · Accepted Answer

After setting the sort expression on the DefaultView (table.DefaultView.Sort = "Town ASC, Cutomer ASC" ) you should loop over the table using the DefaultView not the DataTable instance itself

foreach(DataRowView r in table.DefaultView)
{
    //... here you get the rows in sorted order
    Console.WriteLine(r["Town"].ToString());
}

Using the Select method of the DataTable instead, produces an array of DataRow. This array is sorted as from your request, not the DataTable

DataRow[] rowList = table.Select("", "Town ASC, Cutomer ASC");
foreach(DataRow r in rowList)
{
    Console.WriteLine(r["Town"].ToString());
}

User · Answer

This was the shortest way I could find to sort a DataTable without having to create any new variables    DataTable DefaultView Sort    ColumnName ASC  DataTable   DataTable DefaultView ToTable   Where   ASC - Ascending  DESC - Descending  ColumnName - The column you want to sort by  DataTable - The table you want to sort

User · Answer

private void SortDataTable DataTable dt  string sort    DataTable newDT   dt Clone    int rowCount   dt Rows Count   DataRow   foundRows   dt Select null  sort      Sort with Column name for  int i   0  i  lt  rowCount  i      object   arr   new object dt Columns Count   for  int j   0  j  lt  dt Columns Count  j      arr j    foundRows i  j     DataRow data row   newDT NewRow    data row ItemArray   arr  newDT Rows Add data row        clear the incoming dt dt Rows Clear     for  int i   0  i  lt  newDT Rows Count  i      object   arr   new object dt Columns Count   for  int j   0  j  lt  dt Columns Count  j      arr j    newDT Rows i  j      DataRow data row   dt NewRow    data row ItemArray   arr  dt Rows Add data row

User · Answer

Try this   Dim dataView As New DataView table  dataView Sort     AutoID DESC  Name DESC  Dim dataTable AS DataTable   dataView ToTable

User · Answer

This worked for me   dt DefaultView Sort    Town ASC  Cutomer ASC   dt   dt DefaultView ToTable

[.net] Sorting a Data Table

Examples related to .net

Examples related to vb.net