谁知道dt.DefaultView.Sort为什么对我不起作用? [英] Anyone knows why dt.DefaultView.Sort is not working for me?

问题描述

我有一个字符串类型的数据表.我想按ID对表格进行排序.我尝试了很多方法而没有成功.唯一可行的方法是使用arraylist，如下所示:

I have a data table which is a string type. I want to sort my table by the ID. I tried so many ways without be succesful. The only way that worked was using an arraylist as follow:

for ( int x= 0; x<dt.Rows.Count; x++)
{ int.TryParse(dt.Rows[x][0].ToString(), out obj1);
  table.Add(obj1); }
table.Sort();

(但它只给我ID排序)

我使用过的内容如下:

(But it only give to me the ID sorted)

Following that I used:

dt.DefaultView.Sort = dt.Columns[0].ColumnName + " asc";

却给了我
ID Col1 Col2 Col3 Col4
1 a b c d
2 i j k l
3百万n

4 q r s t
1 e f g h

知道default.sort为什么不能正常工作的任何想法:confused:

But is giving to me
ID Col1 Col2 Col3 Col4
1 a b c d
2 i j k l
3 m n o p
4 q r s t
1 e f g h

Any idea why default.sort is not working properly :confused:

推荐答案

您的代码不起作用，因为当您尝试对表进行排序时，实际上是数据视图.您的桌子并没有真正改变.
因此，您可以对DataView进行排序并将其用于向用户显示数据.
祝你好运！

Your code doesn''t work because when you trying to sort your table, you actually sorting the DataView. Your table doesn''t really change.
So, you can sort DataView and use it to present data to the user.
Good luck!

DataTable dt = new DataTable();
dt.Columns.Add("ID",typeof(string));
dt.Columns.Add("Name", typeof(string));
dt.Rows.Add(new object[] { "1", "one" });
dt.Rows.Add(new object[] { "5", "five" });
dt.Rows.Add(new object[] { "2", "two" });
dt.Rows.Add(new object[] { "4", "four" });
dt.Rows.Add(new object[] { "7", "seven" });

DataView dv = dt.AsDataView();
dv.Sort = "ID ASC";

foreach (DataRow row in dv.ToTable().Rows)
{
    Console.WriteLine(row[0] + "\t" + row[1]);
}
Console.ReadKey();

tdt.DefaultView.Sort = e.SortExpression + " " + GetSortDirection(e.SortExpression);
                CommonFuncs.display_grid(this.grvEmployee, tdt);

                DataTable tempdt = new DataTable();
                tempdt = tdt.DefaultView.ToTable();
                tdt.Clear();
                tdt = tempdt.DefaultView.ToTable();

这篇关于谁知道dt.DefaultView.Sort为什么对我不起作用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！