我正在学习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