ExecuteNonQuery returns the number of rows affected. If the return value is 1, your row should be inserted. Less than 1 and your insert failed.