vs2005 - How to update a dataset xsd after table changes


D

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__Instance__[T](T
Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190
at QmsUserInterface.My.MyProject.MyForms.get_QuotesOverview()
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.WindowsFormsApplicationBase.OnRun()
at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at
Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.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.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object
state)
at System.Threading.ExecutionContext.Run(ExecutionContext
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top