title: How update a SQL table from a modified datatable?
body: <p>I used the DataSet Designer to create FTWDataSet which holds the AlarmText table from a SQLExpress database.  This far my form contains ONLY Datagridview1.  The code below successfully shows the contents of the AlarmText table plus the one added checkbox column (which I will populate with display-only data, and is not an issue here).</p>
  
  <pre><code>    Dim ta As New FTWDataSetTableAdapters.AlarmTextTableAdapter
      Dim dt As New FTWDataSet.AlarmTextDataTable
      ta.Fill(dt)
      DataGridView1.DataSource = dt
  
      'create a new Bool column in the datatable
      dt.Columns.Add("NewCol", (New Boolean).GetType)
  </code></pre>
  
  <p>What else do I need to do to use the DataGridView to edit and save values in the AlarmText table?</p>