title: Select and updating data from datatable
body: <p>I select data from my datatable, by using following code:</p>
  
  <pre><code>DataRow[] result = table.Select("Size &gt;= 230 AND Sex = 'm'");
  </code></pre>
  
  <p>Now I change the data in the datarow-array result and I want to update my datatable (datatable should get the changes). Which is the easiest way to do that?</p>
  
  <p>In VB6 I could simply set a filter, on the recordset, edit my rows and simply save my changes. Is there a similar way using DataTables?</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p>I have an additional question. What, if I wanna add a new row and I want to reuse the same code?</p>
  
  <p>For example like that:</p>
  
  <pre><code>filteredRows = myDataset.Tables[0].Select("select where id = 1");
  if (filteredRow.Lenght == 0) {
  filteredRows = myDataset.Tables[0].NewRow();
  }
  // I wanna use this code, no matter if I edit a row, or if it is a new row.
  filteredRows[index]["Name"] = "Max";
  filteredRows[index]["Address"] = "Random Address";
  filteredRows[index]["WhatEver"] = "...";
  //...
  </code></pre>
  
  <p>I tried this way, but it doesn't affect the original dataset.</p>