Solved

How to add a MS SWL table to an existing Dataset

Posted on 2009-07-13
2
225 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 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

15 Experts available now in Live!

Get 1:1 Help Now