Get affected rows on ExecuteNonQuery

ExecuteNonQuery – returns the number of rows affected.

SqlCommand comm;
// other codes
int numberOfRecords = comm.ExecuteNonQuery();