110,534
社区成员
发帖
与我相关
我的任务
分享
//LINQ to DataSet,不知道楼主的环境能不能支持
//取出dataTable1中不在date1和date2之间的数据
var query1 = from oneItem in dataTable1.AsEnumerable()
where oneItem.Field<DateTime>("Time") < date1 && oneItem.Field<DateTime>("Time") > date2//假设date1<date2
select oneItem;
//取出dataTable2中的customer字段数据
var query2 = from oneItem in dataTable2.AsEnumerable()
select oneItem.Field<string>("customer");//需要将string类型换成customer字段实际的类型
//最终结果
var result = from oneItem in query1
where !query2.Contains<string>(oneItem.oneItem.Field<string>("customer"))
select oneItem;
DataView view = new DataView();
view.Table = DataSet1.Tables["dataTable1"];
view.RowFilter = "dt not between date1 and date2";