How to Delete Data from Database Using XML Web Service

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 Services.

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 screenshot 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 a simple method "GetDelete" 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
{
public Service()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
SqlConnection con;
SqlCommand cmd;
[WebMethod]
public int GetDelete(int sn)
{
con = new SqlConnection(@"Data Source=.;Initial Catalog=akshay;Persist Security Info=True;User ID=sa;word=wintellect");
cmd = new SqlCommand("delete from student where sn=" + sn + " ", con);
con.Open();
int roweffected = cmd.ExecuteNonQuery();
return roweffected;
}
}

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

Copy the url of this web service for further use.

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