I am having trouble deleting a record from my database using a datatable. I delete a record from the data table, then reassign the index values. Next I update the data adapter with the data table. I then get the error "Violation of Primary Key Constraint 'PK_Members', cannot insert duplicat key in object 'Members'. I know the row is deleted in the data table, but it appears that SqlDataAdapter1.Updata(dtmembers) doesn't delete the row from the database. Can anyone help me.