DataTable的排序方法

kingwebo'sZone

已于 2022-10-19 14:57:29 修改

阅读量1.4k

点赞数 1

分类专栏：关于程序文章标签：数据库 python sql

于 2022-10-19 14:55:20 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_40029679/article/details/127408139

版权

关于程序专栏收录该内容

422 篇文章

订阅专栏

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";//列名或者列抬头l另一种方式'desc'
var dv = dataTable.DefaultView.ToTable();

 DataTable DTCopy = DGVDT.Copy();--拷贝原表
            DataView DTView = DGVDT.DefaultView;//创建view
            DTView.Sort = "总分 desc";//以总分列 倒叙排列
            DTCopy = DTView.ToTable();//导出到对应表格
            DGV.DataSource = DTCopy;