PC Review


Reply
Thread Tools Rate Thread

How to design Dataset schema from sproc w/multiple tables?

 
 
=?Utf-8?B?Qy4gQ29yZG92YQ==?=
Guest
Posts: n/a
 
      12th Dec 2005
In VS2003, I could drag a stored procedure from the Server Explorer into the
dataset designer and generate an XML schema for all tables returned from the
procedure. VS2005 will only generate a single table schema using this
process even though the procedures return multiple tables.

I have not found a way to accomplish the same thing in VS2005 and would like
to know if anyone has figured this out.

I do know that I can use the dataset.writexmlschema method, but this is not
as efficient as dragging a sproc to the design surface.

Ideas?

Thanks!

C. Cordova


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Schema-Typed Dataset doesn't preserve nested tables order sunstormlabs@gmail.com Microsoft ADO .NET 1 18th Dec 2007 09:47 AM
DataSet Designer/adding multiple tables to a dataset/ how? =?Utf-8?B?Q3VydGlz?= Microsoft ADO .NET 1 21st Aug 2006 02:09 PM
How to Fill Dataset with results from sproc with multiple selects =?Utf-8?B?REo=?= Microsoft ADO .NET 4 29th Nov 2005 06:57 PM
Multiple tables from single sproc in 2005 (2.0) =?Utf-8?B?SmFzb24=?= Microsoft ADO .NET 5 11th Oct 2005 12:43 AM
Fill DataSet tables from one SPROC Raterus Microsoft ADO .NET 2 3rd May 2005 06:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:40 PM.