Обновление dataGridView с использованием UpdateCommand

    string zp = ("SELECT     TOP (100) PERCENT dbo.Cars.Registration_number, dbo.Drivers.Name, dbo.Drivers.Surname, dbo.Brands.Capacity, dbo.Brands.Load_capacity, dbo.Object_work.Number_flights," +
                        "  dbo.Brands.Capacity * dbo.Object_work.Number_flights AS Total_Capacity, dbo.Brands.Load_capacity * dbo.Object_work.Number_flights AS Total_Load_capacity " +
 
                         " FROM         dbo.Brands INNER JOIN" +
                         " dbo.Cars ON dbo.Brands.ID_Brand = dbo.Cars.ID_Brand INNER JOIN" +
                         " dbo.Drivers ON dbo.Cars.ID_Cars = dbo.Drivers.ID_Car INNER JOIN" +
                         " dbo.Waybill ON dbo.Drivers.ID_Driver = dbo.Waybill.ID_Driver INNER JOIN" +
                         " dbo.Object_work ON dbo.Waybill.ID_Waybill = dbo.Object_work.ID_Waybill INNER JOIN" +
                         " dbo.Object ON dbo.Waybill.ID_Object = dbo.Object.ID_Object" +
                         " WHERE     (dbo.Object.Name_Object = '" + obekt + "')");
 
 
                 adapter = new SqlDataAdapter(zp, cn);
                 ds = new DataSet();
                 adapter.Fill(ds);
              dataGridView1.DataSource = ds.Tables[0];

 adapter.UpdateCommand = new SqlCommand("UPDATE Object_work SET Number_flights = @Number_flights WHERE ID_Object_work = @ID_Object_work", cn);
            adapter.UpdateCommand.Parameters.Add("@Number_flights", SqlDbType.Int, 5, "Number_flights");
 
            SqlParameter parameter = adapter.UpdateCommand.Parameters.Add("@ID_Object_work", SqlDbType.Int);
            parameter.SourceColumn = "ID_Object_work";
            parameter.SourceVersion = DataRowVersion.Original;
            adapter.Update(ds.Tables[0]);

private void button1_Click(object sender, EventArgs e)
        {
             string connectionString = @"Server=10.10.10.34; Database=14-IT-1-Brigadin; User Id=Brigadin; Password=wfr12390 ;";
             SqlConnection connection = new SqlConnection(connectionString);
             connection.Open();
             adapter = new SqlDataAdapter("SELECT * FROM Persons", connection);
             tbl = new DataTable();
             adapter.Fill(tbl);       
             dataGridView1.DataSource = tbl;
             tbl.EndInit();
            tbl.EndIdit(); // Ошибка
             
            
        }
 
        private void button2_Click(object sender, EventArgs e)
        {
            SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(adapter);
            adapter.Update(tbl);
        }

 adapter.UpdateCommand = new SqlCommand("UPDATE Object_work SET @ID_Object_work=ID_Object_work, Number_flights = @Number_flights WHERE ID_Object_work = @ID_Object_work", cn);
            adapter.UpdateCommand.Parameters.Add("@Number_flights", SqlDbType.Int, 5, "Number_flights");
            adapter.UpdateCommand.Parameters.Add("@ID_Object_work", SqlDbType.Int, 5, "ID_Object_work");
            SqlParameter parameter = adapter.UpdateCommand.Parameters.Add("@ID_Object_work", SqlDbType.Int);
 
            parameter.SourceColumn = "ID_Object_work";
            parameter.SourceVersion = DataRowVersion.Original;
            dataGridView1.EndEdit();
            try
            {
               
                adapter.Update(ds.Tables[0]);
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }

adapter.UpdateCommand = new SqlCommand("UPDATE Object_work SET Number_flights = @Number_flights WHERE ID_Object_work = @ID_Object_work", cn);
            adapter.UpdateCommand.Parameters.Add("@Number_flights", SqlDbType.Int);
            adapter.UpdateCommand.Parameters.Add("@ID_Object_work", SqlDbType.Int);
            dataGridView1.EndEdit();
            try
            {
               
                adapter.Update(ds.Tables[0]);
            }
            catch (Exception ex) { MessageBox.Show(ex.Message); }