this is my query for returning xml .
select distinct ProductId, (ProductName),ProductImage from ProductMaster where Approved='true' order by ProductName for xml path('product'),root('ProductInfo')
It displays the proper format in sql server management studio. but when i place that query in asp.net web services it won;t displays the proper format i.e the data is broken.
Please help me.
Thanks in advance
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)