>As for getting the XSD from a stored procedure, just create a new DataSet, and use a SqlDataReader to read it into an UnTyped DataSet, and then WriteXmlSchema and there is the XSD from the results of your stored procedure
Two questions
Using an SqlDataReader was as far as I got in my thinking - is there a method or technique I'm missing to get the data from the reader into the untyped DataSet? I could grab each record, loop through the columns and using GetType() and the various GetXX functions create a DataRow to insert into the DataSet, but if there's an easier way...
Second, because it's an untyped DataSet, couldn't there be an error in the XSD? Isn't the DataSet "inferring" the Schema from the actual data, and not the schema from the underlying data store?
Thanks, Morgan.
>>-Steve->>
Steve Sawyer
Geeks and Gurus, Inc.