saving in bindingsource

Question

good day..
any one can help me>>






connection


          new SqlConnection("Data Source=\\");
         
  SqlDataAdapter customersTableAdapter =
             new SqlDataAdapter("Select * from Customer", connectionString);


            DataTable customerTable = new DataTable();


            customersTableAdapter.Fill(customerTable);


             bindingSource1.DataSource = customerTable;


i made  save button  with code


        private void button6_Click(object sender, EventArgs e)
        {
            this.bindingSource1.EndEdit();


            this.customerTableAdapter.Update(dataSet1.customer);
            }

but   it's not working  what is the solution
please reply soon