SqlCeException.Errors 属性

获取一个或多个 SqlCeError 对象的集合，这些对象包含有关用于 SQL Server Compact 的 .NET Compact Framework 数据提供程序生成的异常的详细信息。

命名空间：  System.Data.SqlServerCe
程序集：  System.Data.SqlServerCe（在 System.Data.SqlServerCe.dll 中）

语法

声明
Public Property Errors As SqlCeErrorCollection
    Get
    Private Set
用法
Dim instance As SqlCeException
Dim value As SqlCeErrorCollection

value = instance.Errors

public SqlCeErrorCollection Errors { get; private set; }

public:
property SqlCeErrorCollection^ Errors {
    SqlCeErrorCollection^ get ();
    private: void set (SqlCeErrorCollection^ value);
}

member Errors : SqlCeErrorCollection with get, private set

function get Errors () : SqlCeErrorCollection
private function set Errors (value : SqlCeErrorCollection)

属性值

类型：System.Data.SqlServerCe.SqlCeErrorCollection
包含为异常收集的 SqlCeError 类实例的 SqlCeErrorCollection 对象。

注释

SqlCeErrorCollection 类始终包含至少一个 SqlCeError 类的实例。

示例

下面的示例显示 SqlCeErrorCollection 集合中的每个 SqlCeError。

Try
    Dim repl As New SqlCeReplication()

    ' Fill repl properites here
    ' ...
    ' SqlCeReplication may throw SqlCeException which contains a 
    ' collection of errors; SQL Mobile database engine always
    ' returns one error in the collection
    '
    repl.Synchronize()
Catch e As SqlCeException
    Dim err As SqlCeError
    For Each err In e.Errors
        ' Use SqlCeError properties if you need specific
        ' application logic depending on the error condition
        '
        If 28577 = [err].NativeError Then 'SSCE_M_SCHEMAHASCHANGED
            ' Error specific logic goes here...
            '
        End If

        ' Note: For native error numbers, refer to SQL Server Mobile Errors
        ' in the SQL Server Mobile Books Online
        '
        MessageBox.Show([err].Message)
    Next err
End Try

try
{
    SqlCeReplication repl = new SqlCeReplication();

    // Fill repl properites here
    // ...

    // SqlCeReplication may throw SqlCeException which contains a 
    // collection of errors; SQL Mobile database engine always
    // returns one error in the collection
    //
    repl.Synchronize();
}
catch (SqlCeException e)
{
    foreach (SqlCeError error in e.Errors)
    {
        // Use SqlCeError properties if you need specific
        // application logic depending on the error condition
        //
        if (28577 == error.NativeError /*SSCE_M_SCHEMAHASCHANGED*/)
        {
            // Error specific logic goes here...
            //
        }

        // Note: For native error numbers, refer to SQL Server Mobile Errors
        // in the SQL Server Mobile Books Online
        //
        MessageBox.Show(error.Message);
    }
}

请参阅

参考

SqlCeException 类

System.Data.SqlServerCe 命名空间