What datatype does ExecuteNonQuery method return?

ExecuteNonQuery returns only Integer datatype.It returns no of row affected in table.

for example:-
int row_affected = 0;
row_affected = cmd.ExecuteNonQuery();

If some operations happen in Table i.e. DML and succedded then row_affected value will be greater than 0.

Here cmd is your SqlCommand object.