This is my (rough) code (DAL):
// Some other declarations
SqlCommand myCmdObject = new SqlCommand("some query");
i = myCmdObject.ExecuteNonQuery();
What kind of query do you perform? Using
ExecuteNonQuery is intended for
DELETE queries. As per the documentation:
For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of rows affected by the trigger or triggers. For all other types of statements, the return value is -1.