how to store retrieve xml file into database by using webservices in .net?

Question

Mahesh Chand · Answer

This question is not clear so I will write a general answer. I assume you have a column in your database that stores the contents of XML files. You need to create a Web Service using Visual Studio 2005 (or whatever version you are using). This Web service should have two methods. Let's call them - GetXmlFileData and SaveXmlFile. In GetXmlFileData method you will open a connection with your database using ADO.NET and get the value of the table and column(s) from the database. This method can return a DataSet itself that can have all rows from the table or selected rows depending on your query. The contents of a DataSet can be read into an XML fragment and you can easily convert them to a XmlReader and save as XML file. See my references below on how to do it. Now in your SaveXmlFile method you will read an XML document using the reader and pass the content of it in method as an XmlDocument or XmlNode or text. Whatever you like. Then your SaveXmlFile method will call ADO.NET database stored procedure or query depending on your implementation and will save in the database. I hope this gives you some pointers and direction. Recommended References and Readings: If you don't know how to create a Web Service in C# start here: Tutorial: Introduction to Web Services by Ashok Kumar P on Jan 30 2007 A tutorial explains basics of web services followed by sample example. Chapter 31:Creating Web Services by Praveen Moosad on Apr 29 2008 This chapter provides an overview of web services and the problems they solve and how to create and consume them in ASP.NET. ------------------------------ If you do not know how to read and write XML contents read this tutorial: Reading and Writing XML Documents Here are many more code samples articles and tutorials: XML Programming in C# and .NET

how to store ,retrieve xml file into database by using webservices in .net?