// create a new dataset and populate it with data from a database var dataSet = new DataSet(); var connectionString = "connection string here"; var adapter = new SqlDataAdapter("SELECT * FROM my_table", connectionString); adapter.Fill(dataSet, "my_table"); // make some changes to the dataset dataSet.Tables["my_table"].Rows[0]["column1"] = "new value"; dataSet.Tables["my_table"].Rows[1].Delete(); // reject the changes dataSet.RejectChanges();
// create a new dataset and populate it with data from a database var dataSet = new DataSet(); var connectionString = "connection string here"; var adapter = new SqlDataAdapter("SELECT * FROM my_table", connectionString); adapter.Fill(dataSet, "my_table"); // enable tracking of changes dataSet.Tables["my_table"].RowChanged += (sender, e) => Console.WriteLine("Row changed: " + e.Row["column1"]); dataSet.Tables["my_table"].RowDeleted += (sender, e) => Console.WriteLine("Row deleted: " + e.Row["column1"]); // make some changes to the dataset dataSet.Tables["my_table"].Rows[0]["column1"] = "new value"; dataSet.Tables["my_table"].Rows[1].Delete(); // reject the changes dataSet.RejectChanges();In this example, we first load data from a database into a dataset using a SqlDataAdapter. We also enable tracking of changes by subscribing to the RowChanged and RowDeleted events of the dataset's table. Then we make some changes to the dataset and finally call the RejectChanges method. As a result, the RowChanged and RowDeleted events are not fired because the changes have been rejected. The System.Data namespace is part of the .NET Framework Class Library.
public RejectChanges ( ) : void | ||
return | void |