Solved

How to add a MS SWL table to an existing Dataset

Posted on 2009-07-13
2
232 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 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