Update datasource after changes to underlying tables

Question

question

BobJones-1342 asked Apr 20, '22 BobJones-1342 commented Apr 20, '22

Update datasource after changes to underlying tables

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?

vs-general windows-forms

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-20T19:12:09.177Z

karenpayneoregon answered Apr 20, '22 BobJones-1342 commented Apr 20, '22

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

f1.png (10.1 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BobJones-1342 · Apr 20 at 08:29 PM

Thanks, I tried that initially and it didn't work.
However, I went back in and after selecting "Configure Data Source with Wizard" I opened each individual table and then was able to see the additions and check the boxes for added columns, etc. After selecting the additions they showed up correctly.

Thank you!

0 ·

data.png (17.4 KiB)

question