filmov
tv
Handling json arrays returned from asp net web services with jquery
Показать описание
Link for all dot net and sql server video tutorial playlists
Link for slides, code samples and text version of the video
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.
When we click Get All Employees button, we want to retrieve all the Employees from the database table and display on the page using jQuery.
This is continuation to Part 62, please watch Part 62 before proceeding.
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Script.Serialization;
using System.Web.Script.Services;
using System.Web.Services;
namespace Demo
{
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
[System.Web.Script.Services.ScriptService]
public class EmployeeService : System.Web.Services.WebService
{
[WebMethod]
public void GetAllEmployees()
{
List<Employee> listEmployees = new List<Employee>();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("Select * from tblEmployee", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Employee employee = new Employee();
employee.ID = Convert.ToInt32(rdr["Id"]);
employee.Name = rdr["Name"].ToString();
employee.Gender = rdr["Gender"].ToString();
employee.Salary = Convert.ToInt32(rdr["Salary"]);
listEmployees.Add(employee);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(listEmployees));
}
}
}
Replace < with LESSTHAN symbol and > with GREATERTHAN symbol
<html>
<head>
<script type="text/javascript">
$(document).ready(function () {
$('#btnGetAllEmployees').click(function () {
$.ajax({
dataType: "json",
method: 'post',
success: function (data) {
var employeeTable = $('#tblEmployee tbody');
$(data).each(function (index, emp) {
+ emp.Name + '</td><td>' + emp.Gender
+ '</td><td>' + emp.Salary + '</td></tr>');
});
},
error: function (err) {
alert(err);
}
});
});
});
</script>
</head>
<body style="font-family:Arial">
<input type="button" id="btnGetAllEmployees" value="Get All Employees" />
<br /><br />
<table id="tblEmployee" border="1" style="border-collapse:collapse">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Gender</th>
<th>Salary</th>
</tr>
</thead>
<tbody></tbody>
</table>
</body>
</html>
Link for slides, code samples and text version of the video
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.
When we click Get All Employees button, we want to retrieve all the Employees from the database table and display on the page using jQuery.
This is continuation to Part 62, please watch Part 62 before proceeding.
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Script.Serialization;
using System.Web.Script.Services;
using System.Web.Services;
namespace Demo
{
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
[System.Web.Script.Services.ScriptService]
public class EmployeeService : System.Web.Services.WebService
{
[WebMethod]
public void GetAllEmployees()
{
List<Employee> listEmployees = new List<Employee>();
string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("Select * from tblEmployee", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Employee employee = new Employee();
employee.ID = Convert.ToInt32(rdr["Id"]);
employee.Name = rdr["Name"].ToString();
employee.Gender = rdr["Gender"].ToString();
employee.Salary = Convert.ToInt32(rdr["Salary"]);
listEmployees.Add(employee);
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(listEmployees));
}
}
}
Replace < with LESSTHAN symbol and > with GREATERTHAN symbol
<html>
<head>
<script type="text/javascript">
$(document).ready(function () {
$('#btnGetAllEmployees').click(function () {
$.ajax({
dataType: "json",
method: 'post',
success: function (data) {
var employeeTable = $('#tblEmployee tbody');
$(data).each(function (index, emp) {
+ emp.Name + '</td><td>' + emp.Gender
+ '</td><td>' + emp.Salary + '</td></tr>');
});
},
error: function (err) {
alert(err);
}
});
});
});
</script>
</head>
<body style="font-family:Arial">
<input type="button" id="btnGetAllEmployees" value="Get All Employees" />
<br /><br />
<table id="tblEmployee" border="1" style="border-collapse:collapse">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Gender</th>
<th>Salary</th>
</tr>
</thead>
<tbody></tbody>
</table>
</body>
</html>
0:11:00
Handling json arrays returned from asp net web services with jquery
0:17:00
Introduction to Parse JSON in Power Apps | ParseJSON Arrays as Table; Return Array from flow
0:01:58
How to Return Specific Properties from JSON Arrays in RediSearch
0:01:18
How to Return JSON Arrays from Oracle ORDS Output Without Escaping
0:06:57
Handling json data returned from asp net web services
0:16:22
Automate Power Automate Cloud Flows: Mastering JSON Arrays & Email Lists Tutorial
0:12:00
Learn JSON in 10 Minutes
0:01:40
Array : Postgres - return row data as JSON array or arrays
8:07:45
Python course tutorials session 519
0:00:17
API Integration Testing - Empty JSON Arrays
0:01:45
Understanding Swift HttpSession for Decoding JSON Arrays
0:02:34
Efficiently Group by and Convert JSON Arrays in JavaScript
0:09:11
Generating Multi-Object JSON Arrays in SQL Server
0:03:41
Processing JSON Properties: Handling Objects and Arrays in C#
0:01:43
How to Properly Parse JSON Arrays with Aeson in Haskell: A Guide to Key and List Values
0:00:43
JavaScript - How To Remove Multiple Items From An Array?
0:00:18
JavaScript tips | How to compare arrays #shorts
0:00:37
JAVASCRIPT OBJECTS_ Function Inside An Object Called Method #shorts #javascript
0:02:11
Unlocking the Power of RedisJSON: Storing and Querying JSON Arrays with Node.js
0:00:10
JavaScript - How Object.keys Really Works
0:00:15
How to return json object using Json query in SQL #learnsql #codewithnd #shortfeed #trending
0:00:20
Remove null, undefined and empty elements from an array in #javascript
0:02:16
Solving the NG0900 Error: How to Extract Arrays from a JSON API Response in Angular
0:09:22
Power Automate – Extracting Values from JSON Array
Комментарии