使用SqlException的Error Number自定义友好信息

        private void DeleteMessageHandler()
        {
            try
            {
                DeleteData();
                RefreshData();
            }
            catch (Exception ex)
            {
                if (ex.GetType() == typeof(SqlException))
                {
                    SqlException sqlex = ex as SqlException;
                    switch (sqlex.Number)
                    {
                        case 547:
                            MessageBox.Show("数据被其它地方使用无法删除!", Constant.MSG_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Error);
                            break;
                    }
                }
                else

                    MessageBox.Show(ex.Message, Constant.MSG_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Error);
            }

        }

转载于:https://www.cnblogs.com/masterfy/archive/2009/06/09/1499618.html