///
<summary>
///
获取对固定列不重复的新DataTable
///
</summary>
///
<param name="dt">
含有重复数据的DataTable
</param>
///
<param name="colName">
需要验证重复的列名
</param>
///
<returns>
新的DataTable,colName列不重复
</returns>
private
DataTable GetDistinctTable(DataTable dt,
string
colName) { DataView dv
=
dt.DefaultView; DataTable dtCardNo
=
dv.ToTable(
true
, colName); DataTable Pointdt
=
new
DataTable(); Pointdt
=
dv.ToTable(); Pointdt.Clear();
for
(
int
i
=
0
; i
<
dtCardNo.Rows.Count; i ) { DataRow dr
=
dt.Select( colName
+
"
='
"
+
dtCardNo.Rows[ i ][
0
].ToString( )
+
"
'
"
)[
0
]; Pointdt.Rows.Add(dr.ItemArray); }
return
Pointdt; }
转载于:https://www.cnblogs.com/Mr0909/archive/2011/05/09/2041534.html
转载请注明原文地址: https://mac.8miu.com/read-26770.html