使用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);
}
}