A XML Web service that update data into a Default table of the application


Introduction

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

First go through SQL Server and make a table;

The following snapshot show the process.

img 1.gif

Database- akshay
Table Name- student

Creating XML Web Service in .Net

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

Step 1 : Create the ASP.NET Web Service Source File.

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 "MyWebService". Then Click the ok Button. A screen-shot of this activity is shown be.

img2.gif

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

img3.gif

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 "GetUpdate" which returns an 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;
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// 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 Service : System.Web.Services.WebService

    SqlConnection con;
    SqlCommand cmd;
    public Service()
    { 
        //Uncomment the following line if using designed components
        //InitializeComponent();
    }
    [WebMethod]
    public int Getupdate(int sn, int batch, string year)
    {
        con = new SqlConnection(@"Data Source=.;Initial Catalog=akshay;Persist Security Info=True;User
ID=sa;pwd=wintellect"
);
        con.Open();
        cmd = new SqlCommand("update student set batch=" + batch + ",year='" + year + "' where sn=" + sn + "",
con);
        int roweffected = cmd.ExecuteNonQuery();
        return roweffected;
    }
}

Step 3 : Build Web Service and Run the Web Service for testing by pressing F5 function key.

img4.gif

Copy the url of this web service for further use.

Step 4 : Click on Getmember Button to test the web service.

img5.gif

Enter the value of Sn,batch and year to test the web service.

img6.gif

By pressing the "Invoke" button a XML file is generated.

img7.gif

The '1' respond to our data is inserted in specific  DataBase table (here "Student") see here.

img8.gif

Now our web service is ready to use. We just need to create a new web site to consume the web service.

Example of Testing Web Service in .Net

Step 5 : Create a Test Web Site by File > New > Web Site > ASP.Net Web Site.

img9.gif

Named the web site, for example here I have chosen name "MyTest" and click on 'ok' button.

Step 6 : Right Click Solution Explorer and Choose "Add Web Reference":

img10.gif

Step 7 : Past the url of the web service and click on "Green arrow" button and then "Add reference".

img11.gif

Step 8 : Now your web service is ready to use in the Solution Explorer you will see.

img12.gif

Step 9 : Go to the design of the Default.aspx page; drag and drop three TextBoxes, one Button and a Lable.

img13.gif

Rename the Button as 'Update'.

step 10 : Go to Default.cs page and on the button click event use the following code.

protected void Button1_Click(object sender, EventArgs e)
{
    int sn = Convert.ToInt32(TextBox1.Text);
    int batch = Convert.ToInt32(TextBox2.Text);
    string year = TextBox3.Text;
    localhost.Service myservice = new localhost.Service();
    int temp= myservice.Getupdate(sn,batch,year);
    if (temp== 1)
        {
           Label1.Text = "record is update";
        }
    else
       {
           Label1.Text = "record is not update";
       }
}

Step 11 : Pressing the F5 function key to run the website, you will see.

img14.gif

Enter the value of TextBoxes.

img15.gif

Press the Update Button.

img16.gif

The record is saved you can check it from your database.

img17.gif


Resources

Next Recommended Readings