You must Sign In to post a response.
  • Category: Webservices

    How to create web service to get data from soap message to SQL DB?

    Hi All,

    I never worked on web service before. Could you please help me?

    I have XML file(SOAP message) and I want to get data from this file and insert it to SQL table via Web Service.

    So, how can i do this?
  • #757757
    If the data is coming in the format of XML then you can get it in a file then can read the data from file.


    Please refer a below sample code


    social.msdn.microsoft.com/Forums/windowsapps/en-US/7ac29a93-8280-4920-bd4f-9a7135ef4e31/reading-xml-from-web-service-c?forum=wpdevelop

    Thanks & Regards
    Anil Kumar Pandey
    Microsoft MVP, DNS MVM

  • #757759
    Simply you can create one webservice with webmethod where you can pass xml data.
    In webmethod you can write the code to passing that xml data into stored procedure using ADO.net and in stored procedure you can use xml parse document and insert into actual database table.

    Regards & thanks
    Arvind kumar
    Visit--blog.akumars.esoftera.in

  • #757763

    Web services use XML to code and decode your data and SOAP to transport it using open protocols, Using Web services, your application can publish its function or message to the rest of the world.
    you need to follow following things to accomplish your task
    1.Create a Web Site project
    2.Add a Web Reference
    3.Call the Web services APIs inside the code
    for more detail of webservice switch to following link
    http://www.codeproject.com/Articles/22760/Calling-Web-Service-using-ASP-NET


    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #758171
    Thanks for your suggesstions. :D


  • Sign In to post your comments