Saving new Data to a Data Set
<p>I have searched and searched.</p>

<p>My application uses a database created with SQL Server Compact Edition.</p>

<p>How can I save data (add new rows only) to the actual database using my application.</p>

<p>Would I insert the code into the saveButton?</p>

<pre><code>    private void saveToolStripMenuItem_Click(obeject sender, EventArgs e)
    {
      EcoDataSet edata = new EcoDataSet();

      EcoDataSetTableAdapters.CustomersTableAdapter cTA =
      new EcoDataSetTableAdapters.CustomersTableAdapter();

      cTA.Fill(edata.Customers);
      cTA.Update(eco.Customers);
    }
</code></pre>

<p>Will that do the trick or should I add a TextChanged event to my DataGridView?</p>
