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(); }