SqlCeException Class

The exception thrown when the underlying provider returns a warning or error from a Microsoft SQL Server 2005 Compact Edition data source. This class cannot be inherited.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Class SqlCeException
    Inherits SystemException
'Usage
Dim instance As SqlCeException
public class SqlCeException : SystemException
public ref class SqlCeException : public SystemException
public class SqlCeException extends SystemException
public class SqlCeException extends SystemException
Not applicable.

Remarks

This class is created whenever the .NET Compact Framework Data Provider for SQL Server Compact Edition encounters an error generated from within the SQL Server Compact Edition Engine. (Other errors are thrown as standard common language runtime exceptions.) SqlCeException always contains at least one instance of SqlCeError.

Example

The following example generates a SqlCeException due to a missing data source, and then displays the exception.

Dim conn As New SqlCeConnection("Data Source=nonExistingSource.sdf;")

Try
    conn.Open()
Catch e As SqlCeException
    ' Use SqlCeException properties if you need specific
    ' application logic depending on the error condition
    '
    If 25046 = e.NativeError Then 'SSCE_M_FILENOTFOUND
        ' Error specific logic goes here...
        '
    End If

    MessageBox.Show(e.Message)
End Try
SqlCeConnection conn = new SqlCeConnection("Data Source=nonExistingSource.sdf;");

try
{
    conn.Open();
}
catch (SqlCeException e)
{
    // Use SqlCeException properties if you need specific
    // application logic depending on the error condition
    //
    if (25046 == e.NativeError /*SSCE_M_FILENOTFOUND*/)
    {
        // Error specific logic goes here...
        //
    }

    MessageBox.Show(e.Message);
}

Inheritance Hierarchy

System.Object
   System.Exception
     System.SystemException
      System.Data.SqlServerCe.SqlCeException
         System.Data.SqlServerCe.SqlCeLockTimeoutException
         System.Data.SqlServerCe.SqlCeTransactionInProgressException

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeException Members
System.Data.SqlServerCe Namespace
SqlCeError
SqlCeErrorCollection