Solved

How to add a MS SWL table to an existing Dataset

Posted on 2009-07-13
2
226 Views
Last Modified: 2013-11-26
I have an already created dataset in Visual Studio that has 3 tables. I've added a 4th table in MS SQL. How do I update the dataset scheme to include this 4th table. I didn't want to create a new dataset because I don't want to loose my custom table adapters.
0
Comment
Question by:prothera
2 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24849602
If you are talking about a typed DataSet, then you should be able to add the 4th table to the designer, without losing anything, but I would make a backup copy of the .xsd and related files first.
0
 

Accepted Solution

by:
prothera earned 0 total points
ID: 24898430
Yes, that's what I would like to do, but you don't say how to add the 4th table to the designer. I finally got the answer from a programmer buddy. Once the Data Source is open and the new table is in the list, just drag and drop it into the DataSet.xsd. Then the table adapter is created. Thanks for taking the time to post a solution.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access Web appliction 7 46
Open a word document 23 33
Runtime Error 2 27
Error on Add method 1 37
Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now