学会了怎么样利用捕获异常提示数据库主键重复错误

try
             {
                int re=SqlHelper.ExecuteNonQuery(SysConfiguration.ConnectionString, CommandType.StoredProcedure, "upd_task_complete_month",arParms); 
                return re;
            }
             catch (SqlException ex)
             {
                if(ex.Number==2627)
                {
                    return -1;  //主键重复
                }
                else
                {
                    return 0;
                }
            }

转载于:https://www.cnblogs.com/zwh/archive/2005/11/25/284478.html