C# webservice using XmlDocument as parameter to insert data to SQL Server table.

Refer below article

Insert (Upload) XML file Data into SQL Table using Stored Procedure in ASP.Net using C#, VB.NET

If above link wont help you then explain your requirement in more details with an example

Hi:

Thanks for getting back with me!

My real problem is this error message:

Error1'ConsoleApplication1.WebService1.Service1' does not contain a definition for 'WriteData' and no extension method 'WriteData' accepting a first argument of type 'ConsoleApplication1.WebService1.Service1' could be found (are you missing a using directive or an assembly reference?)C:\Users\timmcd\documents\visual studio 2010\Projects\ConsoleApplication1\ConsoleApplication1\Program.cs2024ConsoleApplication1

Thanks for listening!!

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using ConsoleApplication1.WebService1;
using System.Xml;
 
namespace Database_Connection_Application
{
    class Program
    {
        static void Main(string[] args)
        {
            Service1 webService = new Service1();

            XmlDocument doc = new XmlDocument();
            doc.Load(@"C:\\Users\\timmcd\\XML_INPUT\\WORKFLOW.xml");
            webService.WriteData(doc);
           
            Console.ReadLine();
        }
    }
}



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.Text;

namespace WebService1
{
    /// <summary>
    /// Summary description for Service1
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class Service1 : System.Web.Services.WebService
    {
        SqlConnection con = null;
        SqlDataAdapter adap = null;
        DataSet ds = null;
        [WebMethod]
        public void WriteData(XmlDocument doc)
       
        {
            //PARSE XML AND INSERTS TO SQL TABLE GOES HERE
        }
    }
}

Hello Again:

The error message is different now:

Error1No overload for method 'GetData' takes 1 argumentsC:\Users\timmcd\documents\visual studio 2010\Projects\ConsoleApplication1\ConsoleApplication1\Program.cs2013ConsoleApplication1

See code. Thanks!

//Program.cs
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using ConsoleApplication1.WebService1;
using System.Xml;

namespace Database_Connection_Application
{
    class Program
    {
        static void Main(string[] args)
        {
            Service1 webService = new Service1();

            XmlDocument doc = new XmlDocument();
            doc.Load(@"C:\\Users\\timmcd\\XML_INPUT\\WORKFLOW.xml");
            webService.GetData(doc);
            Console.ReadLine();
        }
    }
}



//Service1.asmx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.Text;

namespace WebService1
{
    /// <summary>
    /// Summary description for Service1
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
    // [System.Web.Script.Services.ScriptService]
    public class Service1 : System.Web.Services.WebService
    {
        SqlConnection con = null;
        SqlDataAdapter adap = null;
        DataSet ds = null;
        [WebMethod]
        public void GetData(XmlDocument doc)
        {
           
        }
    }
}

Please refer below link

http://stackoverflow.com/questions/4896213/passing-xml-document-as-an-parameter-to-web-services-in-c-sharp

also you can pass path as parameter an load it on service side like below

C#

[WebMethod]
public void WriteXMLData(string path)
{
    XmlDocument doc = new XmlDocument();
    doc.Load(path);
    //PARSE XML AND INSERTS TO SQL TABLE GOES HERE
}

I hope this will help you out.