How to sort a DataGridView Column?

Question

I've created a DataTable as follows:

        accTable = new DataTable();
        accTable.Columns.Add(new DataColumn("Date"));
        accTable.Columns.Add(new DataColumn("Amt"));
        accTable.Columns.Add(new DataColumn("Item"));

and filling it by:

            foreach (DataRow myDataRow in myDataSet.Tables[0].Rows)
            {
                DataRow accRow = accTable.NewRow();
                //code skipped

                accRow["Date"] = date.ToString("d"); //tried without converting to string also
                accRow["Amt"] = int.Parse(cells[1].ToString());
                accRow["Item"] = cells[2].ToString();

                accTable.Rows.Add(accRow);
            }

Then I'm binding a DataGridView to the DataTable accTable as follows:

            dataGridView1.DataSource = accTable;

How can I make the Date column sortable. By default, it is sorting alphabetically. Where can I set the type of the column to DateTime.

ChrisF · Accepted Answer · 2009-05-13 11:36:49Z

5

The column has a DataType. Have you tried setting that to DateTime?

var accTable = new DataTable();

var columnSpec = new DataColumn("Date");
columnSpec.DataType = typeof(DateTime);
accTable.Columns.Add(columnSpec);

Of course you can do this on one line (thanks to BFree):

accTable.Columns.Add("Date",typeof(DateTime));

You bind this DataTable to a DataGridView and then for each column on the view set the SortMode property:

column.SortMode = DataGridViewColumnSortMode.Automatic;

I did have some code that did all this, but I converted it to use nullable types (including the DateTime fields) and it's not working as I expected any more. If I can get it working properly again I'll update this answer.

edited May 13, 2009 at 11:36

answered May 13, 2009 at 10:35

ChrisF

138k31 gold badges265 silver badges335 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Milen Over a year ago

It worked! Thanks I didb't know abt how the type property could be assigned!

ChrisF Over a year ago

All I need to do now is work out how to get the underlying type from my nullable type.

BFree Over a year ago

Just a small point; you can do this all in one line: accTable.Columns.Add("Date",typeof(DateTime));

ChrisF Over a year ago

@BFree - true you can - I was just highlighting the Property

Chris · Accepted Answer · 2017-08-12 11:11:42Z

-1

For date data, we can use the following code:

dgv_transfer_from.Sort(dgv_transfer_from.Columns["Date_Out"], ListSortDirection.Ascending);

edited Aug 12, 2017 at 11:11

Chris

1,64319 silver badges26 bronze badges

answered Aug 12, 2017 at 7:08

Ahmad Hassan

537 bronze badges

Collectives™ on Stack Overflow

How to sort a DataGridView Column?

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related