Updating Database From DataGrid

Question

I have a datagrid with a record bound to it from a database.  The SELECT statement is of this form SELECT * FROM Table1 WHERE ID = @ID.  I had VS generate the UPDATE and DELETE statements automatically. I do not understand why when I edit the datagrid for some records the data change is persisted in the database and for others it is not?