Share via

Update datasource after changes to underlying tables

Bob Jones 21 Reputation points
2022-04-20T14:25:26.01+00:00

Visual Studio 2019
VB win form project

I can't see how to update a data source after making additional changes to the underlying tables.

I have created a locale DB, then created several tables in the DB.
I then create a data source to the DB and tables that I use to populate several DataGridViews on Winforms.
I then realize, that some of my tables need to be modified, adding columns, etc.
After changing the tables, the data source continues to show previous table schema.
I have "refreshed" them but no joy.

There must be a way to update the data source, without having to recreate it and then redo all of my previous coding?

Developer technologies | Windows Forms
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

0 comments No comments

Answer accepted by question author

  1. Karen Payne MVP 35,606 Reputation points Volunteer Moderator
    2022-04-20T19:12:09.177+00:00

    In the Data Source window right click on a table, select Configure Data Source with Wizard, this will pick up on changes.

    194804-f1.png

    Was this answer helpful?


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.