title: How to insert into my sql table in wpf using Dataset
body: <p>I was wondering what would be the best way to insert a row into my sql table through WPF application window.
  I have two wpf <code>DataGrid</code>s in my application, and I want the user to be able to push a button and insert data into the grid from there (inserting data into the sql table and refresh the grid when the user closes the pop-up window after inserting).
  I´m using a <code>DataSet</code> database model and running .sdf database inside my application.</p>
  
  <p>I´m using a <code>TableAdapter</code> to fill my <code>DataGrid</code>:</p>
  
  <pre><code>    HomeApplication.TheHomeApplicationDBDataSet theHomeApplicationDBDataSet;
      HomeApplication.TheHomeApplicationDBDataSetTableAdapters.AccountingTableAdapter  homeApplicationDataSetAccountingTableAdapter;
  </code></pre>
  
  <p>What is the best way to do this?
  Any ideas would help. thx :)</p>