C# .NET - how to merge the two dataset without duplicates

hai freinds

I am having two datasets like this:

ds

TBLKEY   EMPKEY    EMPNAME
1                101          RAJA
2                105           POOJA
3                 106            THRIU

ds2
TBLKEY   EMPKEY    EMPNAME
1                101          RAJA
2                105           POOJA
3                 106            THRIU
4         109       karthik
5          110        hari

i shoud get a output in ds like this  here there is no primarykey in any column how to merge this

TBLKEY   EMPKEY    EMPNAME
1                101          RAJA
2                105           POOJA
3                 106            THRIU
4         109       karthik
5          110        hari

I think you have to write your own logic for this....

See this function;

public static DataSet MergeResultSets()
{
 DataSet ds = null;
 int checkCount = 0;
 string rowPosition = "";
 try {
  ds = DAL.DataAcess.Sample(param1, param2);
  for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) {
   for (int j = 0; j <= ds.Tables[1].Rows.Count - 1; j++) {
  if (Equals(ds.Tables[0].Rows[i].ItemArray().Count, ds.Tables[1].Rows[j].ItemArray().Count)) {
   for (int k = 0; k <= ds.Tables[0].Rows[i].ItemArray().Count - 1; k++) {
    if (Equals(ds.Tables[0].Rows[i].ItemArray[k], ds.Tables[1].Rows[j].ItemArray[k])) {
     checkCount = checkCount + 1;
    }
    if (checkCount == ds.Tables[1].Rows[j].ItemArray().Count) {
     rowPosition = rowPosition + j.ToString() + ",";
     checkCount = 0;
    }
   }
   checkCount = 0;
  } else {
   //Throw an exception or delete the row here itself
  }
   }
  }
  Array sa = Strings.Split(rowPosition.TrimEnd(","), ",");
  for (int rp = 0; rp <= sa.Length - 1; rp++) {
   ds.Tables[1].Rows[sa(rp)].Delete();
  }
  ds.Tables[1].AcceptChanges();
  ds.Tables[0].Merge(ds.Tables[1]);
  return ds;
  // this has the two datatables merged as one dataset / datatable
 // without duplicate rows.
 } catch (Exception ex) {
  return null;
 }
}

http://www.codeproject.com/KB/grid/Merging_two_DataSets.aspx

i f i use u r coding it is cuming like dupilcates records not deleted

SerialNo	TblKey	EmpKey	EmpName
1	1	101	RAJA
2	2	105	POOJA
3	3	106	THRIU
4	1	101	Raja
5	2	105	POOJA
6	3	107	Karthik
7	4	108	Hari