clear a cell value in datagrid

[HRHK]

I tried to clear cell value in datagrid which is binded to a dataset but it doesn't go away.
How do I do this? Thanks.


For Each row In ds.Tables(0).Rows
If reqId = row("req_id") Then
row("unit_cost") = DBNull.Value
ds.AcceptChanges()
End If
Next

 

[mkohl]

Code:
dim dt as datatable
dim row as datarow
dt = ds.tables(0)

for each row in dt.rows
if row.item(0) = "req_id" then
row.item(1) = dbnull.value
end if

DataGrid1.DataSource = ds
DataGrid1.SetDataBinding(ds, "dt")

I think this should work.. just replace the 0 and 1 with columns your checking(and changing). If your still having problems.. then let me know and I will actually test the code in a datagrid.. and see what I come up with

-mike