I have made a database in SQL Server 2008 R2.
Then i made a Windows Form Application using Visual Studio 2010.
Now i made a change to the database structure, by deleting 4 tables, and adding 2 new tables.
When i goto Visual Studio 2010, the data source shows the old tables. When i try to load new data source, then a new DataSet is created, for which i shall have to create new forms, and new code all over again.
I want to be able to update my old Data Source, and make changes to Windows Forms associated with tables, that I have deleted and added. Any way out?