title: BindingSource not moves to next record with MoveNext() after TableAdapter.Fill
body: <p>I have this event on a button click below:</p>
  
  <pre><code>private void button4_Click(object sender, EventArgs e)
  {
      string connectionString2 = "Data Source=LPMSW09000012JD\\SQLEXPRESS;Initial Catalog=Pharmacies;Integrated Security=True";
      string query2 = "UPDATE Liguanea_Lane2 SET Progress= '1' where code = '" + comboBox2.Text + "'; ";
      using (SqlConnection connection = new SqlConnection(connectionString2))
      {
          SqlCommand command = new SqlCommand(query2, connection);
          command.Connection.Open();
          command.ExecuteNonQuery();
      }
      comboBox2.ResetText();
      textBox1.Clear();
      comboBox2.SelectedIndex = comboBox2.SelectedIndex + 1;
      this.liguanea_Lane2TableAdapter.Fill(this.pharmaciesDataSet3.Liguanea_Lane2);
      liguaneaLane2BindingSource.MoveNext();
  }
  </code></pre>
  
  <p>The problem is this particular block of code: </p>
  
  <pre><code>this.liguanea_Lane2TableAdapter.Fill(this.pharmaciesDataSet3.Liguanea_Lane2);
  liguaneaLane2BindingSource.MoveNext();
  </code></pre>
  
  <p>Wha it is doing is basically refreshing the datasource within the data grid and move to the next item in the table. Eg.After the button is clicked it Updates the "progress" column value to "1" and then refresh the data set and then call the .MoveNext to move the cursor to the next item in the table. It works but only executes once and then stops moving. The dataset refreshes fine but the .MoveNext is the issue. I try moving it above the dataset but then it does not execute the problem. What am I doing wrong?</p>