将 Linq 的结果复制到 DataTable 中
我需要做出哪些改变才能以更少的线路和更好的方法来减少完成这项任务的时间。
DataTable dtStatusMsgs;
var statusList = (
from items in dtInputTable.AsEnumerable()
where items.Field<int>("DepartmentId") == deptId
select new
{
statusId = items.Field<int>("StatusId"),
status = items.Field<string>("Status"),
statusOrder = items.Field<int>("StatusSortOrder"),
rowId = items.Field<int>("RowId")
}).Distinct();
dtStatusMsgs = new DataTable();
dtStatusMsgs.Columns.Add("StatusId", typeof(int));
dtStatusMsgs.Columns.Add("Status", typeof(string));
dtStatusMsgs.Columns.Add("StatusSortOrder", typeof(int));
dtStatusMsgs.Columns.Add("RowId", typeof(int));
foreach (var item in statusList)
dtStatusMsgs.Rows.Add(item.statusId, item.status,item.statusOrder
, item.rowId);
我希望它能做到这样的事情。
DataTable dtStatusMsgs;
var statusList = (
from items in dtInputTable.AsEnumerable()
where items.Field<int>("DepartmentId") == deptId
select new
{
statusId = items.Field<int>("StatusId"),
status = items.Field<string>("Status"),
statusOrder = items.Field<int>("StatusSortOrder"),
rowId = items.Field<int>("RowId")
}).Distinct();
dtStatusMsgs= statusList.CopyToDataTable<DataRow>();
以及如何在此代码中的任何列上使用 Sum 函数。 我想查看有关应用任何聚合函数的示例代码
What changes do i need to make so as to reduce of doing this task with fewer lines and better approach.
DataTable dtStatusMsgs;
var statusList = (
from items in dtInputTable.AsEnumerable()
where items.Field<int>("DepartmentId") == deptId
select new
{
statusId = items.Field<int>("StatusId"),
status = items.Field<string>("Status"),
statusOrder = items.Field<int>("StatusSortOrder"),
rowId = items.Field<int>("RowId")
}).Distinct();
dtStatusMsgs = new DataTable();
dtStatusMsgs.Columns.Add("StatusId", typeof(int));
dtStatusMsgs.Columns.Add("Status", typeof(string));
dtStatusMsgs.Columns.Add("StatusSortOrder", typeof(int));
dtStatusMsgs.Columns.Add("RowId", typeof(int));
foreach (var item in statusList)
dtStatusMsgs.Rows.Add(item.statusId, item.status,item.statusOrder
, item.rowId);
I want it to be done something like this.
DataTable dtStatusMsgs;
var statusList = (
from items in dtInputTable.AsEnumerable()
where items.Field<int>("DepartmentId") == deptId
select new
{
statusId = items.Field<int>("StatusId"),
status = items.Field<string>("Status"),
statusOrder = items.Field<int>("StatusSortOrder"),
rowId = items.Field<int>("RowId")
}).Distinct();
dtStatusMsgs= statusList.CopyToDataTable<DataRow>();
And how to use Sum function on any of the column in this code.
I want to see a sample code on this for applying any aggregate function
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)