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