return xml in sql query

See more:

SQL-Server

SQL-Server-2008

Hi,

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