In my VB 6 project i use Datagrid control to present the record information
from SQL SERVER by ADO objects pointing to all records by default.

I checked the properties ( Allow Delete,Allow Add, Allow Modify) of Datagrid
control, when I highlighted one record and click Delete from key borad, the
record sounds disappearing from GUI of Grid. When I click one button which
supposedly close the existing recordset, open new one and assign to datagrid
datasource, the deleted record pups up again. The delete functionality is
not commited. How to solve this kind of problem?