Hi,

I've a Datagridview binded with a Datatable. With this code:

DataTable.rows.remove(current_datarow)
DataAdapter.update(datatable)

.... I manage to delete the row from the DataTable, it disapears from the
DataGridView, but it doesn't delete it from he database (after updating the
DataAdapter).

Can anyone tell me where is the problem ?!

Thanks
CC

From the  docs, DataRowCollection.Remove:
"When a row is removed, all data in that row is lost. You can also call
the Delete method of the DataRow class to just mark a row for removal.
Calling Remove is the same as calling Delete and then calling
AcceptChanges."

Thus calling remove completly removes that row from the table leaving no
trace of it. The command you want to use is:

current_datarow.Delete()

This will mark the row for deletion, when you next run update it will
run the delete command then remove the row from the DataTable.

Urgent:Newbie:Autoincrement violates foreign key con1straints
Read cvs File Fails
Populating typed datasets WITHOUT tableadapters
problem with no rows being returned - but rows are there
Conenctivity to Interbase Database