<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="project121._Default" %> <asp:Content runat="server" ID="FeaturedContent" ContentPlaceHolderID="FeaturedContent"> </asp:Content> <asp:Content runat="server" ID="BodyContent" ContentPlaceHolderID="MainContent"> <script src="Scripts/jquery-1.7.1.js"></script> <script type="text/javascript"> function GetStudents() { $("#studentPanel").html("<div style='text-align:center;background-color:yellow;border:1px solid red;'>Please Wait...... Fetching Data</div>") $.ajax({ type: "POST", url: "Default.aspx", data: "{RollNo"+data.d.SName+"'}", dataType: "json", contentType: "application/json; charset=utf-8", success: onSuccess, error: onError }); } function onSuccess(data) { var tableContent = "<table border='0'>" + "<tr>" + "<td>RollNo</td>" + "<td>SName</td>" + "<td>Fname</td>" + "<td>Class</td>" + "<td>Address</td>" + "</tr>"; for (var i = 0; i < data.d.lenght;i++){ tableContent += "<tr>" + "<td>" + data.d[i].RollNo + "</td>" + "<td>" + data.d[i].SName + "</td>" + "<td>" + data.d[i].Fname + "</td>" + "<td>" + date.d[i].Class + "</td>" + "<td>" + date.d[i].Address + "</td>" + "</tr>"; } tableContent+="</table>"; $("#studentPanel").html(tableContent); } function onError(data) { } </script> <h3> This is database Fetching through JSON</h3> <input id="btn" type="button" value="load database" onclick="GetStudents()" /> <div id="studentPanel"> </div> </asp:Content>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Script.Services; using System.Web.Services; using System.Web.UI; using System.Web.UI.WebControls; namespace project121 { public partial class _Default : Page { protected void Page_Load(object sender, EventArgs e) { } [WebMethod] [ScriptMethod(ResponseFormat=ResponseFormat.Json)] private static List<student> GetStudents() { List<student> allStudents = new List<student>(); using (dbEntitiy dc = new dbEntitiy()) { allStudents = dc.students.ToList(); } return allStudents; } } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)