Table Name- student
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
// To allow this Web Service to be
called from script, using ASP.NET AJAX, uncomment the following line.
public class Service : System.Web.Services.WebService
//Uncomment the following line if using
con = new
Catalog=akshay;Persist Security Info=True;User ID=sa;Password=wintellect");
cmd = new
SqlCommand("delete from student where sn="
+ sn + " ", con);
int roweffected = cmd.ExecuteNonQuery();
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
Step 4 : Click on GetDelete Button
to test the web service.
Enter the value of Sn to test the web
By pressing the "Invoke" button a XML file is
The '1' respond to our data is deleted in specific DataBase table (here "student") see here.
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.
Name the web site; for example here I have chosen the
name "MyTest" and clicked on the "ok" button.
Step 6 : Right-click in the Solution Explorer and Choose "Add Web Reference":
Step 7 : Past
the url of the web service and click on "Green arrow" button and then "Add
Step 8 : Now your web service is ready for
use; you can see it in the Solution Explorer.
Step 9 : Go to the design of the
Default.aspx page; drag and drop one TextBox, one Button and a Lable.
Rename the Button as 'Delete'.
Step 10 : Go to the 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);
localhost.Service myservice =
int temp= myservice.GetDelete(sn);
if (temp== 1)
"Record is Deleted";
"Record is not Deleted Please Try Again";
Step 11 : Pressing
the F5 function key to run the website, you will see:
Enter the value of TextBox.
Press the Delete Button.
The record is deleted; you can check it from your database.