ADO.NET

ADO.NET Projects

ADO.NET Project 1

ADO.NET Examples

Examples

adplus-dvertising
Usage of DataTable Events
Previous Home Next

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());
}
Previous Home Next