I am using vb.net 2005 and I have a sql express database table I have named "Clients". Every so often I need to add a new column to the Clients database table programatically, which I can do ok.
The problem is getting the existing ClientsDataSet on the VB Form [Design] Screen to update programatically to include the new column in the Clients Table in the Dataset Designer, and to include the new column in the ClientsTableAdapter query.
I have searched the web and have worked out how to update the schema with Fillschema, but this is for newly created datasets and datatables, not existing.
Can someone please explain how to programatically update an existing dataset table and tableadapter attached to a VB Form, to include a new column added into a sql database table?