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




Reply With Quote
