I have a datagridview that I need to bind to a dataset that contains data from a Access database table. The datagridview needs to allow the user to edit existing data as well as add new data. When the user is done I need to have whatever changes are made to existing data as well as the new data saved back to the database. What is the best approach to take to acomplish this?
I am able to populate the dataset and bind it to the grid. My problem is save the changes back to the database.