sort datatable by a field

Question

  var course = from b in DbModle.courses
                            where b.name == "test"
                            select b;

    DataTable dt = new DataTable();
    DataRow dr;
    dt.Columns.Add(new DataColumn("name", typeof(string)));
    dt.Columns.Add(new DataColumn("id", typeof(int)));
    foreach (var course1 in course_university)
    {
        dr = dt.NewRow();
        dr[0] = course1.name;
        dr[1] = course1.id;
        dt.Rows.Add(dr);
    }

How can I sort DataTable by id?

score 5 · Answer 1 · answered Mar 22 '12 at 21:19

5

Try using this:

dt.DefaultView.Sort = "id";
DataView dv = dt.DefaultView;

foreach (var row in dv) {  
   //. . .
}

answered Mar 22 '12 at 21:19

ionden

12,536
1
45
37

score 4 · Accepted Answer · answered Mar 22 '12 at 21:21

4

DataTables cannot be sorted directly, but you can create a DataView of the table with a specific sort order.

var view = new DataView(dt) { Sort = "id" };

answered Mar 22 '12 at 21:21

Christian Hayter

30,581
6
72
99

score 1 · Answer 3 · answered Mar 22 '12 at 21:28

1

Why not sort in your original query?

var courses = from c in DbModel.courses
              where c.Name == "test"
              orderby c.ID
              select c;

var dt = new DataTable();
dt.Columns.Add(new DataColumn("name", typeof(string)));
dt.Columns.Add(new DataColumn("id", typeof(int)));

foreach (var course in courses)
{
    var dr = dt.NewRow();
    dr[0] = course1.name;
    dr[1] = course1.id;
    dt.Rows.Add(dr);
}

answered Mar 22 '12 at 21:28

Duane Theriot

2,135
1
13
16

how can do this?write a example – user1263390 Mar 22 '12 at 21:29
Check out the orderby line in the LINQ query. – Duane Theriot Mar 22 '12 at 21:32

score 0 · Answer 4 · answered Mar 22 '12 at 21:28

0

If you're using DataTableExtensions and DataRowExtensions:

var view = dt.AsEnumerable().OrderBy(c=>c.Field<int>("id")).AsDataView();

answered Mar 22 '12 at 21:28

code4life

15,655
7
50
82

sort datatable by a field

4 Answers4