Generating XML using XSD schema and output of ResultSet
843834Jun 3 2005 — edited Sep 7 2007Hi,
There is a requirement in my project to generate XML based on XSD schema. Generated XML will contain data which will be returned by a Stored Procedure or SQL Query.
The catch for this is XSD and Stored Procedures should be easily plugable. What I mean from this is, the XML building utility which I need to write will have XSD and a Stored Procedure as an input which can be changed at runtime.
So the people using this utility can pass XSD and a Stored Procedure as an input and the program should generate XML out of it.
Please let me know how can I achieve this
Thanks and Regards
Unmesh