private void frmSales_Load(object sender, EventArgs e)
{
Clsdb clsdb = new Clsdb();
DataTable dt3 = new DataTable();
DataTable dt2 = new DataTable();
clsdb.cusCombo(cmbCustomer);
dt2 = clsdb.populateItemCombo();
dt3 = clsdb.populateSalesDGV();
cmbItemCode.ValueMember = "item_code";
cmbItemCode.DisplayMember = "item_des";
cmbItemCode.DataSource = dt2;
}
private void cmbCustomer_SelectedIndexChanged(object sender, EventArgs e)
{
Clsdb clsdb = new Clsdb();
DataTable dt = new DataTable();
//String add1 = txtAdd1.Text;
//String add2 = txtAdd2.Text;
//String add3 = txtAdd3.Text;
//String suburb = txtSubrb.Text;
//String state = txtState.Text;
//String postalcode = txtPcode.Text;
dt = clsdb.getClients(cmbCustomer.Text);
txtAdd1.Text = dt.Rows[0][0].ToString();
txtAdd2.Text = dt.Rows[0][1].ToString();
txtAdd3.Text = dt.Rows[0][2].ToString();
txtSubrb.Text = dt.Rows[0][3].ToString();
txtState.Text = dt.Rows[0][4].ToString();
txtPcode.Text = dt.Rows[0][5].ToString();
}