How do you Sort a DataTable given column and direction?

by

I assume “direction” is “ASC” or “DESC” and dt contains a column named “colName”

public static DataTable resort(DataTable dt, string colName, string direction)
{
    DataTable dtOut = null;
    dt.DefaultView.Sort = colName + " " + direction;
    dtOut = dt.DefaultView.ToTable();
    return dtOut;
}

OR without creating dtOut

public static DataTable resort(DataTable dt, string colName, string direction)
{
    dt.DefaultView.Sort = colName + " " + direction;
    dt = dt.DefaultView.ToTable();
    return dt;
}

More Related Contents:

  1. How to use Select method of DataTable
  2. How to create a DataTable in C# and how to add rows?
  3. Creating a SQL Server table from a C# datatable
  4. How to fill a datatable with List [duplicate]
  5. Thread safety for DataTable
  6. DataTable equivalent in Java [duplicate]
  7. How do I create a DataTable, then add rows to it?
  8. How can I add user-supplied input to an SQL statement?
  9. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  10. How to select distinct rows in a datatable and store into an array
  11. Export DataTable to Excel with EPPlus
  12. SQLite Database Locked exception
  13. c# Using Parameters.AddWithValue in SqlDataAdapter
  14. SqlConnection SqlCommand SqlDataReader IDisposable
  15. Check if value exists in dataTable?
  16. SqlBulkCopy from a List
  17. Exception when AddWithValue parameter is NULL
  18. Insert into C# with SQLCommand
  19. Simple way to copy or clone a DataRow?
  20. WHERE IN (array of IDs)
  21. How to fill Dataset with multiple tables?
  22. Copy rows from one Datatable to another DataTable?
  23. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  24. Check if a SQL table exists
  25. Unable to find the requested .Net Framework Data Provider – SQLite
  26. Fastest method for SQL Server inserts, updates, selects
  27. What is the difference between dataview and datatable?
  28. Replacing a DataReader with a DataTable
  29. How to know actual problem because of which SqlException is thrown?
  30. How to give ADO.NET Parameters

Leave a Comment