sorting datatable based on column index not name of column

Question

I have a DataTable which has 10 columns, I would like to sort the table by a column index 10 from largest to smallest. I know this should be easy for some but this is my first time using such a DataTable

all the website that i have found all say that you have to know the column name but i dont have that and would like to make reference to the column by the index value of the column. which should sort all the rows in that datatble

What problem(s) do you have exactly? What have you tried so far and failed? — Leri
– Leri, Commented Dec 7, 2012 at 11:25
Which ever sit that i have found always just reference to the column name and the data does not sort itself. — Jim Brad
– Jim Brad, Commented Dec 7, 2012 at 11:28
Try DataTable dt = new DataTable(); //Then fill values DataView dv = dt.AsDataView(); dv.Sort = dv.Table.Columns[index].ColumnName + " DESC"; — Anujith
– Anujith, Commented Dec 7, 2012 at 11:29
will this sort the data for the one time or would it keep the sorted data in the same datatable — Jim Brad
– Jim Brad, Commented Dec 7, 2012 at 11:33

Chris Gessler · Accepted Answer · 2012-12-07 12:56:51Z

2

You can use the DefaultView and the ColumnName to sort.

dataTable.DefaultView.Sort = dataTable.Columns[9].ColumnName + " DESC";

Working example:

    DataTable dt = new DataTable();
    //Define columns to DataTable 
    dt.Columns.Add("Id");
    dt.Columns.Add("Name");


    //Adding rows to DataTable 
    DataRow row1 = dt.NewRow();
    row1["ID"] = 1;
    row1["Name"] = "Jack";
    dt.Rows.Add(row1);


    DataRow row2 = dt.NewRow();
    row2["ID"] = 2;
    row2["Name"] = "Fruit";
    dt.Rows.Add(row2);

    DataRow row3 = dt.NewRow();
    row3["ID"] = 3;
    row3["Name"] = "Ball";
    dt.Rows.Add(row3);

    dt.DefaultView.Sort = dt.Columns[1].ColumnName + " ASC";

    foreach (DataRowView drv in dt.DefaultView)
    {
        for (int i = 0; i < dt.Columns.Count; i++)
            Console.WriteLine(drv[i]);
    }

edited Dec 7, 2012 at 12:56

answered Dec 7, 2012 at 11:43

Chris Gessler

23.2k8 gold badges59 silver badges86 bronze badges

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

2 Comments

Jim Brad Over a year ago

will this order the rows of data

Chris Gessler Over a year ago

it sorts the rows in the DefaultView

Anujith · Accepted Answer · 2012-12-07 11:44:08Z

1

Try

DataTable dt = new DataTable(); 
//Then fill values 
DataView dv = dt.AsDataView(); // DataView dv = dt.DefaultView();
dv.Sort = dv.Table.Columns[index].ColumnName + " DESC";
dt = dv.Table;

edited Dec 7, 2012 at 11:44

answered Dec 7, 2012 at 11:32

Anujith

9,3686 gold badges36 silver badges48 bronze badges

3 Comments

Jim Brad Over a year ago

Error Message Can not find column

Mr_Green Over a year ago

@JimBrad Instead of DataView dv = dt.AsDataView(); try DataView dv = new DataView(); dv = dt.DefaultView();

Jim Brad Over a year ago

now it runs the program without any issues but yet it still doesnt sort the data

Collectives™ on Stack Overflow

sorting datatable based on column index not name of column

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related