title: Unable to save changes to dataset
body: <p>I have a dataSource added to my C# project, it only has a few columns and the user will be inputting data and adding rows to the database, and will also be able to search for certain rows. I am unable to save any changes. The changes appear in my <code>DataGridView</code> when I press the add button but when I re-start my program (I built and exported it btw, not in debug mode) the changes from before are not there. Why is this?</p>
  
  <pre><code> //called when the new entry button is clicked, adds new row into DB
      private void CreatEnrtyBtn_Click(object sender, EventArgs e)
      {
          //Create new row to construct
          BettingDB1DataSet.HorsesRow row = bettingDB1DataSet.Horses.NewHorsesRow();
  
          //Add values to row
          row.HorseName = this.HorseNameBox.Text;
          row.Trainer = this.TrainerNameBox.Text;
          row.Place = this.PlaceBox.Text;
          row.Location = this.LocationBox.Text;
          row.Jockey = this.JockeyNameBox.Text;
          row.Track = this.LocationBox.Text;
          row.Ground = "temp";
  
          //Add row to DB and commit changes
          bettingDB1DataSet.Horses.AddHorsesRow(row);
  
          //tried both of these on their own, but neither work?
          horsesTableAdapter.Update(bettingDB1DataSet.Horses);
          horsesTableAdapter.Update(row);
      }
  </code></pre>
  
  <p>How horsesTableAdapter is created, as requested:</p>
  
  <pre><code>        private BettingDB1DataSetTableAdapters.HorsesTableAdapter horsesAdapter;
  
  
      public Form1()
      {
          InitializeComponent();
      }
  
      private void Form1_Load(object sender, EventArgs e)
      {
          // TODO: This line of code loads data into the 'bettingDB1DataSet2.Horses' table. You can move, or remove it, as needed.
          this.horsesTableAdapter.Fill(this.bettingDB1DataSet2.Horses);
          this.dataGridView1.DataSource = bettingDB1DataSet.Horses;
  
      }
  </code></pre>