Introduction

In this article I am going to make a XML Web service that inserts data into a Default table of the application. For the basics of XML Web Services read my last article. Click Here

First go through SQL Server and make a table;

The following snapshot shows the process.

Database- akshay

Table Name-member

Creating XML Web Service in .Net

Here is sample code which I use to create and consume ASP.NET Web Service:

Open Visual Studio 2010 and create  a new web site.->Select .Net Framework 3.5. ->Select ASP.NET Web Service page -> Then, you have to give the name of your service. In this example I am giving it the name "mywebservice1". Then Click the ok Button. A screen-shot of this activity is shown below:

Step 2 : Click on the "OK" Button. You will see the following window:

Here (in the above figure), you will note that there is a predefined method "HelloWorld" which returns the string "Hello World". You can use your own method and can perform other operations. Here I made the simple method "SaveData" which returns a integer value.

Service.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
namespace MyWebService1
{
    /// <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;
        SqlCommand cmd;
        [WebMethod]
        public int SaveData(int pid, string pna, string ad)
        {
            con = new SqlConnection(@"Data Source=.;Initial Catalog=akshay;Persist Security Info=True;User
ID=sa;pwd=wintellect");
            con.Open();
            cmd = new SqlCommand("insert into member values(" + pid + ",'" + pna + "','" + ad + "')", con);
            int temp = cmd.ExecuteNonQuery();
            return temp;
        }
    }
}

• ASP.NET Web Service Basics.
• A XML Web Service That Exposes The Default Table From Sql Server Data Base.
• An Introduction to Windows Communication Foundation (WCF).
• ATL COM Component, ASP.NET Web Service, and VB Client.