title: Compare two datasets in two different data tables using vb.net
body: <p>Please tell me how to compare two datatables in two different datasets.I have got one data table having 5 columns in one data set and another datatable having 2 columns in other dataset. Column 1 in both the data tables should be same. I have to compare 1st column in both the datatables in different datasets. If the both the rows are same it should keep a flag saying yes or no, in the third column in datatable 2. And also it should merge the other columns say 2,3,4 and 5 from datatable 1 in dataset1 to datatable 2 in dataset2.</p>
  
  <p>Both the datatables I am importing the values from excel workbook which are having multiple worksheets. So one worksheet to one datatable. Similarly two workbooks are there.</p>
  
  <p>1st datatable in 1st dataset will be like</p>
  
  <p>A    B    C    D   E</p>
  
  <p>1    2    3     4   5</p>
  
  <p>2    3    4     5   6</p>
  
  <p>3    4    5     6    7</p>
  
  <p>2nd datatable in 2nd dataset will be like</p>
  
  <p>A   F</p>
  
  <p>1   2</p>
  
  <p>2   3</p>
  
  <p>3   4</p>
  
  <p>The output datatable 2 in 2nd dataset should be like</p>
  
  <p>A   B    C   D   E   F   G</p>
  
  <p>1   2    3    4   5   2  YES</p>
  
  <p>2   3    4    5   6   3   YES</p>
  
  <p>3   4    5    6   7   4  YES </p>
  
  <p>Please suggest me how to proceed, I am trying to learn vb.net</p>
  
  <p>Thanks in Advance</p>
  
  <p>Jithin</p>