110,566
社区成员
发帖
与我相关
我的任务
分享
var list = from t in dataset.Tables["datasetB"].AsEnumerable() select t["Id"];
//Id为数字类型的话
var ids = string.Join(",",list);
var rows = dataset.Tables["datasetA"].Select("ID not in (" + ids + ")");
//Id为字符类型的话
var ids = string.Join("','",list);
var rows = dataset.Tables["datasetA"].Select("ID not in ('" + ids + "')");