Database

private void comboCustomerId_SelectedIndexChanged(object sender, EventArgs e)
{
    ComboBox cb = sender as ComboBox;
    if ((cb != null) && (cb.SelectedValue != null))
    {
        SetDefaultsForCustomer((int)cb.SelectedValue);
    }
}

private void SetDefaultsForCustomer(int customerId)
{
    CustomerDefaultsTableAdapter adap = new CustomerDefaultsTableAdapter();
    InvoiceDataSet.CustomerDefaultsDataTable dfc = adap.GetData(customerId);
    InvoiceDataSet.CustomerDefaultsRow cust = dfc.Rows[0] as InvoiceDataSet.CustomerDefaultsRow;

    DataRowView drv = (DataRowView)bindingSourceHead.Current;
    InvoiceDataSet.InvoiceRow ir = drv.Row as InvoiceDataSet.InvoiceRow;
    if (ir != null)
    {
        ir.CustomerId = cust.CustomerId;
        ir.CustomerContact = cust.ContactPerson;
}