110,539
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = new DataTable();
dt.Columns.Add("产品");
dt.Columns.Add("单价");
dt.Rows.Add("1", "111");
dt.Rows.Add("2", "222");
DataTable dt2 = new DataTable();
dt2.Columns.Add("产品");
dt2.Columns.Add("订购数量");
dt2.Columns.Add("总金额");
dt2.Rows.Add("1", "11", "1111");
dt2.Rows.Add("2", "22", "2222");
var query = from t1 in dt.AsEnumerable()
from t2 in dt2.AsEnumerable()
where t1.Field<string>("产品").Equals(t2.Field<string>("产品"))
select new
{
产品 = t1.Field<string>("产品"),
单价 = t1.Field<string>("单价"),
订购数量 = t2.Field<string>("订购数量"),
总金额 = t2.Field<string>("总金额")
};
DataSet ds = new DataSet();
ds.Locale = CultureInfo.InvariantCulture;
FillDataSet(ds);
DataTable orders = ds.Tables["SalesOrderHeader"];
DataTable details = ds.Tables["SalesOrderDetail"];
var query =
from order in orders.AsEnumerable()
join detail in details.AsEnumerable()
on order.Field<int>("SalesOrderID") equals
detail.Field<int>("SalesOrderID")
where order.Field<bool>("OnlineOrderFlag") == true
&& order.Field<DateTime>("OrderDate").Month == 8
select new
{
SalesOrderID =
order.Field<int>("SalesOrderID"),
SalesOrderDetailID =
detail.Field<int>("SalesOrderDetailID"),
OrderDate =
order.Field<DateTime>("OrderDate"),
ProductID =
detail.Field<int>("ProductID")
};
DataTable orderTable = query.CopyToDataTable();