to determine whether the data has been deleted, use:
vb Code:
  1. cmdDelete.CommandText = "DELETE FROM Table2 WHERE ID = " & cint( TextBox1.Text )
  2.  
  3. Dim iRs As Integer = cmdDelete.ExecuteNonQuery()
  4. if iRs > 0 then
  5.     MessageBox.Show("         Records Deleted!!            ")
  6. end if