jQuery tutorial for beginners - Calling asp net web services using jquery ajax

5.0 (2)

25 learners

What you'll learn

This course includes

22.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

jquery ajax tutorial jquery ajax tutorial for beginners jquery ajax call asp.net web service how to call asmx webservice from jquery jquery ajax call asp.net webmethod jquery ajax call asmx web service using jquery ajax to call asmx web service methods jquery tutorial jquery tutorial for beginners

Full Transcript

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/calling-aspnet-web-services-using.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 asp.net webservice using jQuery AJAX. We want to retrieve data from the following database table tblEmployee using asp.net web service and jQuery AJAX Step 1 : Create SQL Server table and insert employee data Step 2 : Create a stored procedure to retrieve employee data by ID 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. 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 WebService (ASMX). Name it EmployeeService.asmx. Copy and paste the following code. using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Web.Services; namespace Demo { [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] [System.Web.Script.Services.ScriptService] public class EmployeeService : System.Web.Services.WebService { [WebMethod] 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; } } } Step 6 : Add an HTML page to the ASP.NET project. Copy and paste the following HTML and jQuery code <html> <head> <script src="jquery-1.11.2.js"></script> <script type="text/javascript"> $(document).ready(function () { $('#btnGetEmployee').click(function () { var empId = $('#txtId').val(); $.ajax({ url: 'EmployeeService.asmx/GetEmployeeById', data: { employeeId: empId }, method: 'post', dataType: 'xml', success: function (data) { var jQueryXml = $(data); $('#txtName').val(jQueryXml.find('Name').text()); $('#txtGender').val(jQueryXml.find('Gender').text()); $('#txtSalary').val(jQueryXml.find('Salary').text()); }, error: function (err) { alert(err); } }); }); }); </script> </head> <body style="font-family:Arial"> ID : <input id="txtId" type="text" style="width:100px" /> <input type="button" id="btnGetEmployee" value="Get Employee" /> <br /><br /> <table border="1" style="border-collapse:collapse"> <tr> <td>Name</td> <td><input id="txtName" type="text" /></td> </tr> <tr> <td>Gender</td> <td><input id="txtGender" type="text" /></td> </tr> <tr> <td>Salary</td> <td><input id="txtSalary" type="text" /></td> </tr> </table> </body> </html> In our next video we will discuss how to call an asp.net web service that returns JSON data using jQuery AJAX.