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

Question

作为一名C#开发人员，我正在学习RPA来帮助我完成日常工作。因此，我创建了一个具有DateTime类型列的数据表，并尝试按升序对表进行排序，因为我最终希望从表中取出'Receipt Number‘以'E’开头的最新日期的条目。

这是我的代码新收据= DataTable 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中运行时，它总是首先运行最早的日期。

如有任何建议，我们将不胜感激。

谢谢

乔丹

Answer 1

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

请在此处找到- DataTable.DefaultView.Sort Doesn't Sort