#region datatable去重
/// <summary>
/// datatable去重
/// </summary>
/// <param>需要去重的datatable
/// <param>依据哪些列去重
/// <returns></returns>
public static DataTable GetDistinctTable(DataTable dtSource, params string[] columnNames)
{
DataTable distinctTable = dtSource.Clone();
try
{
if (dtSource != null && dtSource.Rows.Count > 0)
{
DataView dv = new DataView(dtSource);
distinctTable = dv.ToTable(true, columnNames);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
return distinctTable;
}
/// <summary>
/// datatable去重
/// </summary>
/// <param>需要去重的datatable
/// <returns></returns>
public static DataTable GetDistinctTable(DataTable dtSource)
{
DataTable distinctTable = null;
try
{
if (dtSource != null && dtSource.Rows.Count > 0)
{
string[] columnNames = GetTableColumnName(dtSource);
DataView dv = new DataView(dtSource);
distinctTable = dv.ToTable(true, columnNames);
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
}
return distinctTable;
}
#endregion
#region 获取表中所有列名
public static string[] GetTableColumnName(DataTable dt)
{
string cols = string.Empty;
for (int i = 0; i <p>以上就是<a style="color:#f60; text-decoration:underline;" title="c#" href="https://m.php.cn/zt/33388.html" target="_blank">c#</a> datatable中重复数据去重的内容,更多相关内容请关注php中文网(www.php.cn)!</p><p><br></p><div class="aritcle_card flexRow artxards">
<div class="artcardd flexRow">
<a class="aritcle_card_img" rel="nofollow" href="/xiazai/skill2795" title="C#"><img
src="https://img.php.cn/upload/skill/000/000/081/178936933912641.jpg" alt="C#" onerror="this.onerror='';this.src='/static/lhimages/moren/morentu.png'" ></a>
<div class="aritcle_card_info flexColumn">
<a rel="nofollow" href="/xiazai/skill2795" title="C#" class="overflowclass">C#</a>
<p class="overflowclass">"避开 C# 常见错误——空陷阱、异步陷阱、LINQ 陷阱及资源泄漏。"</p>
</div>
<a rel="nofollow" href="/xiazai/skill2795" title="C#" class="aritcle_card_btn flexRow flexcenter"><b></b><span>下载</span>
</a>
</div>
</div>