title: How to update with TableAdapter?
body: <p>I'm writing a program in <code>WindowsApplication</code> which use database.
  I display the database values with <code>DataGridView</code>.
  Currently, I want that there would be a possibility to update the database through the <code>DataGridView</code>, therefore I wrote this code:</p>
  
  <pre><code>    private void MainForm_Load(object sender, EventArgs e)
      {
          // TODO: This line of code loads data into the 'databaseDataSet1.products' table. You can move, or remove it, as needed.
          this.productsTableAdapter1.Fill(this.databaseDataSet1.products);
      }
  
      private void upButton1_Click(object sender, EventArgs e)
      {
          this.productsTableAdapter1.Update(this.databaseDataSet1.products);
          MessageBox.Show("הנתונים עודכנו בהצלחה!");
      }
  </code></pre>
  
  <p>The problem is that there is no update of the values into the database.
  I'll be happy if someone could help me solve this problem, or even better, explain how to work with <code>DataGridView</code>, because I haven't found anything useful on the internet.</p>