title: DataAdapter.Update() does not Update the Database
body: <p>I'm sure there is an extremely simple reason that this one line isn't working, but it has evaded for the past week, so I'm hoping someone else will notice my fault.</p>
  
  <p>I have been working on this project for several weeks to a month. I have been using a mix of old DataAdapter, CommandBuiler, etc. with some linq to sql coding on 1 database, with multiple windows application forms. This particular form Edits or Deletes rows from the Database using a DataAdapter, Dataset, and Command Builder. It has been working fine, until I switched computers. Now the Dataset is being updated, but the Database is not.</p>
  
  <p>Here is the full code of this form:</p>
  
  <pre><code>private void exitToolStripMenuItem_Click(object sender, EventArgs e)
  {
      if (MessageBox.Show("Exit Cook Book?", "Exit?", MessageBoxButtons.OKCancel) == DialogResult.OK)
      {
          Application.Exit();
      }
  }
  
  private void goBackToolStripMenuItem_Click(object sender, EventArgs e)
  {
      AddRecipe goBack = new AddRecipe();
  
      Close();
      goBack.Show();
  }
  
  private void helpToolStripMenuItem_Click(object sender, EventArgs e)
  {
      MessageBox.Show("Scan through the Cook Book to find recipes that you wish to edit or delete.", "Help!");
  }
  
  SqlConnection con;
  SqlDataAdapter dataAdapt;
  DataSet dataRecipe;
  SqlCommandBuilder cb;
  
  int MaxRows = 0;
  int inc = 0;
  
  
  private void EditRecipe_Load(object sender, EventArgs e)
  {
      con = new SqlConnection();
      dataRecipe = new DataSet();
  
      con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Recipes.mdf;Integrated Security=True;User Instance=True";
  
          con.Open();
  
          //MessageBox.Show("Database Open");
  
          string sql = "SELECT* From CookBookRecipes";
          dataAdapt = new SqlDataAdapter(sql, con);
  
          dataAdapt.Fill(dataRecipe, "CookBookRecipes");
          NavigateRecords();
          MaxRows = dataRecipe.Tables["CookBookRecipes"].Rows.Count;
  
          con.Close();
  }
  
  
  private void NavigateRecords()
  {
      DataRow dRow = dataRecipe.Tables["CookBookRecipes"].Rows[inc];
  
      tbRName.Text = dRow.ItemArray.GetValue(0).ToString();
      listBox1.SelectedItem = dRow.ItemArray.GetValue(1).ToString();
      tbRCreate.Text = dRow.ItemArray.GetValue(2).ToString();
      tbRIngredient.Text = dRow.ItemArray.GetValue(3).ToString();
      tbRPrep.Text = dRow.ItemArray.GetValue(4).ToString();
      tbRCook.Text = dRow.ItemArray.GetValue(5).ToString();
      tbRDirections.Text = dRow.ItemArray.GetValue(6).ToString();
      tbRYield.Text = dRow.ItemArray.GetValue(7).ToString();
      textBox1.Text = dRow.ItemArray.GetValue(8).ToString();
  }
  
  private void btnNext_Click(object sender, EventArgs e)
  {
      if (inc != MaxRows - 1)
      {
          inc++;
          NavigateRecords();
      }
      else
      {
          MessageBox.Show("That's the last recipe of your Cook Book!", "End");
      }
  }
  
  private void btnBack_Click(object sender, EventArgs e)
  {
      if (inc &gt; 0)
      {
          inc--;
          NavigateRecords();
      }
      else
      {
          MessageBox.Show("This is the first recipe of your Cook Book!", "Start");
      }
  }
  
  private void btnSave_Click(object sender, EventArgs e)
  {
      cb = new SqlCommandBuilder(dataAdapt);
  
      DataRow daRow = dataRecipe.Tables["CookBookRecipes"].Rows[inc];
  
      daRow[0] = tbRName.Text;
      daRow[1] = listBox1.SelectedItem.ToString();
      daRow[2] = tbRCreate.Text;
      daRow[3] = tbRIngredient.Text;
      daRow[4] = tbRPrep.Text;
      daRow[5] = tbRCook.Text;
      daRow[6] = tbRDirections.Text;
      daRow[7] = tbRYield.Text;
      daRow[8] = textBox1.Text;
  
      if (MessageBox.Show("You wish to save your updates?", "Save Updates?", MessageBoxButtons.OKCancel) == DialogResult.OK)
      {
  
          dataAdapt.Update(dataRecipe, "CookBookRecipes");
  
          MessageBox.Show("Recipe Updated", "Update");
      }
  }
  
  private void btnDelete_Click(object sender, EventArgs e)
  {
      SqlCommandBuilder cb;
      cb = new SqlCommandBuilder(dataAdapt);
  
      if (MessageBox.Show("You wish to DELETE this recipe?", "Delete?", MessageBoxButtons.OKCancel) == DialogResult.OK)
      {
          dataRecipe.Tables["CookBookRecipes"].Rows[inc].Delete();
          MaxRows--;
          inc = 0;
          NavigateRecords();
  
          dataAdapt.Update(dataRecipe, "CookBookRecipes");
  
          MessageBox.Show("Your Recipe has been Deleted", "Delete");
      }
  }
  </code></pre>
  
  <p>This is supposed to update the table:</p>
  
  <pre><code>dataAdapt.Update(dataRecipe, "CookBookRecipes");
  </code></pre>
  
  <p>I'm not getting any errors, but the data table just won't update.</p>
  
  <p>Thanks in advance for your help, and just let me know if you need more information.</p>