how to hide the datagridview cell values while chage status

Question

Hai,

 

In my project I want to hide the Datagridview cell value from database table. Here datagridvalues are not shown after change the status of one value in databse table.  If i can change the status ="0" means it doesn't show the data during form load in datagridview .Please can anyone help me to solve this issue. Really it's too urgent to complete it's task . so kindly help me to solve this problem, Thanks for your co-operation in advance.

 

Ex.

S.NO	Name	Due	Amount	Status
1	XXX	4	1000	Onprogress
2	yyyy	4	1000	Onprogress
3	xxxx	5	1100	Onprogress
4	yyyy	5	1100	Onprogress

 

S.No	Name	Due	Amount	Status
2	yyyy	4	1000	Onprogress
3	xxxx	5	1100	Onprogress
4	yyyy	5	1100	Onprogress

 

 

In this above table (First table), this details are shown while load the form . after change this status  changed as "Completed" means that data will not shown in the grid while load the form(See  the second table). Here am using c# windows application.