DataTable.RowDeleting-Ereignis

Tritt ein, bevor eine Zeile in der Tabelle gelöscht wird.

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

Syntax

'Declaration
Public Event RowDeleting As DataRowChangeEventHandler
'Usage
Dim instance As DataTable
Dim handler As DataRowChangeEventHandler

AddHandler instance.RowDeleting, handler

public event DataRowChangeEventHandler RowDeleting

public:
event DataRowChangeEventHandler^ RowDeleting {
    void add (DataRowChangeEventHandler^ value);
    void remove (DataRowChangeEventHandler^ value);
}

/** @event */
public void add_RowDeleting (DataRowChangeEventHandler value)

/** @event */
public void remove_RowDeleting (DataRowChangeEventHandler value)

JScript unterstützt die Verwendung von Ereignissen, aber nicht die Deklaration von neuen Ereignissen.

Hinweise

Weitere Informationen finden Sie unter Arbeiten mit DataTable-Ereignissen.

Beispiel

Private Shared Sub DataTableRowDeleting()
    Dim customerTable As DataTable = New DataTable("Customers")
    ' add columns
    customerTable.Columns.Add( "id", Type.GetType("System.Int32"))
    customerTable.Columns.Add( "name", Type.GetType("System.String"))
    customerTable.Columns.Add( "address", Type.GetType("System.String"))

    ' set PrimaryKey
    customerTable.Columns( "id").Unique = true
    customerTable.PrimaryKey = New DataColumn() { customerTable.Columns("id") }

    ' add a RowDeleting event handler for the table.
    AddHandler customerTable.RowDeleting, New _
        DataRowChangeEventHandler( AddressOf Row_Deleting )


    ' add ten rows
    Dim id As Integer
    For id = 1 To 10
        customerTable.Rows.Add( _
            New Object() { id, string.Format("customer{0}", id), _
            string.Format("address{0}", id) })
    Next
    
    customerTable.AcceptChanges()

    ' Delete all the rows
    Dim row As DataRow
    For Each row In customerTable.Rows 
        row.Delete()
    Next
End Sub

Private Shared Sub Row_Deleting(sender As Object, _
    e As DataRowChangeEventArgs)
    Console.WriteLine( "Row_Deleting Event: name={0}; action={1}", _
        e.Row("name"), e.Action) 
End Sub

private static void DataTableRowDeleting()
{
    DataTable customerTable = new DataTable("Customers");
    // add columns
    customerTable.Columns.Add( "id", typeof(int));
    customerTable.Columns.Add( "name", typeof(string));
    customerTable.Columns.Add( "address", typeof(string));

    // set PrimaryKey
    customerTable.Columns[ "id" ].Unique = true;
    customerTable.PrimaryKey = new DataColumn[] 
        { customerTable.Columns["id"] };

    // add a RowDeleting event handler for the table.
    customerTable.RowDeleting += new DataRowChangeEventHandler( Row_Deleting );


    // add ten rows
    for( int id=1; id<=10; id++)
    {
        customerTable.Rows.Add( 
            new object[] { id, string.Format("customer{0}", id), 
            string.Format("address{0}", id) });
    }

    customerTable.AcceptChanges();

    // Delete all the rows
    foreach( DataRow row in customerTable.Rows )
        row.Delete();
}

private static void Row_Deleting( object sender, 
    DataRowChangeEventArgs e )
{
    Console.WriteLine( "Row_Deleting Event: name={0}; action={1}", 
        e.Row["name"], e.Action );
}

Plattformen

Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile für Pocket PC, Windows Mobile für Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

.NET Framework unterstützt nicht alle Versionen sämtlicher Plattformen. Eine Liste der unterstützten Versionen finden Sie unter Systemanforderungen.

Versionsinformationen

.NET Framework

Unterstützt in: 2.0, 1.1, 1.0

.NET Compact Framework

Unterstützt in: 2.0, 1.0

Siehe auch

Referenz

DataTable-Klasse
DataTable-Member
System.Data-Namespace

Weitere Ressourcen

Erstellen und Verwenden von DataTables