Link for all dot net and sql server video tutorial playlists
https://www.youtube.com/user/kudvenka...
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspo...
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.
asp.net core docker Calling asp net web services using jquery ajax | |
| 290 Likes | 290 Dislikes |
| 69,760 views views | 524K followers |
| Education | Upload TimePublished on 6 Jun 2015 |
Related keywords
wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,wcf one piece,asp.net core 3,ajax players,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,services angular,ajax ontario,asp.net mvc tutorial,asp.net cos'è,csharp assembly,tutorialspoint python,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,jquery ajax example stackoverflow,craigslist ny,asp.net zero,csharp foreach,jquery ajax tutorial with jsp,server memes,sql date format,services online,chase,serverless architecture,server resume,wcf c#,server books,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,jquery ajax tutorial w3schools,ajax deadpool,jquery ajax tutorial mvc,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,tutorialspoint spring,serverless,wcf soap,jquery json tutorial for beginners,wcf cat,cool math games,wcf test client,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,mvconnect,cunyfirst,asp.net guida,wcf nba,csharp download,wcfi foundation,jquery tutorial for beginners youtube,csharp online,wcf authentication,tutorials near me,http://asp.net,server 2019,jquery ajax example,chernobyl,ado.net descargar,web of dreams,jquery ajax example json,serverminer,ajax cleaner,ado.net visual studio 2019,webassign,ado.net vs entity framework,jquery tutorial for beginners in tamil,ado.net visual studio 2017,csharp list,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,jquery slider tutorial for beginners,ajax roster,jquery ajax example get,jquery tutorial for beginners with examples step by step,mvc architecture,http://ado.net,asp.net core mvc,ajax soccer,server hosting,wcfi,jquery tutorial for beginners with examples pdf,jquery tutorial for beginners with examples step by step pdf,ajax dish soap,capital one,server rack,tutorialspoint html,jquery ajax tutorials,csharp interface,craigslist,jquery ajax tutorial point,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,jquery ajax tutorials point,tutorialspoint python 3,sql developer,webster,services transmission company sas,sql group by,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,tutorialspoint spring boot,mvc map,csharp online compiler,asp.net download,jquery ajax tutorial in asp.net,sql between,ado.net c# pdf,services tag dell,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,csharpstar,wcf tutorial,ajax jquery tutorial for beginners pdf,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,ado.net c#,asp.net core github,jquery tutorial for beginners kudvenkat,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,jquery tutorial for beginners full,server error in '/' application,services windows,asp.net core 3.0,sql injection,jquery tutorial for beginners – learn jquery,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,services google play apk,sqlyog,asp.net core 3 release date,sql server,server job description,tutorials by a,jquery ajax tutorial post,servicenow,webcam,mvc hours,webmd symptom,jquery ajax tutorial for beginners,csharp array,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,jquery ajax example php,asp.net core,server pro,server status ffxiv,cheap flights,webcrims,asp.net core hosting,services sas,jquery tutorial for beginners with examples free download,tutorialspoint java,tutorialspoint java compiler,webmd,csharp to json,college football,ado.net dataset,csharp dictionary,cnn,website builder,tutorialspoint sql,asp.net web api,jquery ajax tutorial pdf,server side rendering,weber grills,sql server 2017,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,jquery best tutorial for beginners,webster bank,webstaurant,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,ajax jersey,csharp operator,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,jquery tutorial for beginners step by step,century 21,services consultores,services consulting,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,jquery datatable tutorial for beginners,sql update,asp.net tutorial,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,chase online,wcf api,jquery ajax sample,costco,server jobs near me,webex,sql meaning,sql tutorial,sql commands,jquery validation tutorial for beginners with examples,jquery online tutorial for beginners,ado.net entity framework,ajax tavern,tutorialsteacher,ajax javascript,jquery tutorial for beginners pdf,jquery ajax tutorial for beginners with examples,services desk,jquery ajax tutorial asp.net mvc,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,asp.net core middleware,jquery tutorial for beginners in hindi,wcf web service,jquery tutorial ajax json,mvc webadvisor,web store,mvcc,webmail,mvci,jquery ajax tutorial php,mvctc,
Không có nhận xét nào:
Đăng nhận xét