Is it possible to format a date column of a datatable?

by

The smartest thing to do would be to make sure your DataTable is typed, and this column is of type DateTime. Then when you go to actually print the values to the screen, you can set the format at that point without mucking with the underlying data.

If that’s not feasible, here’s an extension method I use often:

public static void Convert<T>(this DataColumn column, Func<object, T> conversion)
{
    foreach(DataRow row in column.Table.Rows)
    {
        row[column] = conversion(row[column]);
    }
}

You could use in your situation like:

myTable.Columns["DateOfOrder"].Convert(
    val => DateTime.Parse(val.ToString()).ToString("dd/MMM/yyyy"));

It only works on untyped DataTables (e.g. the column type needs to be object, or possibly string).

More Related Contents:

  1. How to use Select method of DataTable
  2. Convert generic List/Enumerable to DataTable?
  3. How to read a CSV file into a .NET Datatable
  4. Convert JSON to DataTable
  5. Convert IEnumerable to DataTable
  6. Inner join of DataTables in C#
  7. How To Change DataType of a DataColumn in a DataTable?
  8. Best way to remove duplicate entries from a data table
  9. How I can filter a Datatable?
  10. How to select min and max values of a column in a datatable?
  11. How to bind DataTable to Datagrid
  12. Compare two DataTables to determine rows in one but not the other
  13. Export DataTable to Excel File
  14. How to compare 2 dataTables
  15. How to create a DataTable in C# and how to add rows?
  16. Convert DataTable to generic List?
  17. DataTable, How to conditionally delete rows
  18. DataTable equivalent in Java [duplicate]
  19. Data is visible in DataSet visualizer but does not show in a DataGrid
  20. Best way to check if a Data Table has a null value in it
  21. Datatable to html Table
  22. Best Practice: Convert LINQ Query result to a DataTable without looping
  23. Get Cell Value from a DataTable in C#
  24. How to change DataTable columns order
  25. How do I loop through rows with a data reader in C#?
  26. How do I create a DataTable, then add rows to it?
  27. Returning DataTables in WCF/.NET
  28. Replacing a DataReader with a DataTable
  29. How to make C# DataTable filter
  30. Convert DataTable to Generic List in C#

Leave a Comment