PC Review


Reply
Thread Tools Rate Thread

generate xsd file form stored procedure

 
 
Vicky
Guest
Posts: n/a
 
      21st May 2004
How can we genrate a xsd from a stored procedure in VS.net.
Is any way by which dataset code is autogenerated for a specific stored
procedure.


 
Reply With Quote
 
 
 
 
Cowboy
Guest
Posts: n/a
 
      21st May 2004
There is no autogen tool, if that is what you are asking. There may be a
third party tool, or you could create your own.

You can query the parameters and send in bogus information to create a
DataSet and create the XSD file using WriteXmlSchema(). This would work for
code gen.

You can also create the routine that gets the DataSet and simply write out
the XSD using WriteXmlSchema().

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Vicky" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How can we genrate a xsd from a stored procedure in VS.net.
> Is any way by which dataset code is autogenerated for a specific stored
> procedure.
>
>



 
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
How to make CLR stored procedure generate comments in TSQL when it is deployed via visual studio? DR Microsoft Dot NET 0 8th Apr 2008 03:55 AM
How to generate a dataset from stored procedure which have many resultsets? abc my vclass Microsoft ADO .NET 1 27th Dec 2005 05:20 PM
How to generate a dataset from stored procedure which have many resultsets? abc my vclass Microsoft C# .NET 0 27th Dec 2005 01:10 PM
Generate DataSet does not work for Select Stored Procedure =?Utf-8?B?RXZlcnQgV2llc2VuZWtrZXI=?= Microsoft ADO .NET 5 22nd Dec 2004 10:09 AM
Macro to Generate OleDbCommand for a Stored Procedure call Nimai Malle Microsoft ADO .NET 0 1st Sep 2004 03:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:09 PM.