Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to add a MS SWL table to an existing Dataset

Posted on 2009-07-13
2
Medium Priority
?
237 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

579 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