DataTable tbloriginal = dtStart;
DataTable tblnewset = dtEnd;
IQueryable<DataTable> item = from menu in tbloriginal.AsEnumerable()
from function in tblnewset.AsEnumerable()
where menu.Field<Guid>("Id") == function.Field<Guid>("oneGuid")
orderby menu.Field<int>("age")
select menu;
return item as DataTable;那位大哥帮我看看,这段代码怎么返回datatable....
谢谢了!
DataTable tblnewset = dtEnd;
IQueryable<DataTable> item = from menu in tbloriginal.AsEnumerable()
from function in tblnewset.AsEnumerable()
where menu.Field<Guid>("Id") == function.Field<Guid>("oneGuid")
orderby menu.Field<int>("age")
select menu;
return item as DataTable;那位大哥帮我看看,这段代码怎么返回datatable....
谢谢了!
这句通不过,
var item = from menu in tbloriginal.AsEnumerable()
from function in tblnewset.AsEnumerable()
where menu.Field<Guid>("Id") == function.Field<Guid>("oneGuid")
orderby menu.Field<int>("age")
select menu;
DataTable dt = new DataTable();
foreach (var row in item)
dt.ImportRow(row);
http://msdn.microsoft.com/zh-cn/library/bb396189(v=vs.90).aspx
大哥,select menu就是这个地方,我不会处理.这个地方报错了,就是不知道怎么转换的
DataTable tblnewset = dtEnd;
var query = from menu in tbloriginal.AsEnumerable()
join function in tblnewset.AsEnumerable()
on menu.Field<Guid>("Id") equals function.Field<Guid>("oneGuid")
orderby menu.Field<int>("age")
select menu;DataTable dtResult=query .CopyToDataTable<DataRow>();
修改成 select new{menu,function };
小弟不懂Linq,这句返回类型转换错误,.......