SqlCeConnection.FlushFailure Event

Occurs when the background flush fails.

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

Syntax

'Declaration
Public Event FlushFailure As SqlCeFlushFailureEventHandler
'Usage
Dim instance As SqlCeConnection
Dim handler As SqlCeFlushFailureEventHandler

AddHandler instance.FlushFailure, handler
public event SqlCeFlushFailureEventHandler FlushFailure
public:
event SqlCeFlushFailureEventHandler^ FlushFailure {
    void add (SqlCeFlushFailureEventHandler^ value);
    void remove (SqlCeFlushFailureEventHandler^ value);
}
/** @event */
public void add_FlushFailure (SqlCeFlushFailureEventHandler value)

/** @event */
public void remove_FlushFailure (SqlCeFlushFailureEventHandler value)
In JScript, you can handle the events defined by a class, but you cannot define your own.
Not applicable.

Example

The following example shows how to use the FlushFailure event.

Public Sub Snippet4()
    Dim conn As SqlCeConnection = Nothing

    Try
        conn = New SqlCeConnection("Data Source = MyDatabase.sdf; Password ='<pwd>'")
        
        AddHandler conn.FlushFailure, AddressOf conn_FlushFailure
       
        conn.Open()
        
        'Flush failure occurs here
        'OnFlushFailure will be called from the background thread.
       
       
    Finally
        conn.Close()
    End Try
    
End Sub

Private Sub conn_FlushFailure(ByVal sender As System.Object, ByVal e As SqlCeFlushFailureEventArgs)
    
    Dim errors As SqlCeErrorCollection = e.Errors
    Console.WriteLine("Flush Failure: " + errors(0).Message)
    
End Sub
// using System;
// using System.Xml;
// using System.Data;
// using System.Data.SqlServerCe;
// using System.Data.Common;
// using System.Windows.Forms;
/// <summary>
/// Demonstrates the usage of the FlushFailure event
/// </summary>
public class MyForm : Form
{
    public void Snippet4()
    {
                
        SqlCeConnection conn = new SqlCeConnection();
        
        conn.FlushFailure+=new SqlCeFlushFailureEventHandler(conn_FlushFailure);

        conn.Open();
        
        //Flush failure occurs here
        //OnFlushFailure will be called from the background thread.
 
        conn.Close();       
    }
    void conn_FlushFailure(object sender, SqlCeFlushFailureEventArgs e)
    {
        SqlCeErrorCollection errors = e.Errors;
        Console.WriteLine("Flush Failure:" + errors[0].Message);
    }
}

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

See Also

Reference

SqlCeConnection Class
SqlCeConnection Members
System.Data.SqlServerCe Namespace