You have basically only one option if you do not want to loose all your work. Before changing the DataSource/DataMember in the designer, you need to copy the code that the designer generated, for all the properties of all the objects you want to keep, to the form_load event.
This way, when you change the grid binding, which will erase everything that was set in the designer, you can simply update this new code in form_load so it compiles again. Note that it will require a minimum of work only if your underlying DataTable still uses the same columns and columns name as before, apart from the added/deleted columns.
For the new columns, it would be best to also set them up in the form_load event, so if you ever update you DataTable again, it will require less work.
Imported from legacy forums. Posted by André (had 240 views)