如何分类DataTable基于多列？ [英] How to sort DataTable based on multiple column?

问题描述

我有 DataTable

Name  Date
bbb   01/01/2011
bbb   01/01/2012
aaa   01/01/2010
aaa   01/01/2011
bbb   01/01/2013
aaa   01/01/2012
bbb   01/01/2010
ccc   01/01/2010
aaa   01/01/2013
ccc   01/01/2012
ccc   01/01/2011

我需要按名称排序，并按日期排序每个名称： p>

I need sort this table sort by name and every name by date:

Name  Date
aaa   01/01/2010
aaa   01/01/2011
aaa   01/01/2012
aaa   01/01/2013
bbb   01/01/2010
bbb   01/01/2011
bbb   01/01/2012
bbb   01/01/2013
ccc   01/01/2010
ccc   01/01/2011
ccc   01/01/2012

如何在c＃中排序DataTable？

How to sort DataTable in c#?

我尝试过以下操作：

   DataView dv = dt.DefaultView;
   dv.Sort = "col1 desc";
   DataTable sortedDT = dv.ToTable();

但这只排列1列...

but this sort only by 1 column...

推荐答案

http://msdn.microsoft.com/en-us/library/system.data.dataview.sort.aspx

所有您需要做的在dv.Sort行中的列之间添加一个逗号。

All you need to do is add a comma between the columns in the dv.Sort line.

澄清

dv.Sort = "Name, Date";

这篇关于如何分类DataTable基于多列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！