I have an application where C# windows client sends an xml file to MSSQL based webservice. I passed the file as byte to webservice. WS converted it to filestream and inserted to xml datatype column using sqlxml.
When I checked the xml file stored in DB the <?xml ...> tag was missing.
THIS is first issue. Please help.
Then I want to get the xml file documents back from webservice.
How can I do that?
Please advice .
I am using VS 2008 and MS SQL 2005