vs2005 - How to update a dataset xsd after table changes

[dbuchanan]

Hello,

How to I update a table or tableAdapter in my dataset1.xsd after I have
added new columns to the underlying table?

I refreshed the datasource in server explorer - it worked there but had
no effect on my dataset.

I tried to refreshed the dataset in Data Sources window - nothing
happened - the new columns do not show.

With a copy of the database (made a backup) I tried to replace the old
table/tableAdapter by deleting the old one and draging in the updated
(refreshed) table from server explorer but then the upstream
relationships are not recognized in the DataSources window! And they
are not recognized by my forms even after I recreate the relationships
in the dataset1.xsd using the same name.

I don't want to remake the entire dataset and reconfigure every one of
the table adapters and addtional queries.

What do I do?

Here is the error:
An error occurred creating the form. See Exception.InnerException for
details. The error is: DataMember property
'FK_tbl020Version_tbl010Quote' cannot be found on the DataSource.

Here is the error text:
System.InvalidOperationException was unhandled
Message="An error occurred creating the form. See
Exception.InnerException for details. The error is: DataMember
property 'FK_tbl020Version_tbl010Quote' cannot be found on the
DataSource."
Source="QmsUserInterface"
StackTrace:
at QmsUserInterface.My.MyProject.MyForms.Create__Inst ance__[T](T
Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190
at QmsUserInterface.My.MyProject.MyForms.get_QuotesOv erview()
at QmsUserInterface.My.MyApplication.OnCreateMainForm () in
D:\DBuchanan MyDocuments\Visual Studio 2005\Projects\Qms_01\QmsUI\My
Project\Application.Designer.vb:line 35
at
Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.OnRun()
at
Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.DoApplicationModel()
at
Microsoft.VisualBasic.ApplicationServices.WindowsF ormsApplicationBase.Run(String[]
commandLine)
at QmsUserInterface.My.MyApplication.Main(String[] Args) in
17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[]
args)
at System.AppDomain.ExecuteAssembly(String assemblyFile,
Evidence assemblySecurity, String[] args)
at
Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context( Object
state)
at System.Threading.ExecutionContext.Run(ExecutionCon text
executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

By the way all my stored procedures have been properly updated with the
two new rows added.

Thank you,
dbuchanan