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.
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 "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.
Copy the url of this web service for further
use.
Step 4 : Click on Getmember Button
to test the web service.
Enter the value of Sn,batch and year to test the web
service.
By pressing the "Invoke" button a XML file is
generated.
The '1' respond to our data is inserted 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.
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":
Step 7 : Past
the url of the web service and click on "Green arrow" button and then "Add
reference".
Step 8 : Now your web service is ready to
use in the Solution Explorer you will see.
Step 9 : Go to the design of the
Default.aspx page; drag and drop three TextBoxes, one Button and a Lable.
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.
Enter the value of TextBoxes.
Press the Update Button.
The record is saved you can check it from your database.