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