title: When inserting new columns in a datatable in VB 2010, how do I update the SQL Server 2008 Database?
body: <p>Using VB 2010 and SQL Server 2008:</p>
  
  <p>I am able to insert new rows, delete rows, and update data in a datatable, and use a data adapter to update the database without any issues. When I try to add new columns, the column appears in the data table, but it does not update to the database. I currently am using the DataAdapter.Update(DataTable) Method.</p>
  
  <p>My code is as follows:</p>
  
  <pre><code>Dim dcNewColumn As New DataColumn
  dcNewColumn.ColumnName = strClassColumnName
  m_DataTable.Columns.Add(dcNewColumn)
  m_DataTable.Row(intCurrentRow).Item(strClassColumnName) = strClassName
  dcNewColumn = Nothing
  
  m_DA.Update(m_DataTable)
  </code></pre>
  
  <p>Is there a different method to updating the database when inserting new columns?</p>