8,497
社区成员
发帖
与我相关
我的任务
分享
var result = from p in A1
from q in A2
select new {
o1=p.o,
q1=p.q,
o2=q.o,
q2=q.q
}
DataTable q = TestBLL.GetDt();
DataTable q1 = TestBLL.GetDt();
//不去重
DataTable v = q.AsEnumerable().Union(q1.AsEnumerable()).CopyToDataTable();
//去重 a,b,c列名
DataTable v1 = q.AsEnumerable().Union(q1.AsEnumerable()).CopyToDataTable().DefaultView.ToTable(true, "a","b","c");
public class 类名称Comparer : IEqualityComparer<类>
{
public bool Equals(类 x, 类 y)
{
if (Object.ReferenceEquals(x, y)) return true;
return x != null && y != null && x.id.Equals(y.id) && x.name.Equals(y.name);
}
public int GetHashCode(Student obj)
{
int hashProductName = obj.id == null ? 0 : obj.id.GetHashCode();
int hashProductCode = obj.name.GetHashCode();
return hashProductName ^ hashProductCode;
}
}
Union的时候,类似:
x1.Union(x2, new 类名称Comparer ());