How do I display the status paid after encode the amount when the current status is not paid

See more:

C#

my problem is that when encoding the tenant's payment, the current status is not paid. then I tried to encode the amount of the tenant's payment the status does not change to paid still the status is not paid.

What I have tried:

public void loaddata()
        {
            con.Close();
            DataTable table = new DataTable();
            cmd = new MySqlCommand("SELECT CASE STATUS WHEN 1 THEN 'NOT PAID' ELSE 'PAID' END AS STATUS FROM ledgercard", con.con);
            con.Open();
            reader = cmd.ExecuteReader();
            table.Load(reader);
            dataGridViewPayment.DataSource = table;
            dataGridViewPayment.ReadOnly = true;
            dataGridViewPayment.Columns[0].Visible = false;

            loaddata();

        }