Now you have to create a WCF Service:
- Go to Visual Studio 2010
- New-> Select a project
![img1.jpg]()
Now click on the project and select WCF Service Application and provide a name for the service:
![img2.jpg]()
Now click on the Ok Button. Then you will get 3 files in Solution Explorer.
- IService.cs
- Service.svc
- Service.svc.cs
The following image shows the following files:
![img3.jpg]()
For inserting data into the database you need to write the following code in the IService1.cs file which contains the two sections:
- OperationContract
- DataContract
The OperationContract section is used to add service operations and DataContract is used to add types to service operations.
Iservice1.cs File
Now we create a function in the OperationContract section of the Iservice1.cs file:
public interface IService1
{
[OperationContract]
string InsertUserDetails(UserDetails userInfo);
}
Now add types to service operations in the DataContract section:
public class UserDetails
{
string username = string.Empty;
string password = string.Empty;
string country = string.Empty;
string email = string.Empty;
[DataMember]
public string UserName
{
get { return username; }
set { username = value; }
}
[DataMember]
public string Password
{
get { return password; }
set { password = value; }
}
[DataMember]
public string Country
{
get { return country; }
set { country = value; }
}
[DataMember]
public string Email
{
get { return email; }
set { email = value; }
}
}
Service.svc.cs File
In this file we define the definition of the function InsertUserDetails(UserDetails userInfo).
And replace the code with the following:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace WCFServiceForInsert
{
// NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Service1" in code, svc and config file together.
public class Service1 : IService1
{
public string InsertUserDetails(UserDetails userInfo)
{
string Message;
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Rajesh;User ID=sa;Password=wintellect");
con.Open();
SqlCommand cmd = new SqlCommand("insert into RegistrationTable(UserName,Password,Country,Email) values(@UserName,@Password,@Country,@Email)", con);
cmd.Parameters.AddWithValue("@UserName", userInfo.UserName);
cmd.Parameters.AddWithValue("@Password", userInfo.Password);
cmd.Parameters.AddWithValue("@Country", userInfo.Country);
cmd.Parameters.AddWithValue("@Email", userInfo.Email);
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
Message = userInfo.UserName + " Details inserted successfully";
}
else
{
Message = userInfo.UserName + " Details not inserted successfully";
}
con.Close();
return Message;
}
}
}
Testing the Service
Press F5 to run the service. A WCF Test Client form will be displayed and it will load the service.
![img4.jpg]()
Now double-click the InserUserDetails() method under IService1. The InserUserDetails tab will be displayed.
![img5.jpg]()
The service was added successfully.
Now open the service in the browser.
Now right-click on the service1.vcs-> open in browser:
![img16.jpg]()
Now copy the URL.
http://localhost:2268/Service1.svc
Step 3: Create web Application (Accessing the Service)
Now, you have to create a web site.
- Go to Visual Studio 2010
- New-> Select a website application
- Click OK
![image1.gif]()
Now add a new page to the website:
- Go to the Solution Explorer
- Right-click on the Project name
- Select add new item
- Add new web page and give it a name
- Click OK
![image2.gif]()
Add the service reference in web application
Now add the service reference.
![img7.jpg]()
When we click on the add the service reference the following window will be opened:
![ing9.jpg]()
Now paste the above URL in the address and click on the go Button.
![img8.jpg]()
Click on the ok Button. Now the reference has been added in the Solution Explorer.
![img10.jpg]()
Now create a new website and drag and drop controls onto the aspx page. The aspx code is the following:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Registration.aspx.cs" Inherits="Registration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table width="84%" cellpadding="0" cellspacing="0" style="border: solid 1px #3366CC;">
<tr>
<td colspan="4" style="height: 30px; background-color: #f5712b;">
<span class="TextTitle" style="color: #FFFFFF;">Registration Form</span>
</td>
</tr>
<tr>
<td height="20px" colspan="0">
</td>
</tr>
<tr>
<td width="50%" valign="top">
<table id="TableLogin" class="HomePageControlBGLightGray" cellpadding="4" cellspacing="4"
runat="server" width="100%">
<tr>
<td colspan="3" align="center">
<asp:Label ID="LabelMessage" ForeColor="Red" runat="server" EnableViewState="False"
Visible="False"></asp:Label><br>
</td>
</tr>
<tr style="font-weight: normal; color: #000000">
<td align="right">
<span>UserName:</span>;
</td>
<td align="left" style="padding-left: 10px;">
<asp:TextBox ID="TextBoxUserName" runat="server" CssClass="textbox" Width="262px"
MaxLength="50" Height="34px"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right">
<span class="TextTitle">Password:</span>
</td>
<td align="left" style="padding-left: 10px;">
<asp:TextBox ID="TextBoxPassword" runat="server" CssClass="textbox" Width="261px"
MaxLength="50" TextMode="Password" Height="34px"></asp:TextBox>
<br />
</td>
</tr>
<tr>
<td align="right">
<span class="TextTitle">Country:</span>
</td>
<td align="left" style="padding-left: 10px;">
<asp:TextBox ID="TextBoxCountry" runat="server" CssClass="textbox" Width="258px"
MaxLength="50" Height="34px"></asp:TextBox>
<br />
</td>
</tr>
<tr>
<td align="right">
<span class="TextTitle">Email:</span>
</td>
<td align="left" style="padding-left: 10px;">
<asp:TextBox ID="TextBoxEmail" runat="server" CssClass="textbox" Width="258px"
MaxLength="50" Height="34px"></asp:TextBox>
<br />
</td>
</tr>
<tr>
<td align="right">
</td>
<td align="left" style="padding-left: 10px;">
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" Width="87px" />
<br />
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
The form looks like:
![img11.jpg]()
Double-click the Button, and add the following code in the Click event handler:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using ServiceReference1;
public partial class Registration : System.Web.UI.Page
{
ServiceReference1.Service1Client objServiceClientobjService = new ServiceReference1.Service1Client();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
UserDetails userInfo = new UserDetails();
userInfo.UserName = TextBoxUserName.Text;
userInfo.Password = TextBoxPassword.Text;
userInfo.Country = TextBoxCountry.Text;
userInfo.Email = TextBoxEmail.Text;
string result = objServiceClientobjService.InsertUserDetails(userInfo);
LabelMessage.Text = result;
}
}
Now run the application.
Press CTRL+F5 to run the project:
![img15.jpg]()
Now enter the UserName, Password, country and Email and click on the button.
![img12.jpg]()
Data has been inserted into the SQL Server database table and check it.
![Clipboard14.jpg]()