To make a column of datagrid empty in 2005

[zareee]

hi, i have a table containing empname,supervisor name and status.employee can be a supervisor.for each employee there s a supervisor. suppose a supervisor status is inactive.i have to empty the supervisor name column in both database(sql server 2000) n in datagrid ex: empname supervisorname status zari b active b c inactive here b is inactive in status i need to empty the supervisorname of emp zari both in database n datagrid. thnxs in advance,

zari