DataTable.ColumnChanged Événement

Référence

Définition

Espace de noms:: System.Data

Assembly:: System.Data.Common.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Source:: DataTable.cs

Source:: DataTable.cs

Source:: DataTable.cs

Important

Certaines informations portent sur la préversion du produit qui est susceptible d’être en grande partie modifiée avant sa publication. Microsoft exclut toute garantie, expresse ou implicite, concernant les informations fournies ici.

Se produit après la modification d'une valeur du DataColumn spécifié dans un DataRow.

public:
 event System::Data::DataColumnChangeEventHandler ^ ColumnChanged;

public event System.Data.DataColumnChangeEventHandler? ColumnChanged;

public event System.Data.DataColumnChangeEventHandler ColumnChanged;

[System.Data.DataSysDescription("DataTableColumnChangedDescr")]
public event System.Data.DataColumnChangeEventHandler ColumnChanged;

member this.ColumnChanged : System.Data.DataColumnChangeEventHandler

[<System.Data.DataSysDescription("DataTableColumnChangedDescr")>]
member this.ColumnChanged : System.Data.DataColumnChangeEventHandler

Public Custom Event ColumnChanged As DataColumnChangeEventHandler

Type d'événement

DataColumnChangeEventHandler

Attributs: DataSysDescriptionAttribute

Exemples

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

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

    // add a ColumnChanged event handler for the table.
    custTable.ColumnChanged += new
        DataColumnChangeEventHandler(Column_Changed );

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

    custTable.AcceptChanges();

    // change the name column in all the rows
    foreach(DataRow row in custTable.Rows )
    {
        row["name"] = string.Format("vip{0}", row["id"]);
    }
}

private static void Column_Changed(object sender, DataColumnChangeEventArgs e )
{
    Console.WriteLine("Column_Changed Event: name={0}; Column={1}; original name={2}",
        e.Row["name"], e.Column.ColumnName, e.Row["name", DataRowVersion.Original]);
}

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

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

    ' add a ColumnChanged event handler for the table.
    AddHandler custTable.ColumnChanged, _
        New DataColumnChangeEventHandler(AddressOf Column_Changed )


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

    ' change the name column in all the rows
    Dim row As DataRow
    For Each row In custTable.Rows 
        row("name") = string.Format("vip{0}", row("id"))
    Next

End Sub

Private Shared Sub Column_Changed(sender As Object, _
    e As DataColumnChangeEventArgs)
    Console.WriteLine("Column_Changed Event: name={0}; Column={1}; original name={2}", _
        e.Row("name"), e.Column.ColumnName, e.Row("name", DataRowVersion.Original))
End Sub

Remarques

Pour plus d’informations, consultez Gestion des événements DataTable.

S’applique à

Partager via