learn programming and many more : Insert and search from database using WCF:

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();