I am having a problem with a datagrid i set up. I can update the source just fine, but when i go to delete records, i get problems. As long as the primary Keys are in order and do not skip a number, it works fine, but when i add a record, delete it, then add another record, I can't delete the second record. The delete link shows as though it's been clicked before too. I don't know what's causing this problem. Here is the source i am using. Can anyone help??
sub asGrid_Delete(obj as object, e as DataGridCommandEventArgs)
dim strSQL as string = "DELETE FROM tbAvailableSituations _
WHERE asID = " & e.Item.ItemIndex + 1