title: How to set up BindingNavigator? - BindingNavigator is not working
body: <p>I have a data app that uses a BindingNavigator. I have hooked up the navigator to a binding source, however it is not working. It will not add or delete rows. The binding source is:     accountBindingSource. I don't understand what is wrong. I have the following code:</p>
  
  <pre><code>public partial class AccountDataGridView : Form
  {
      public AccountDataGridView()
      {
          InitializeComponent();
          Setup();
      }
  
      private void AccountDataGridView_Load(object sender, EventArgs e)
      {
          // Change the back color of the first column. This can also be changed in the designer
          accountGridView.Columns[0].DefaultCellStyle.BackColor = Color.FromArgb(192, 192, 255);
      }
  
      private void Setup()
      {
          // Define a global variable for the data table
          Account = new DataTable(Text);
          query = string.Format("SELECT * FROM {0}", Text);
          // Establish a connection between the Database and the form
          conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Tutoring Database.accdb;Persist Security Info=False");
          conn.Open();
          // Setup data table
          OleDbDataAdapter accountAdapter = new OleDbDataAdapter(query, conn);
          if (accountAdapter != null)
          {
              accountAdapter.Fill(Account);
          }
          accountGridView.DataSource = Account;
  
          conn.Close();
      }
  
      private void DataErrorRaised(object sender, DataGridViewDataErrorEventArgs e)
      {
          // Data table error handling. This is triggered when the user attempts to input invalid data into the CurrentBalance column
          MessageBox.Show("You have entered an invalid data type for the currency column. Please enter text formatted like so: '$0.00'",
              "Account Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
      }
  
      private void btnSave_Click(object sender, EventArgs e)
      {
          // Update Access Database
          try
          {
              adapter.SelectCommand = new OleDbCommand(query, conn);
              adapter.InsertCommand = new OleDbCommand(query, conn);
              adapter.DeleteCommand = new OleDbCommand(query, conn);
              OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
  
              adapter.Update(Account);
              Console.WriteLine("Saved");
          }
  
          catch
          {
  
          }
      }
  
      private DataTable Account;
      private string query;
      private OleDbConnection conn;
      private OleDbDataAdapter adapter = new OleDbDataAdapter();
  
      private void accountGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e)
      {
          btnSave_Click(null, null);
      }
  }
  </code></pre>