Insert and search
from database using WCF:
INTRO:
Windows Communication Foundation
is an acronym of WCF.
Basically WCF is based on Service
Oriented Architecture(SOA). It is a technology to develop applications that are
based on SOA.
A WCF clients connect to WCF
through an Endpoint. Endpoint contains Address, Binding, and Contracts. We can
use ABC to remember these keywords.
Address: Address denotes the
address of WCF Service. The address contains
two elements: address of the service
and the transport protocol, used to communicate with the service.
Binding: Binding denotes how communication done between service and
client, means what protocol is used to
access the service. Protocols like HTTP, TCP, MSMQ etc.
Contracts: Contract means
agreement between two parties . Similarly in WCF it is the agreement between
client and service. Contract defines
what service does. It have method definition
and return type and data. Mainly it contains,
Service Contract
Operation Contract
Data Contract
Data Member
About Application: In this application you can add new student to
database and search name using student id.
Lets Start:
Table name: Student
Id is primery key (int)
Name is varchar(50)
To create WCF Service Firstly
creates Interface that contains Service in IService1.cs:
using
System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;
namespace WcfService2
{
[ServiceContract]
public interface IService1
{
[OperationContract]
string setdata(student
s);
[OperationContract]
student getdata(string
nm, int i);
}
[DataContract]
public class student {
int _id;
string _name;
[DataMember]
public int Id {
get {
return _id;
}
set {
_id = value;
}
}
[DataMember]
public string Name {
get {
return _name;
}
set {
_name = value;
}
}
}
}
Now, implement that interface in Service1.svc
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.Configuration;
namespace WcfService2
{
public class Service1 : IService1
{
string con = ConfigurationManager.AppSettings["con"];
SqlConnection conn;
public string
setdata(student s)
{
try
{
conn = new SqlConnection(con);
conn.Open();
SqlCommand com = new
SqlCommand("insert
into student (name) values(@student)", conn);
com.Parameters.AddWithValue("@student", s.Name);
com.ExecuteNonQuery();
return "inserted";
}
catch (Exception
ex)
{
return ex.ToString();
}
finally {
conn.Close();
}
}
public student
getdata(string nm,int
id)
{
student s = new student();
try
{
conn = new SqlConnection(con);
SqlCommand com = new SqlCommand("select name from student where id=@id",
conn);
conn.Open();
com.Parameters.AddWithValue("@id",
id);
SqlDataReader read =
com.ExecuteReader();
read.Read();
s.Name = read[0].ToString();
s.Id =Convert.ToInt32( id);
return s;
}
catch (Exception
ex)
{
s.Name = "no result found";
return s;
}
finally {
conn.Close();
}
}
}
}
Then add new project in WCF
service solution and add new web application
Add following code in web
form.aspx file inside form tag:
Id<asp:TextBox runat="server"
ID="sid">
</asp:TextBox>
<asp:Button ID="search" Text="search"
runat="server"
onclick="search_Click"
/><br />
<asp:Label runat="server"
ID="name">
</asp:Label><br />
<asp:Label runat="server"
ID="id"></asp:Label>
</div>
<hr />
<br />
Name<asp:TextBox ID="inm" runat="server"></asp:TextBox>
<asp:Button ID="insert" runat="server"
Text="insert"
onclick="insert_Click"
/>
<asp:Label runat="server"
ID="res"></asp:Label>
Now ASP page looks like :
In code behind file add the
following code:
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.ServiceModel;
using
WebApplication2.ServiceReference2;
namespace
WebApplication2
{
public partial class WebForm1 : System.Web.UI.Page
{
protected
void Page_Load(object
sender, EventArgs e)
{
}
protected
void search_Click(object
sender, EventArgs e)
{
Service1Client
client = new Service1Client();
student
s = new student();
s= client.getdata("",Convert.ToInt32(sid.Text));
name.Text=s.Name;
id.Text=s.Id.ToString();
}
protected
void insert_Click(object
sender, EventArgs e)
{
Service1Client
client = new Service1Client();
student
s = new student();
s.Name = inm.Text.ToString();
string
res=client.setdata(s);
this.res.Text
= res;
}
}
}
You have to copy this line by right
clicking on Service1.svc file and click on option View in Browser: Service1Client client = new
Service1Client();
Now, right click on Service1.svc
file and click on option View in Browser:
And copy address
IN Web application right and
select option ADD SERVICE REFERENCE
Paste copied address in new open
small window like this and press GO
button:
Now right click on webapplication
and select set as startup project
Then set webform.aspx page as a start page and
run project.
