private void frmTransactions_Load(object sender, EventArgs e)
        {
            //Dispay all the transactions
            DataTable dt = tdal.DisplayAllTransactions();

            dgvTransactions.DataSource = dt;

            DataTable dt1 = tdal.DisplayTransactions("invoice_no", "0", "999999999");

            cmbInvFrom.DataSource  = dt1;
            cmbInvFrom.ValueMember = "invoice_no";

            DataTable dt2 = tdal.DisplayTransactions("invoice_no", "0", "999999999");

            cmbInvTo.DataSource  = dt2;
            cmbInvTo.ValueMember = "invoice_no";

            DataSet ds1 = dcDAL.GetDealerCustomerForTransaction();

            cmbCusFrom.DataSource  = ds1.Tables[0];
            cmbCusFrom.ValueMember = "name";

            DataSet ds2 = dcDAL.GetDealerCustomerForTransaction();

            cmbCusTo.DataSource  = ds2.Tables[0];
            cmbCusTo.ValueMember = "name";
        }