Create WCF service with database
Example to create WCF service with database
Create a new WCF service with the name example 3
Change the interface name to I emp details 
change the class name to cls emp details change the SVc file name to cls emp details SVC
Write the following code in interface class
i.e. I emp details.cs
using system data;
[service contract]
Public interface I emp details
{
[operation contract]
Data table get data();
}
Go to emp details.cs file & write the following using system.data;
Using system.data;
Using system. Data. Sqlclient;
Public class cls emp details: I Emp details
{
Public data table get data()
{
Sql connection . con = new sql connection (“----“);
Sql data adapter da =new sql data adapter (“ select from emp details”, con;
Data set Ds = new datsaset();
Da.fill (Ds, “emp details);
Return ds. Table [0];
}}
Creating client component:-
Create a new web with the name check exmaple3 design the page add reference to cls empdetails.svc service reference name as “SR1”
Using SR1;
Protected void btn get data_click (--)
{
Emp Details client Obj1 =new emp de tails client ();
Gridview. Data source = obj 1. Get data();
Grid view 1 . dta bind();
}
Run the application & check.
Example to create a WCF service to perform the operations on database:-
Client design:-
Creating WCF service / server component:-
Create a new WCF service with the name example 4
Change the interface name from I service.cs to I empdetails.cs change the class name from service.cs to cls emp details.cs change the service file name from service.svc to clsemp details.svc go to the file I emp details.cs & write the following code
[service contract]
Public interface I empdetails
{
[operation contract]
Int insert rec (emp data obj1);
[operation contract]
Int insert rec (emp data obj1);
[operation contract]
Int delete rec (emp data obj1);
}
[data contract]
Public class emp data
{
Int cls empid, cls deptno;
String cls ename, cls designation;
Datatime cls Doj, double clssalary ;
[data member]
Pblic in p emp id
{
set { cls em pid = value;}
[data member]
Public string PE name
{
Set { cls e name = value;}
Get { return cls e name:}
}
[data member]
Public string p designation
{
set { cls designation = value ;}
Get { return cls designation;}
}
[datamember]
Public datatime PDOJ
{
set{ cls Doj = value;}
Get{ return clas Doj:}
}
[data member]
Public double psalary
{
[data member]
Public double psalary
{
set { cls salary = value :}
Ge { return clssalary;}
}
[data member]
Public int p dept no
{
set{ cls deptno = value;}
Ge { return cls deptno;}
}}
Go to cls empdetails.cs class write the following to implement IEmp details interface members using system. Data;
Using system.data. sqlclient;
Public class cls empdetails :IE mpdetails
{
sql connection con=new sqlconnection (“---“);
Sqlcommand cmd;
Public int Insertrec (emp data obj1)
{
String s = “insert into emp details values (“ PEmpID + “,” + obj1. PE name + obj1/ p designation + “ ‘,’ “ + obj 1 “ ‘, “ + obj1. Psalary + “,” + obj1 +”)” ;
Cmd = new sql command (s,con);
Con.open();
Int ; = cmd. Execute non query ();
Con. Close ();
Returen I;
}
Public int update Rec (emp data obj1)
{
string s = “ update emp details set Ename = ‘ “ + Pe name + “ ‘, designation = ‘” + obj 1. Gnation + “’, DOJ = ‘” + obj 1 PDOJ + obj1.pdeptno + “ where empID = “ + objs.pempID;
Cmd = new sqlcommand (s,con);
Con.open();
Int I = cmd. Execute non query ();
Con. Close();
Return I;
}
Public int delete rec (empdata obj1)
{
String s = “delete emp details where emp ID = “ + obj1. Pemp id;
Cmd = new sqlcommand (s, con);
Con.open();
Int I = cmd. Execute nonquery ();
Con. Close();
Return I;
}}
Example to create a client to perform the database operations
Create a new website with the name check example 4
Design the webpage add reference to cls empdetails.svc WCF service with reference name as SR1 write the following code
Using SR1;
Empdetails client objs = neco empdetails client();
Emp data objD = new emp data();
Protected void btn instert_click(-----){
objD.PE mp ID = convert. Toint32 (txt emp ID. Text);
objd. PeName = txtEName.text;
objD.p designation = txt designation.text;
objed.PDOJ = convert. To Date time (txtDOJ.Text);
objd.psalary = convert. To double (txtsalry. Text);
ObjD.pdeptno = convert. TOInt32 (txtdeptno.text);
Int I = objs. Insertrec (objD);
Lbldisplay. Text = I + “Record (s) Inserted”;
Crotected void btnupdate – click (---){
objD.PEm PID = convert . TOInt32 (txtempID.text);
objD. PEName = texename. Text;
objD.pdesignation= textdesignation.text;
objD- PooJ= convert. Todatetime (txtdoj.text);
ObjD.psalary = Convet. ToDouble (txtsalry. Text);
Objd. Pdeptno = convert. TOIrt32 (txtdeptno. Text);
Int I = objs. Updaterec (objD);
Laldisplay. Text = I + “record (s) updated”;
} protected void btndelete-click(----)
{ objd.PempID = convert. TOI nt 32 (txt emp ID. Text);
Int I = objs. Deleterec (objD);
Lbldisplay. Text = I + “record (s) deleted”;