title: Column Name does not match with any column in datasource
body: <p>I have below data table :-</p>
  
  <p><a href="https://i.stack.imgur.com/8EFOX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8EFOX.jpg" alt="enter image description here"></a></p>
  
  <p>I have below SQL table as <code>Product</code>:</p>
  
  <p><a href="https://i.stack.imgur.com/9wLm8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9wLm8.jpg" alt="enter image description here"></a></p>
  
  <p>ITEM CODE from data table is <code>ProductCode</code> in SQL.</p>
  
  <p>CLOSING (Last column in image) from data table is <code>Quantity</code> in SQL.</p>
  
  <p>I wanted to update ITEM CODE against CLOSING (Quantity) in SQL.</p>
  
  <p>I wrote this bulk update function:</p>
  
  <pre><code>using (SqlBulkCopy bcSQL = new SqlBulkCopy(con))
  {
      bcSQL.DestinationTableName = "Product";
  
      // Map Source column name to Destination Column name
      // Src Column is in your DataTable
      // Dest Column is column name available in your SQL Table
      bcSQL.ColumnMappings.Add(" ITEM CODE", "ProductCode");
      bcSQL.ColumnMappings.Add(" Closing", "Quantity");
  
      bcSQL.WriteToServer(dt);
  }
  </code></pre>
  
  <p>But I get this error:</p>
  
  <blockquote>
    <p>The given ColumnName ' ITEM CODE' does not match up with any column in data source.</p>
  </blockquote>
  
  <p>Please help - how can I resolve this?</p>