1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
|
public void RemoveDuplicates(DataTable tbl, DataColumn[] keyColumns)
{
int rowNdx = 0;
int k = 0;
while (rowNdx < tbl.Rows.Count - 1)
{
DataRow[] dups = FindDups(tbl, rowNdx, keyColumns);
if (dups.Length > 0)
{
foreach (DataRow dup in dups)
{
k++;
tbl.Rows.Remove(dup);
}
}
else
{
rowNdx++;
}
}
Console.WriteLine("duppppp=+" + k);
}
private DataRow[] FindDups(DataTable tbl,int sourceNdx,DataColumn[] keyColumns)
{
ArrayList retVal = new ArrayList();
DataRow sourceRow = tbl.Rows[sourceNdx];
int k = 0;
for (int i = sourceNdx + 1; i < tbl.Rows.Count; i++)
{
DataRow targetRow = tbl.Rows[i];
if (IsDup(sourceRow, targetRow, keyColumns))
{
retVal.Add(targetRow);
k++;
}
}
Console.WriteLine("duplicate = " + k);
return (DataRow[])retVal.ToArray(typeof(DataRow));
}
private bool IsDup(DataRow sourceRow,DataRow targetRow,DataColumn[] keyColumns)
{
int i = 0;
bool retVal = true;
foreach (DataColumn column in keyColumns)
{
i++;
retVal = retVal && sourceRow[column].Equals(targetRow[column]);
if (!retVal) break;
}
return retVal;
} |
Partager