问题描述
hi
我想剪切datatable上的所有重复行并复制到这样的其他数据表：
datatablefirst：
ID 姓名
123 Joe
123 John
124 Thro
125奥巴马
126 Jenifer
127杰克
127 Arnent
127 Joseph
128麦当娜
129马里
Datatablenonduplicate：
ID 姓名
124 Thro
125奥巴马
126 Jenifer
128麦当娜
129马里
Datatableduplicate：
ID 姓名
123 Joe
123 John
127 Jack
127 Arnent
127 Joseph
hi
I want to cut all duplicated rows on datatable and copy to an other datatable like this:
datatablefirst:
ID Name
123 Joe
123 John
124 Thro
125 Obama
126 Jenifer
127 Jack
127 Arnent
127 Joseph
128 Madonna
129 Mali
Datatablenonduplicate:
ID Name
124 Thro
125 Obama
126 Jenifer
128 Madonna
129 Mali
Datatableduplicate:
ID Name
123 Joe
123 John
127 Jack
127 Arnent
127 Joseph
推荐答案
DataTable table=new DataTable();
//DataTable Datatablenonduplicate = table.Clone();
DataTable Datatableduplicate = table.Clone();
var dupsFromCol = from dr in table.AsEnumerable()
group dr by dr["ID"] into groups
where groups.Count() > 1
select groups;
foreach(var duplicate in dupsFromCol)
{
for(int i=0;i<duplicate.count();i++)>
{
DataRow dr = Datatableduplicate.NewRow();
dr=duplicate.ElementAt(i);
Datatableduplicate.ImportRow(dr);
table.Rows.Remove(dr);
}
}
表将包含唯一行，datatableduplicate包含重复行。
table will contain unique rows and datatableduplicate contain duplicates rows.
with cte
as
(select id,count(id)'Countid' from EMP_TEST1 group by id
)
select E.ID,E.DEPT,E.GrossSalary,E.NAME,E.NetSalary,E.SCM into New_Table from cte c inner join EMP_TEST1 E on E.ID=c.ID where c.Countid>1;
with cte1
as
(select id,count(id)'Countid' from EMP_TEST1 group by id
)
select E.ID,E.DEPT,E.GrossSalary,E.NAME,E.NetSalary,E.SCM into New_Table1 from cte1 c inner join EMP_TEST1 E on E.ID=c.ID where c.Countid=1;
select * from New_Table
select * from New_Table1
这篇关于从数据表csharp中删除重复的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！