Best way to handle handle database schema change for generated dataset

refer to : http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/thread/339fbbc6-4f28-4f99-83fc-bdc647f56310

 

 

Problem Discription : When we update the database table schema, the *.xsd file is not being update at the same time, So how can we refresh our dataset schema, there is a way to do.

 

 

(1) Open DataSet design surface

 

(2) Drop the old table from DataSet design surface

(3) Create a connection to database at Server Explorer

(4) Re-drag table from Server Explorer to DataSet design surface