Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

DataTable.RowDeleted Event

Definition

Namespace:
System.Data
Assemblies:
netstandard.dll, System.Data.Common.dll
Assembly:
System.Data.Common.dll
Assembly:
System.Data.dll
Assembly:
netstandard.dll
Source:
DataTable.cs
Source:
DataTable.cs
Source:
DataTable.cs
Source:
DataTable.cs
Source:
DataTable.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Occurs after a row in the table has been deleted.

public:
 event System::Data::DataRowChangeEventHandler ^ RowDeleted;
public event System.Data.DataRowChangeEventHandler? RowDeleted;
public event System.Data.DataRowChangeEventHandler RowDeleted;
[System.Data.DataSysDescription("DataTableRowDeletedDescr")]
public event System.Data.DataRowChangeEventHandler RowDeleted;
member this.RowDeleted : System.Data.DataRowChangeEventHandler 
[<System.Data.DataSysDescription("DataTableRowDeletedDescr")>]
member this.RowDeleted : System.Data.DataRowChangeEventHandler 
Public Custom Event RowDeleted As DataRowChangeEventHandler 

Event Type

Attributes

Examples

private static void DataTableRowDeleted()
{
 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 RowDeleted event handler for the table.
 customerTable.RowDeleted += new DataRowChangeEventHandler(Row_Deleted);

 // 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_Deleted(object sender, DataRowChangeEventArgs e)
{
 Console.WriteLine("Row_Deleted Event: name={0}; action={1}",
 e.Row["name", DataRowVersion.Original], e.Action);
}
Private Sub DataTableRowDeleted()
 Dim customerTable As 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 RowDeleted event handler for the table.
 AddHandler customerTable.RowDeleted, New _
 DataRowChangeEventHandler(AddressOf Row_Deleted)


 ' 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 Sub Row_Deleted(ByVal sender As Object, _
ByVal e As DataRowChangeEventArgs)
 Console.WriteLine("Row_Deleted Event: name={0}; action={1}", _
 e.Row("name", DataRowVersion.Original), e.Action)
End Sub

Remarks

For more information, see Handling DataTable Events.

Applies to

See also


Feedback

Was this page helpful?