Sorting a dataTable by date

Hot Topic

Automate PDF reading
Setting the mouse cursor to be different on the system settings
Windows Forms Connection String Encryption
How find function or class of DLL and exe
Custom Action does not run
Keep control form uppermost
Controls move differently when scroll bars appear
NumericUpDown Hex Display Formatting?
Suddenly I'm getting this error: The form referred to itself during construction from a default instance
PropertyGrid - How do I display a custom error message - different from "Property value is not valid"

Windows Forms

Refreshing listboxes
DataGridView - editing a column formatted to display the time part of a datetime field.
How to number displayed rows in DataGridView
File help!
How can I convert a decimal to hexadecimal.
How can I use fonts othern than TrueType and OpenType fonts in Windows Forms
Methods in windows service
Clearing Array's Rows and Column Count
Problem calling event from control
problem of update an item from a listView,urgent, need help!!

Sorting a dataTable by date

Hello everyone,
My problem is that I cannot sort my dataTable by date. I tried to use sorting filters ( with the Select command ) and also using a DataView. But nothing changes.

Is there a way to achieve this programmatically
Best regards.


Answer this question

Sorting a dataTable by date

  • oaix

    Here is my code :
    DataView dataView = dataTable.DefaultView;
    dataView.Sort = "FolderDate";
    //
    // foreach row from the selected data
    //
    foreach (DataRowView dataRow in dataView)
    {
    ....
    }

    What I mean by "nothing changes.." is that the dataView is not sorted.
    Thanks anyway

  • Suresh .M.V

    around 5000


  • mobigital

    Can you check the type of the FolderDate DataColumn Is it a DateTime type or a string type



  • Chidu

    Assuming that you have a DataColumn of the type DateTime named "Date" you can sort as follows:

    DataView dataView = dataTable.DefaultView;
    dataView.Sort = "Date";
    listBox1.DataSource = dataView;

    When you say nothing changes, what exactly are you looking at



  • KnobCreek

    just checked it.. it is DateTime..


  • raja760

    Are there many items in the datatable

  • Taya Cool

    It is possible that the sort is delayed for as long the dataview is not fully initialized. Can you confirm that when you set a breakpoint before the foreach loop construct that the Sort property of the Dataview is set to the date datacolumn

  • Sorting a dataTable by date
Answer this question