Visual Studio DataSet Designer Refresh Tables

Posted by LnDCobra on Stack Overflow See other posts from Stack Overflow or by LnDCobra
Published on 2010-04-16T12:08:47Z Indexed on 2010/04/16 12:23 UTC
Read the original article Hit count: 971

In visual studio datasource designer(The screen where you have all the UML Diagrams including relations) is there any way to refresh a table and its relations/foreign key constraints without refreshing the whole table?

The way I am doing it at the moment is removing the table and adding it again. This adds all the relations and refreshes all fields.

Also if I change a fields data type, is there a way to automatically refresh all the fields in the datasource? Again without deleting the table and adding it again.

Reason for this is because some of my TableAdapters have quite a number of complex queries attached to them and when I remove the table the adapter gets removed as well including all its queries.

I am using Visual Studio 2008 and connecting to a MySQL database.

© Stack Overflow or respective owner

Related posts about visual-studio-2008

Related posts about dataset-designer