Working with DataSet Events in ADO.NET
In this article I will explain working with DataSet Events in ADO.NET.
This article has been
excerpted from book "A Programmer's Guide to ADO.NET in C#".
A dataset has a MergeFailed event that occurs when merging two datasets fails.
MergeFailedEventHandler handles the MergeFailed event, which receives an
argument of type MergeFailedEventArges that contains data related to this event.
The MergeFailedEventHandler is as follows:
public delegate void
Where sender is the source of the event and e is the MergeFailedEventArgs abject
that contains the event data.
The MergeFailedEventArgs has Conflict and Table properties. The Conflict
property returns a description of the merge conflict, and the Table property
returns the name of the data table. Listing 9-7 shows an example of the
MergeFailed event handler. As you can see, the MergeFailedBtn_Click method
creates a connection and a data adapter and then fills a dataset using the Fill
method of the data adapter. After that the code creates a second dataset, calls
the Fill method to fill it, and then calls the Merge method of the dataset.
Listing 9-7. Writing code to call the MergeFailed event handler
public partial class Form1 :
MergeFailedBtn_Click(object sender, System.EventArgs
OleDbConnection conn =
string strDSN =
conn.ConnectionString = strDSN;
string sql =
"SELECT * FROM Employees";
OleDbDataAdapter da =
DataSet ds1 =
sql = "SELECT * FROM Customers";
da = new
DataSet ds2 =
ds1.MergeFailed += new MergeFailedEventHandler(OnMergeFailed);
static void OnMergeFailed(object
sender, MergeFailedEventArgs args)
Hope this article would have helped you in understanding working with DataSet
Events in ADO.NET. See other articles on
the website also for further reference.
| ||This essential guide
to Microsoft's ADO.NET overviews C#, then leads you toward deeper
understanding of ADO.NET. |