2627 主键重复
2607 唯一索引
08001 无法连接到数据源
08002 连接正在使用
08003 连接未打开
08004 数据源拒绝建立连接
08007 在执行事务的过程中连接失败
08S01 通讯链接失败例子:
try
{
dbManage.InsertRecord(myDataSet,isAuto); //插入数据
Response.Redirect ("ShowRecords.aspx?tbname=" + TableName,true);
}
catch (SqlException e1)
{
if (e1.Number == 2627) //duplicate primary key error
{
lblStatus.Text = "Error: A record with same ID already exists. Please use another ID.";
}
else
{
lblStatus.Text = "Error:" + e1.Number.ToString() + ", " + e1.Message;
}
}
catch (Exception ex)
{
lblStatus.Text = "Error occurs when trying to add a new record. Detail info is: " + ex.Message;
}
2607 唯一索引
08001 无法连接到数据源
08002 连接正在使用
08003 连接未打开
08004 数据源拒绝建立连接
08007 在执行事务的过程中连接失败
08S01 通讯链接失败例子:
try
{
dbManage.InsertRecord(myDataSet,isAuto); //插入数据
Response.Redirect ("ShowRecords.aspx?tbname=" + TableName,true);
}
catch (SqlException e1)
{
if (e1.Number == 2627) //duplicate primary key error
{
lblStatus.Text = "Error: A record with same ID already exists. Please use another ID.";
}
else
{
lblStatus.Text = "Error:" + e1.Number.ToString() + ", " + e1.Message;
}
}
catch (Exception ex)
{
lblStatus.Text = "Error occurs when trying to add a new record. Detail info is: " + ex.Message;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货