Solved

Add table adapter to .xsd file...

Posted on 2014-10-06
4
465 Views
Last Modified: 2014-10-08
The attached .xsd file has two data tables (Customer and CustomerOrders).

I am trying to duplicate this sample. The columns is CustomerOrders come from 3 tables. I am able to add Customer data table to .xsd file. But I have no idea how I can add CustomerOrders data table.

Question: How can I add CustomerOrders data table to my sample using wizards in vs2012?

xsd file
0
Comment
Question by:Mike Eghtebas
  • 3
4 Comments
 
LVL 33

Author Comment

by:Mike Eghtebas
ID: 40365793
Please see:

16 KB
xsd file

above the image. I should have started my question this way:

The image below (.xsd file) has two data tables (Customer and CustomerOrders)...

The reason I had the word "Attached" was I intended to upload the entire file but EE wouldn't allow files with extention .sln to be uploaded. That is why I settled uploading this image instead.

I have kind of figured out the answer myself. I suppose I wait for a while to get some feedback. And after I get my solution tested I could add it here.

Your feedback on this will be appreciated.

Mike
0
 
LVL 33

Accepted Solution

by:
Mike Eghtebas earned 0 total points
ID: 40368913
Right-click on the .xsd design view to select Add table adapter and use query builder to finalize SQL string and then save it.

Later you can rename the table adapter as CustomerOrders, for example. And also right-click on CustomerOrders to choos add relationship to connect CustomerOrders.CustomerID  to Customers.CustomerID.

Mike
0
 
LVL 33

Author Closing Comment

by:Mike Eghtebas
ID: 40368915
I figured out how to add a table adapter to .xsd file using wizard.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 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

14 Experts available now in Live!

Get 1:1 Help Now