title: Reading textfile parsing rows into a Datatable
body: <p>I want to read a text file and parse each row into a datable.</p>
  
  <p>The way I'd like the data stored in datatable is with the type for each column set as well i.e.
  int, varchar, date etc.</p>
  
  <pre><code>DataTable data = new DataTable();
  data.Columns.Add("code", typeof(int));
  data.Columns.Add("description", typeof(string));
  data.Columns.Add("value", typeof(decimal));
  </code></pre>
  
  <p>but then when I am reading the textfile with columns tab delimited, how could I ensure the correct columns in the text file go into the right columns in the datatable.</p>
  
  <p>Because my ultimate aim is to get this datatable into a sql server table with the same columns and types using sqlbulkcopy.</p>