title: how can I add values into a new data table column in the existing rows
body: <p>Here Is my problem. I am trying to take the Full Name field of my data table and split the name into first and last then add those names back into my data table in their correct positions. So far this is what I have. </p>
  
  <pre><code>DataTable DBTable = LoadMailingListContent(Location);
  
  List&lt;string&gt; fullNames = DBTable.Rows.OfType&lt;DataRow&gt;().Select(dr =&gt; dr.Field&lt;string&gt;(columnName)).ToList();
  
  DBTable.Columns.Remove(columnName);
  
  DBTable.Columns.Add("First Name");
  DBTable.Columns.Add("Last Name");
  
  foreach (string fullname in fullNames)
  {
      var names = fullname.Split(' ');
      string firstName = names[0];
      string lastName = names[1];
  
      //here is where I want to add the new name values into their new fields
  }
  </code></pre>
  
  <p>Could I set a counter inside my foreach loop and add the names back in depending on the index of the row? I need help on how to add the new first and last name values back into my new fields. </p>
  
  <p>thanks</p>