title: DataRow: Select cell value by a given column name
body: <p>I have a problem with a DataRow that I'm really struggling with.</p>
  
  <p>The datarow is read in from an Excel spreadsheet using an OleDbConnection.</p>
  
  <p>If I try to select data from the DataRow using the column name, it returns DBNull even though there is data there.</p>
  
  <p>But it's not quite that simple.</p>
  
  <p><code>datarow.Table.Columns[5].ColumnName</code> returns "my column".<br>
  <code>datarow["my column"]</code> returns DBNull.<br>
  <code>datarow[5]</code> returns 500.<br>
  <code>datarow[datarow.Table.Columns[5].ColumnName]</code> returns DBNull. (just to make sure its not a typo!)</p>
  
  <p>I could just select things from the datarow using the column number, but I dislike doing that since if the column ordering changes, the software will break.</p>