SaveChanges from DataGridView to sql c#

See more:

C#

SQL

I'm making a GUI for DATA entry. on the left side there is the data grid and on the right side there are textbox,combo box & wysiwyg editor. When clicked to one of the cells it will paste it to the right side where user able to edit anything what necessary. I made a "Save button" when it's clicked delete the text from the right side and update the data grid and update SQL with SQL adapter. However when the button pressed it does not save the changes to SQL, only after when I selected/clicked to another cell on the data grid and repressed the button. So probably I need to cancel the editing somehow?

My code is for the button:

private void button2_Click(object sender, EventArgs e)
{
    if (editor1.BodyHtml != null)
    {
        string edit_title = textBox2.Text.ToString();
        string edit_role = comboBox2.Text.ToString();
        string edit_desc = editor1.BodyHtml.ToString();
        int id = dataGridView1.CurrentCell.RowIndex;

        dataGridView1.CurrentRow.Cells[1].Value = edit_title;
        dataGridView1.CurrentRow.Cells[2].Value = edit_role;
        dataGridView1.CurrentRow.Cells[3].Value = edit_desc;

        dataGridView1.UpdateCellValue(1, id);
        dataGridView1.UpdateCellValue(2, id);
        dataGridView1.UpdateCellValue(3, id);

        textBox2.ResetText();
        comboBox2.ResetText();
        editor1.Clear();
        dataGridView1.Refresh();

    }

    try
    {
        cmdbl = new SqlCommandBuilder(adap);
        adap.Update(ds, "CreatedJobs");
        MessageBox.Show("Job has been Updated!", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }



}