如何捕捉插入记录时，主键或唯一索引重复引发的异常？

Question

在catch（）中捕捉特定的错误，来告诉用户。

Answer 1

ReceiveRecordsTableAdapter rr = new ReceiveRecordsTableAdapter();
                        rr.Update(m_CacheData);
                        if (m_CacheData.ReceiveRecords.HasErrors)
                        {
                            bool hasOtherError = false;
                            // If recordid repetition, create a new recordid save again
                            foreach (AlarmingDataSet.ReceiveRecordsRow drRe in m_CacheData.ReceiveRecords.Rows)
                            {
                                if (drRe.HasErrors && drRe.RowError == "RecordId not unique")
                                {
                                    drRe.RecordId = CreateRecordID(GetServer(m_CurrentServerName));
                                }
                                else
                                {
                                    hasOtherError = true;
                                }
                            }
                            if (hasOtherError)
                                throw new Exception("Connection is error.");
                        }
                        rr.Update(m_CacheData);

Answer 2

比如你用的是OleDb方式来操作数据库..捕获OleDbException异常,根据异常的ErrorCode来判断是什么异常..for example:try
{
    //插入操作
}
catch(OleDbException ex)
{
    switch(ex.ErrorCode)
    {
        case 12345:
            {//说明是什么异常...}
        //...
     }
}对于异常的Code可以查相关资料..