Generate XML from XSD for data from table/view(SqlServer)

Question

Hi All I want to generate XML from XSD(complex) as per data available from SqlServer(Table/View) We have only XSD and data need to generate XML. I also looked into Oxygen/Altova to get something but not found any good solution. Pls Let me know if there any solution.... or any query related to requirement or clarification feel free to ask thanks Navneet Singh

Sundar · Answer

Hai https://www.codeproject.com/Articles/400016/Generate-Sample-XML-from-XSD Follow this link this may helps you. Thanks in advance.

navneet Singh · Answer

Hi Sunder I m able to generate XML from XSD. but need to bind data that comming from view in this generated XML... so i m looking for something that we define that this view column bind with this XSD ffield/node to generate XML with view data same structure as define in XSD... thanks Navneet Singh