title: Database isn't updating
body: <p>I am trying to write some data into a .MDF database that has only one table, and it's not updating after I execute this part of the code:</p>
  
  <pre><code>        DatabaseDataSet.MyTableRow newRow;
          newRow = databaseDataSet.MyTable.NewMyTableRow();
          newRow.name = "x";
          newRow.level = 100;
          newRow.health = 100;
          newRow.weapon = "club";
          this.databaseDataSet.MyTable.Rows.Add(newRow);
  
          int result = MyTableTableAdapter.Update(databaseDataSet.MyTable);
          MessageBox.Show(result.ToString());
  </code></pre>
  
  <p>I am new to working with SQL databases in C#.</p>
  
  <p>I'm using <code>TableAdapter.Update</code> to update the <code>MyTable</code> table in the database, I even tried writing my own query version of Update, and I also tried with the <code>MyTableAdapter.insert</code> function...and no results. I can successfully read data from a database, but when it comes to writing, I fail hard.</p>