title: Compare two datatable and set its value
body: <p>i have 2 datatable which i only need to compare one column cell value. check if it equals then get the cell value of dt2 and set it on dt. here what i got so far. it is working as expected but took a long time doing so because of its large entries from both datatable.</p>
  
  <pre><code>foreach (DataRow row in dt.Rows)
  {
      foreach (DataRow row2 in dt2.Rows)
      {
          if (row[0].ToString().Equals(row2[0].ToString()))
          {
              row[1] = row2[1];
              row[68] = row2[59];
          }
      }
  }
  </code></pre>
  
  <p>how do i increase the performance for this? i am not experience enough to use and knowing about linq or others..any example that working the same way as this would be appreciate. thank you</p>