Monday, January 16, 2012

Merge two DataTables by eliminating duplicate rows

// dtResumeData is the table used to store previous session data
// dtDomainPersonTypeFinal is the table used to store the current session data

for (int x = 0; x < dtResumeData.Rows.Count; x++)
{
for (int y = 0; y < dtDomainPersonTypeFinal.Rows.Count; y++)
{
//if (dtResumeData.Rows[x]["RowNumber"].ToString().Equals(dtDomainPersonTypeFinal.Rows[y]["RowNumber"].ToString()) && dtResumeData.Rows[x]["InformationDomainPersonTypeFieldId"].ToString().Equals(dtDomainPersonTypeFinal.Rows[y]["InformationDomainPersonTypeFieldId"].ToString()))
//{
if (dtResumeData.Rows[x]["PersonTypeID"].ToString().Equals(dtDomainPersonTypeFinal.Rows[y]["PersonTypeID"].ToString()) && dtResumeData.Rows[x]["InformationDomainPersonTypeFieldId"].ToString().Equals(dtDomainPersonTypeFinal.Rows[y]["InformationDomainPersonTypeFieldId"].ToString()))
{
dtDomainPersonTypeFinal.Rows[y].Delete();
y = y - 1;
}
}
}
//dtDomainPersonTypeFinal.Merge(dtResumeData);
dtResumeData.Merge(dtDomainPersonTypeFinal);


// dtResumeData contains the merge data of two tables

No comments:

Post a Comment