Export (0) Print
Expand All

DataTable.RowChanging Event

Occurs when a DataRow is changing.

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

public event DataRowChangeEventHandler RowChanging

For more information, see Handling DataTable Events.

private static void DataTableRowChanging()
{
	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 RowChanging event handler for the table.
	custTable.RowChanging += new DataRowChangeEventHandler(Row_Changing);


	// 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 Row_Changing(object sender, DataRowChangeEventArgs e)
{
	Console.WriteLine("Row_Changing Event: name={0}; action={1}", 
		e.Row["name"], e.Action);
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

XNA Framework

Supported in: 3.0, 2.0, 1.0
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft