如何使用 C# 按日期升序对我创建的数据表进行排序



我正在学习c#以帮助我作为RPA开发人员的日常工作。因此,我创建了一个具有DateTime类型列的数据表,我试图将表按升序日期排序,因为我最终想在表中取出具有以最新日期的"E"开头的"收据号"的条目。

这是我的代码DataTable Receipts = new DataTable();

Receipts.Clear(); 
Receipts.Columns.Add("Date", typeof(DateTime));
Receipts.DefaultView.Sort = "Date ";
Receipts.Columns.Add("Receipt Data", typeof(string));
DataRow dr = Receipts.NewRow(); 
dr[0] = "10 January 2021"; 
dr[1] = "Receipt number is E1039742083";
Receipts.Rows.Add(dr); 
dr = Receipts.NewRow(); 
dr[0] = "11 January 2021"; 
dr[1] = "Receipt number is not found";
Receipts.Rows.Add(dr); 
dr = Receipts.NewRow(); 
dr[0] = "11 January 2021"; 
dr[1] = "Receipt number is F1039742083";
Receipts.Rows.Add(dr); 
dr = Receipts.NewRow(); 
dr[0] = "12 January 2021"; 
dr[1] = "Receipt number is E1039742083";
Receipts.Rows.Add(dr); 
dr = Receipts.NewRow(); 
dr[0] = "12 January 2021"; 
dr[1] = "Receipt number is not found";
Receipts.Rows.Add(dr); 
Receipts.DefaultView.Sort = "Date ASC";
foreach (DataRow datarow in Receipts.Rows)
{
foreach (var item in datarow.ItemArray)
Console.WriteLine(item);
} }

但这一行似乎不工作Receipts.DefaultView.Sort = "Date ASC";当它在visual studio中运行时,总是以最老的日期为优先

如有任何建议,不胜感激

感谢约旦

Receipts.DefaultView.Sort = "Date ASC";
Receipts= Receipts.DefaultView.ToTable();

在这里找到- DataTable.DefaultView.Sort没有't Sort

最新更新