Thx for replying. So, is there an alternative to using Execute to run DML statements and find out  the no. of rows affected? For a DELETE command, Execute returns -1 in both cases, 1)when the cmd actually deleted some records, and 2) when those records didn't exist in the table.

so, it is really difficult to know if it is success.