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