static void Main(string[] args)
{
Console.ForegroundColor = ConsoleColor.Gray;
con = new SqlConnection();
con.ConnectionString = @"Data Source=205_TEACHER\SQLEXPRESS; Initial Catalog=Statistic; Trusted_Connection=Yes;";
SqlDataAdapter da =
new SqlDataAdapter("select * from StatisticEvents;", con);
ds = new DataSet();
da.Fill(ds);
AddStat();
EditStat();
DeleteStat();
PrintData();
if (ds.HasChanges())
{
Console.WriteLine("\nBefore changes: \n");
foreach (DataTable table in
ds.GetChanges(DataRowState.Modified)
.Tables)
{
foreach (DataRow row in table.Rows)
{
for (int i = 0; i < row.ItemArray.Length; i++)
{
Console.WriteLine("\t BEFORE - {0}: AFTER - {1}",
row[i, DataRowVersion.Original],
row[i, DataRowVersion.Current]);
}
}
}
}
}
