C#

this.bindingSource1.DataSource = ds;
this.bindingSource1.DataMember = TestDataManager_MSAccess.TableName;

dgv.DataSource = bindingSource1;

private void dgv_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
    dgv.EditMode = DataGridViewEditMode.EditOnKeystrokeOrF2;
    dgv.EndEdit();

    //when a cell is double clicked, the textbox is populated with the relevant value
    txtWord.DataBindings.Add("Text", this.bindingSource1, TestDataManager_MSAccess.Word_ColName);
}

public Form_TxtBinding()
{
    InitializeComponent();
}



private void Form_TxtBinding_Load(object sender, EventArgs e)
{
    try
    {
        this.LoadDataController();
        this.DisplayData();
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}



private void LoadDataController()
{
    try
    {
        if (ds == null)
        {
            ds = new DataSet();
        }

        this.LoadData();
    }
    catch (Exception e)
    {
        throw e;
    }
}



private void LoadData()
{
    try
    {
        string connectionString = Properties.Settings.Default.German_Genie_2ConnectionString;

        //load the required data into a DataTable in the DataSet
        TestDataManager_MSAccess.LoadTestData(connectionString, ds);
    }
    catch (Exception e)
    {
        throw e;
    }
}



private void DisplayData()
{
    try
    {
        if (ds == null)
        {
            return;
        }

        this.bindingSource1.DataSource = ds;
        this.bindingSource1.DataMember = TestDataManager_MSAccess.TableName;

        dgv.DataSource = bindingSource1;
    }
    catch (Exception e)
    {
        throw e;
    }
}



private void dgv_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
    dgv.EditMode = DataGridViewEditMode.EditOnKeystrokeOrF2;
    dgv.EndEdit();

    //when a cell is double clicked, the textbox is populated with the relevant value
    txtWord.DataBindings.Add("Text", this.bindingSource1, TestDataManager_MSAccess.Word_ColName);
}




private void UpdateDatabase()
{
    try
    {
        if (ds.HasChanges() == true)
        {
            this.dgv.EndEdit();
            string connString = Properties.Settings.Default.German_Genie_2ConnectionString;

            //calls method in the Manager class that updates database from the DataTable
            TestDataManager_MSAccess.UpdateDataTable(connString, ds.Tables[TestDataManager_MSAccess.TableName]);
        }
    }
    catch (Exception ex)
    {
        throw ex;
    }
}



private void btnSave_Click(object sender, EventArgs e)
{
    try
    {
        this.UpdateDatabase();
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}



private void dgv_CellClick(object sender, DataGridViewCellEventArgs e)
{
    if (e.ColumnIndex == -1)    //RowHeaderCell clicked
    {
        dgv.EditMode = DataGridViewEditMode.EditOnKeystrokeOrF2;
        dgv.EndEdit();
    }
    else if (e.RowIndex == -1)  //ColumnHeaderCell clicked
    {
        dgv.EditMode = DataGridViewEditMode.EditOnKeystrokeOrF2;
        dgv.EndEdit();
    }
    else
    {
        //when any other cell clicked the EditMode is changed to EditOnEnter
        dgv.EditMode = DataGridViewEditMode.EditOnEnter;
    }
}

private void button1_Click(object sender, EventArgs e)
{

    MessageBox.Show("Process aborted by user", "Process Abort Message",
        MessageBoxButtons.OK, MessageBoxIcon.Warning);

    Thread.CurrentThread.Abort();
}