private void txtPaid_Click(object sender, EventArgs e) { DataTable dt = tdal.DisplayPaidTransactions(); // include partial payments dgvTransactions.DataSource = dt; }