DataTable排序

原文链接：https://blog.csdn.net/u011511086/article/details/124887165

DataTable dataTable = new DataTable();
dataTable.Columns.Add("id");
dataTable.Columns.Add("name");
dataTable.Columns.Add("weight");
dataTable.Columns.Add("birthday");
dataTable.Rows.Add(new object[]{ "1","欧阳修","56",DateTime.Parse("1992-02-26")});
dataTable.Rows.Add(new object[]{ "3","武松","22",DateTime.Parse("1987-11-15")});
dataTable.Rows.Add(new object[]{ "9","李斯","33",DateTime.Parse("1975-06-11")});
dataTable.Rows.Add(new object[]{ "5","赵武","99",DateTime.Parse("1979-08-25")});

//DataTable排序，方式一
DataTable dataView = dataTable.Rows.Cast<DataRow>().OrderBy(r => r[2]).CopyToDataTable();
DataTable dataView2 = dataTable.Rows.Cast<DataRow>().OrderBy(r => r[3]).CopyToDataTable();
DataTable dataView3 = dataTable.Rows.Cast<DataRow>().OrderByDescending(r => r[0]).CopyToDataTable();

//排序，方式二
dataTable.DefaultView.Sort = "id asc";
var dv = dataTable.DefaultView.ToTable();