You may also have the My SQLData Adapter create the schema of the Data Set, including primary key information, before filling it with data using Fill Schema(Data Table, Schema Type).
Please be aware that the Data Column class allows only Int16, Int32, and Int64 to have the Auto Increment property set.
If you plan to use autoincremement columns with My SQL, you should consider using signed integer columns.
Since this event is not well suited to client-side data-validation, what is a good (best practices) use of the event?
You can use Row Updating to modify update behavior before it happens, to provide additional handling when an update will occur, to retain a reference to an updated row, to cancel the current update and schedule it for a batch process to be processed later, and so on.