Can anyone help me with code for removing the selected row from a datagrid. I cant seem to find the the right method.

If the datagrid is connected to a datasource, will it also remove it from the recordset? Ideally I would like it to be removed from the recordset but not from the database

All help welcome