Handling json arrays returned from asp.net web services with jquery

Step 1 : Copy and paste the following code in EmployeeService.asmx.cs 

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
{
    [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 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));
        }
    }
}

Step 2 : Copy and paste the following HTML and jQuery code in HtmlPage1.html

<html>
<head>
    <script src="jquery-1.11.2.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('#btnGetAllEmployees').click(function () {
                $.ajax({
                    url: 'EmployeeService.asmx/GetAllEmployees',
                    dataType: "json",
                    method: 'post',
                    success: function (data) {
                        var employeeTable = $('#tblEmployee tbody');
                        employeeTable.empty();

                        $(data).each(function (index, emp) {
                            employeeTable.append('<tr><td>' + emp.ID + '</td><td>'
                                + 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>

Comments

Post a Comment

Popular posts from this blog

jQuery dynamic menu from database in asp.net

Step 1 : Create SQL Server table and insert menu data  Create table tblMenu (     Id int primary key identity,     MenuText nvarchar(30),     ParentId int foreign key references tblMenu(Id),     Active bit ) Go Insert into tblMenu values('USA', NULL, 1) Insert into tblMenu values('India', NULL, 1) Insert into tblMenu values('UK', NULL, 1) Insert into tblMenu values('Australia', NULL, 1) Insert into tblMenu values('Virginia', 1, 1) Insert into tblMenu values('Maryland', 1, 1) Insert into tblMenu values('AP', 2, 1) Insert into tblMenu values('MP', 2, 1) Insert into tblMenu...
Read more

Drag and Drop multiple File upload using jQuery AJAX in ASP.Net using C# and VB.Net

Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using jQuery and AJAX in ASP.Net. This article makes use of the jQuery FileDrop plugin which makes use of Generic HTTP Handlers for uploading files with Drag and Drop using jQuery and AJAX in ASP.Net. In this article I will explain with an example, how to upload multiple files with Drag and Drop in HTML5 supported browsers using jQuery and AJAX in ASP.Net using C# and VB.Net. Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using jQuery and AJAX in ASP.Net. This article makes use of the  jQuery FileDrop  plugin which makes use of Generic HTTP Handlers for uploading files with Drag and Drop using jQuery and AJAX in ASP.Net.  ...
Read more

Automatically send Birthday email using C#.Net

In order to automatically send Birthday email daily at particular time, a Windows Service will be created which will run daily at the particular time and will automatically send Birthday emails using C#.Net. In this article the Windows Service will execute a Task daily at a specific time. The Task is to fetch all records of Students who have a Birthday today. Such students will receive an email containing Birthday wishes automatically by the Windows Service. Config:- < appSettings >     < add  key  = " Mode "  value  = " Daily "  />     < add  key  = " IntervalMinutes "  value  = " 1 "  />     < add  key  = " ScheduledTime "  value  = " 17:43 "  /> </ appSettings > < connectionStrings >     < add  name = " constr "  connectionString = " Data Source=.\SQL2008R2;Initial Catalog=S...
Read more