I have a Windows App with a DataGridView. I would like to give users the ability to update from the datagridview and have the program immediately update the sql server table.
I have created a .xsd. Now I am wondering which events to use to validate and update the database, wheter to enable/disable the validating events?
My questions related to this are:
On which events should I be editing the changed data?
On which event should I update the database?
How will I need to keep track when user has changed a key column and an update would no longer work?
Get me started, please