private void txtBalanceDue_Click(object sender, EventArgs e)
        {
            DataTable dt = tdal.DisplayTransactionsWithBalance(); // include partial payments

            dgvTransactions.DataSource = dt;
        }