Đang chuẩn bị liên kết để tải về tài liệu:
Exploring the DataAdapter and DataTable Events

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Exploring the DataAdapter and DataTable Events You'll find all the code examples shown in this section in the program UsingEvents.cs located in the ch11 directory. | Exploring the DataAdapter and DataTable Events You ll find all the code examples shown in this section in the program UsingEvents.cs located in the ch11 directory. The listing for this program is omitted from this book for brevity. If you compile and run that program you ll see the order in which the events fire when you add modify and remove a row from a DataTable that contains rows retrieved from the Customers table. The DataAdapter Events The events exposed by a SqlDataAdapter object are shown in Table 11.11. Table 11.11 SqlDataAdapter EVENTS EVENT EVENT HANDLER DESCRIPTION FillError FillErrorEventHandler Fires when an error occurs during a call to the Fill method. RowUpdating RowUpdatingEventHandler Fires before a row is added modified or deleted in the database as a result of calling the Update method. RowUpdated RowUpdatedEventHandler Fires after a row is added modified or deleted in the database as a result of calling the Update method. The FillError Event The FillError event fires when you call the Fill method and an error occurred. The following are a couple of scenarios that would cause an error An attempt is made to add a number from the database to a DataColumn that couldn t be converted to the .NET type of that DataColumn without losing precision. An attempt is made to add a row from the database to a DataTable that violates a constraint in that DataTable. The following example event handler named FillErrorEventHandler checks for the precision conversion error public static void FillErrorEventHandler object sender FillErrorEventArgs myFEEA if myFEEA.Errors.GetType typeof System.OverflowException Console.WriteLine A loss of precision occurred myFEEA.Continue true The first parameter is an object of the System.Object class and it represents the object that raises the event. The second parameter is an object of the FillErrorEventArgs class which like all the EventArgs classes is derived from the System.EventArgs class. The EventArgs class is the base .