Usage of DataTable Events

Usage of DataTable Events

 DataTable events can be split into three main categories:

• Column-based: ColumnChanging, ColumnChanged

• Row-based: RowChanging, RowChanged, RowDeleting, RowDeleted

• Table-based: TableClearing, TableCleared, TableNewRow

Setting Up Various Event Handlers on a DataTable in C#

CompanyTAble.ColumnChanged += new DataColumnChangeEventHandler(CompanyTAble_ColumnChanged); CompanyTAble.ColumnChanging += new DataColumnChangeEventHandler(CompanyTAble_ColumnChanging); CompanyTAble.RowChanged += new DataRowChangeEventHandler(CompanyTAble_RowChanged); CompanyTAble.RowChanging += new DataRowChangeEventHandler(CompanyTAble_RowChanging); CompanyTAble.RowDeleted += new DataRowChangeEventHandler(CompanyTAble_RowDeleted); CompanyTAble.RowDeleting += new DataRowChangeEventHandler(CompanyTAble_RowDeleting);

Implementations for the Event Handlers in C#

private static void CompanyTable_ColumnChanged
(object sender, DataColumnChangeEventArgs e)
{
Console.WriteLine("CompanyTable_ColumnChanged");
Console.WriteLine(" Value: " + e.Row["Name"].ToString());
Console.WriteLine(" RowState: " + e.Row.RowState.ToString());
}
private static void CompanyTable_ColumnChanging
(object sender, DataColumnChangeEventArgs e)
{
Console.WriteLine("CompanyTable_ColumnChanging");
Console.WriteLine(" Value: " + e.Row["Name"].ToString());
Console.WriteLine(" RowState: " + e.Row.RowState.ToString());
}
private static void CompanyTable_RowChanged
(object sender, DataRowChangeEventArgs e)
{
Console.WriteLine("CompanyTable_RowChanged");
Console.WriteLine(" Value: " + e.Row["Name"].ToString());
Console.WriteLine(" RowState: " + e.Row.RowState.ToString());
}
private static void CompanyTable_RowChanging
(object sender, DataRowChangeEventArgs e)
{
Console.WriteLine("CompanyTable_RowChanging");
Console.WriteLine(" Value: " + e.Row["Name"].ToString());
Console.WriteLine(" RowState: " + e.Row.RowState.ToString());
}
private static void CompanyTable_RowDeleted
(object sender, DataRowChangeEventArgs e)
{
Console.WriteLine("CompanyTable_RowDeleted");
Console.WriteLine(" RowState: " + e.Row.RowState.ToString());
}
private static void CompanyTable_RowDeleting
(object sender, DataRowChangeEventArgs e)
{
Console.WriteLine("CompanyTable_RowDeleting");
Console.WriteLine(" RowState: " + e.Row.RowState.ToString());
}