jQuery tutorial for beginners - How to call wcf service using jquery

Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/06/how-to-call-wcf-service-using-jquery.html Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 In this video we will discuss, how to call wcf service using jquery ajax Step 1 : Create SQL Server table and insert employee data Create table tblEmployee ( Id int primary key identity, Name nvarchar(50), Gender nvarchar(10), Salary int ) GO Insert into tblEmployee values ('Mark', 'Male', 50000) Insert into tblEmployee values ('Sara', 'Female', 60000) Insert into tblEmployee values ('John', 'Male', 45000) Insert into tblEmployee values ('Pam', 'Female', 45000) GO Step 2 : Create a stored procedure to retrieve employee data by ID Create procedure spGetEmployeeById @Id int as Begin Select ID, Name, Gender, Salary from tblEmployee where ID = @Id End Step 3 : Create new asp.net web application project. Name it Demo. Step 4 : Include a connection string in the web.config file to your database. <add name="DBCS" connectionString="server=.;database=SampleDB;integrated security=SSPI" /> Step 5 : Add a class file to the project. Name it Employee.cs. Copy and paste the following code. namespace Demo { public class Employee { public int ID { get; set; } public string Name { get; set; } public string Gender { get; set; } public int Salary { get; set; } } } Step 6 : Add a new WCF Service (Ajax-enabled). Name it EmployeeService.svc. Copy and paste the following code. using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.ServiceModel; using System.ServiceModel.Activation; namespace Demo { [ServiceContract(Namespace = "")] [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] public class EmployeeService { [OperationContract] public Employee GetEmployeeById(int employeeId) { Employee employee = new Employee(); string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetEmployeeById", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameter = new SqlParameter(); parameter.ParameterName = "@Id"; parameter.Value = employeeId; cmd.Parameters.Add(parameter); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { employee.ID = Convert.ToInt32(rdr["Id"]); employee.Name = rdr["Name"].ToString(); employee.Gender = rdr["Gender"].ToString(); employee.Salary = Convert.ToInt32(rdr["Salary"]); } } return employee; } } }