🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 160 (from laksa118)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa160.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://www.dotnettutorial.co.in/2022/05/using-database-bind-json-data-to-html-table-in-mvc.html\')), getAhrefsUnparsedNoserviceFromURL(\'https://www.dotnettutorial.co.in/2022/05/using-database-bind-json-data-to-html-table-in-mvc.html\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/www.dotnettutorial.co.in\/2022\/05\/using-database-bind-json-data-to-html-table-in-mvc.html","crawl_time":1775517929,"first_indexed_time":1654130448,"http_code":200,"src_unparsed":"in,co,dotnettutorial!www,\/2022\/05\/using-database-bind-json-data-to-html-table-in-mvc.html s443","src_root_hash":"13553251105045825560","history_drop_reason":null,"meta_title":"[Using DataTable] Bind Json Data To Html Table Using Jquery In Mvc","meta_descriptions":["In this tutorial, we will see how we can Bind JSON Data To Html Table Using Jquery In MVC. In this process"],"attrs_boilerpipe_text":"In this tutorial, we will see how we can \nBind JSON Data To Html Table Using JQuery In MVC.\n \n \nIn this process, we will use the Ajax Method to bind the data from the DataTable.\nAdd Controller.\nAdd a action.\nRight Click on Action to add the views.\nAdd Model Student.cs\nCreate JsonResult Function to Call bind the data.\nCall JsonResult from Ajax on Razor View.\nOn HomeController\nusing\nSystem;\nusing\nSystem.Collections.Generic;\nusing\nSystem.Data;\nusing\nSystem.Linq;\nusing\nSystem.Web;\nusing\nSystem.Web.Mvc;\nusing\nAjaxDataTable.Models;\nnamespace\nAjaxDataTable.Controllers\n{\n   \npublic\nclass\nHomeController\n: Controller\n    {\n       \npublic\nActionResult StudentList()\n        {\n            ViewBag.Title =\n\"Home Page\"\n;\n           \nreturn\nView();\n        }\n       \npublic\nJsonResult GetJsonData()\n        {\n            DataTable dt =\nnew\nDataTable();\n            dt.Columns.Add(\n\"ID\"\n,\ntypeof\n(Int32));\n            dt.Columns.Add(\n\"Name\"\n,\ntypeof\n(\nstring\n));\n            dt.Columns.Add(\n\"Phone\"\n,\ntypeof\n(\nstring\n));\n            dt.Columns.Add(\n\"EmailID\"\n,\ntypeof\n(\nstring\n));\n            dt.Columns.Add(\n\"Address\"\n,\ntypeof\n(\nstring\n));\n            dt.Rows.Add(1,\n\"Jhon\"\n,\n\"1234567890\"\n,\n\"\n[email protected]\n\"\n,\n\"UK\"\n);\n            dt.Rows.Add(2,\n\"Liam\"\n,\n\"989898980\"\n,\n\"\n[email protected]\n\"\n,\n\"UK\"\n);\n            dt.Rows.Add(3,\n\"William\"\n,\n\"65656565656\"\n,\n\"\n[email protected]\n\"\n,\n\"UK\"\n);\n            dt.Rows.Add(4,\n\"James\"\n,\n\"9090786745\"\n,\n\"\n[email protected]\n\"\n,\n\"UK\"\n);\n            List<Student> model =\nnew\nList<Student>();\n           \nif\n(dt.Rows.Count > 0)\n            {\n               \nforeach\n(DataRow row\nin\ndt.Rows)\n                {\n                    model.Add(\nnew\nStudent\n                    {\n                        ID =\nConvert.ToInt32(row[\n\"ID\"\n]),\n                        Name =\nConvert.ToString(row[\n\"Name\"\n]),\n                        Phone =\nConvert.ToString(row[\n\"Phone\"\n]),\n                        EmailID = Convert.ToString(row[\n\"EmailID\"\n]),\n                        Address =\nConvert.ToString(row[\n\"Address\"\n])\n                    });\n                }\n            }\n           \nreturn\nJson(model);\n        }\n    }\n}\nOn Student.cs Model\nusing\nSystem;\nusing\nSystem.Collections.Generic;\nusing\nSystem.Linq;\nusing\nSystem.Web;\nnamespace\nAjaxDataTable.Models\n{\n \npublic\nclass\nStudent\n \n{\n      \npublic\nint\nID {\nget\n;\nset\n; }\n       \npublic\nstring\nName {\nget\n;\nset\n; }\n       \npublic\nstring\nPhone {\nget\n;\nset\n; }\n        \npublic\nstring\nEmailID {\nget\n;\nset\n; }\n       \npublic\nstring\nAddress\n{\nget\n;\nset\n; }\n   \n}\n}\nOn StudentList.cshtml\n@{\n    ViewData[\n\"Title\"\n] =\n\"Bind json data to table using jquery in mvc –dotnettutorial.co.in\"\n;\n}\n<\nscript\nsrc\n=\"https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/3.3.1\/jquery.min.js\"><\/\nscript\n>\n<\nscript\n>\n    $(document).ready(\nfunction\n() {\n        $.ajax({\n            type:\n\"POST\"\n,\n            url:\n'\n@\nUrl.Action(\n\"GetJsonData\"\n,\n\"Home\"\n)\n'\n,\n            data:\n\"[]\"\n,\n            contentType:\n\"application\/json; charset=utf-8\"\n,\n            dataType:\n\"json\"\n,\n            success:\nfunction\n(data)\n            {\n             \nvar\noutput = data.map(i =>\n\"<tr><td>\"\n+ i.ID +\n\"<\/td><td>\"\n+ i.Name +\n\"<\/td><td>\"\n+ i.Phone +\n\"<\/td><td>\"\n+ i.EmailID +\n\"<\/td><td>\"\n+ i.Address +\n\"<\/td><\/tr>\"\n);\n               $(\n\"#studentdata\"\n).html(output);\n            }\n        });\n    });\n<\/\nscript\n>\n<\ndiv\nclass\n=\"text-center\">\n   \n<\nh1\n>\nStudent List\n<\/\nh1\n>\n   \n<\ntable\nclass\n=\"table table-bordered\">\n          \n<\ntr\nclass\n=\"table-head\">\n           \n<\nth\nclass\n=\"text-center\">\nID\n<\/\nth\n>\n           \n<\nth\nclass\n=\"text-center\">\nName\n<\/\nth\n>\n           \n<\nth\nclass\n=\"text-center\">\nPhone\n<\/\nth\n>\n           \n<\nth\nclass\n=\"text-center\">\nEmailID\n<\/\nth\n>\n            \n<\nth\nclass\n=\"text-center\">\nAddress\n<\/\nth\n>\n       \n<\/\ntr\n>\n       \n<\ntbody\nid\n=\"studentdata\">\n   \n<\/\ntable\n>\n<\/\ndiv\n>\nIn this tutorial, we have learned how to bind Json Data To Html Table. If you have any doubt, feel free to comment below.","attrs_markdown":"### Facebook SDK\n[![Dot Net Tutorial For Beginner \\| Download Source Code](https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEjJVXzy5yTCRpikxLIPG9irPendrQOyjPzg-wYFpybV2cDFmAwFep1V0cNB4urcbR_iT_Ge2vVZs_QkTkDUkQhPz0qhs_cPNVEvXLO5uhY783Z1WVWXJ7CZWJwf3n-biEvOdlR0wkW25HZv\/s320\/dotnet_logo.png)](https:\/\/www.dotnettutorial.co.in\/)\n\n- [Home](https:\/\/www.dotnettutorial.co.in\/)\n- [C\\#](https:\/\/www.dotnettutorial.co.in\/2022\/05\/{getMega}%20$label={c%20sharp}%20$type={msimple})\n- [OOPS](https:\/\/www.dotnettutorial.co.in\/2022\/05\/{getMega}%20$label={oops}%20$type={msimple})\n- [JQuery](https:\/\/www.dotnettutorial.co.in\/2022\/05\/{getMega}%20$label={JQuery}%20$type={msimple})\n- [SQL](https:\/\/www.dotnettutorial.co.in\/2022\/05\/{getMega}%20$label={SQL}%20$type={msimple})\n- [More](https:\/\/www.dotnettutorial.co.in\/)\n- [\\_Asp.Net](https:\/\/www.dotnettutorial.co.in\/search\/label\/.net)\n- [\\_Registration Form](https:\/\/www.dotnettutorial.co.in\/2019\/03\/registration-form-in-aspnet-with-store-procedure.html)\n- [\\_HTML](https:\/\/www.dotnettutorial.co.in\/search\/label\/Html)\n- [\\_SQL Salary Related Q\/A](https:\/\/www.dotnettutorial.co.in\/search\/label\/Higest%20Salary)\n\n[Home](https:\/\/www.dotnettutorial.co.in\/)[Ajax](https:\/\/www.dotnettutorial.co.in\/search\/label\/Ajax)\n\n# \\[Using DataTable\\] Bind Json Data To Html Table Using Jquery In Mvc\nbySanjay Yadav\n\n\\-\n\n11:22 PM\n\n0\n\nIn this tutorial, we will see how we can ***Bind JSON Data To Html Table Using JQuery In MVC.*** In this process, we will use the Ajax Method to bind the data from the DataTable.\n\n[![How to bind JSON data to table using Jquery in MVC](https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw\/w400-h261-rw\/ajax_data_bind.PNG)](https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw\/s466\/ajax_data_bind.PNG)\n\n## **Steps to Bind Json Data To Html Table Using Jquery In Mvc**\n1. Add Controller.\n2. Add a action.\n3. Right Click on Action to add the views.\n4. Add Model Student.cs\n5. Create JsonResult Function to Call bind the data.\n6. Call JsonResult from Ajax on Razor View.\n## **On HomeController**\n```\n\n```\n```\nusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Mvc;usingAjaxDataTable.Models;namespaceAjaxDataTable.Controllers{public class HomeController: Controller{publicActionResult StudentList(){ViewBag.Title = \"Home Page\";returnView();}publicJsonResult GetJsonData(){DataTable dt = newDataTable();dt.Columns.Add(\"ID\", typeof(Int32));dt.Columns.Add(\"Name\", typeof(string));dt.Columns.Add(\"Phone\", typeof(string));dt.Columns.Add(\"EmailID\", typeof(string));dt.Columns.Add(\"Address\", typeof(string));dt.Rows.Add(1, \"Jhon\", \"1234567890\", \"[email protected]\", \"UK\");dt.Rows.Add(2, \"Liam\", \"989898980\", \"[email protected]\", \"UK\");dt.Rows.Add(3, \"William\", \"65656565656\", \"[email protected]\", \"UK\");dt.Rows.Add(4, \"James\", \"9090786745\", \"[email protected]\", \"UK\");List<Student> model = newList<Student>();if(dt.Rows.Count > 0){foreach (DataRow row indt.Rows){model.Add(newStudent{ID = Convert.ToInt32(row[\"ID\"]),Name = Convert.ToString(row[\"Name\"]),Phone = Convert.ToString(row[\"Phone\"]),EmailID = Convert.ToString(row[\"EmailID\"]),Address = Convert.ToString(row[\"Address\"])});}}returnJson(model);}}}\n```\n\n##\n## **On Student.cs Model**\n```\nusing System;using System.Collections.Generic;using System.Linq;using System.Web;namespace AjaxDataTable.Models{public class Student{public int ID { get; set; }public string Name { get; set; }public string Phone { get; set; }public string EmailID { get; set; }public string Address { get; set; }}}\n```\n##\n## **On StudentList.cshtml**\n```\n@{ViewData[\"Title\"] = \"Bind json data to table using jquery in mvc –dotnettutorial.co.in\";}<script src=\"https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/3.3.1\/jquery.min.js\"><\/script><script>$(document).ready(function() {$.ajax({type: \"POST\",url: '@Url.Action(\"GetJsonData\", \"Home\")',data: \"[]\",contentType: \"application\/json; charset=utf-8\",dataType: \"json\",success: function(data){var output = data.map(i => \"<tr><td>\" + i.ID + \"<\/td><td>\" + i.Name + \"<\/td><td>\" + i.Phone + \"<\/td><td>\" + i.EmailID + \"<\/td><td>\" + i.Address + \"<\/td><\/tr>\");$(\"#studentdata\").html(output);}});});<\/script>\n\n<div class=\"text-center\"><h1>Student List<\/h1><table class=\"table table-bordered\"><tr class=\"table-head\"><th class=\"text-center\">ID<\/th><th class=\"text-center\">Name<\/th><th class=\"text-center\">Phone<\/th><th class=\"text-center\">EmailID<\/th><th class=\"text-center\">Address<\/th><\/tr><tbody id=\"studentdata\"><\/table><\/div>\n```\nIn this tutorial, we have learned how to bind Json Data To Html Table. If you have any doubt, feel free to comment below.\n\nTags: [Ajax](https:\/\/www.dotnettutorial.co.in\/search\/label\/Ajax) [mvc](https:\/\/www.dotnettutorial.co.in\/search\/label\/mvc)\n\n- [Share on Facebook](\"Facebook\")\n- [Share on Twitter](\"Twitter\")\n### You might like\n\n#### Post a Comment\n[Post a Comment (0)]()\n\n[Previous Post](https:\/\/www.dotnettutorial.co.in\/2018\/07\/stored-procedure-to-insert-data-into-multiple-tables-in-sql-server.html)   [Next Post](https:\/\/www.dotnettutorial.co.in\/2018\/04\/what-is-the-use-of-static-class-in-c-dot-net-with-example.html)\n\n### Follow Us\n### Popular Posts\nmvc\n\n\\-\n\n10:33 PM\n## [Authentication in ASP.NET MVC With Example](https:\/\/www.dotnettutorial.co.in\/2025\/07\/authentication-in-aspnet-mvc-with-example.html)\n## [Registration form in asp.net C\\# with validation using SQL Server](https:\/\/www.dotnettutorial.co.in\/2019\/03\/registration-form-in-aspnet-with-store-procedure.html)\n## [Generate random password in asp.net using c\\# and save in database](https:\/\/www.dotnettutorial.co.in\/2018\/07\/how-to-generate-random-password-in-asp-net-and-save-in-databse.html)\n### Search This Blog\n### CATEGORIES\n- [asp dot net](https:\/\/www.dotnettutorial.co.in\/search\/label\/asp%20dot%20net)\n- [SQL](https:\/\/www.dotnettutorial.co.in\/search\/label\/SQL)\n- [javascript](https:\/\/www.dotnettutorial.co.in\/search\/label\/javascript)\n- [JQuery](https:\/\/www.dotnettutorial.co.in\/search\/label\/JQuery)\n- [c sharp](https:\/\/www.dotnettutorial.co.in\/search\/label\/c%20sharp)\n- [.net](https:\/\/www.dotnettutorial.co.in\/search\/label\/.net)\n- [oops](https:\/\/www.dotnettutorial.co.in\/search\/label\/oops)\n- [mvc](https:\/\/www.dotnettutorial.co.in\/search\/label\/mvc)\n- [Ajax](https:\/\/www.dotnettutorial.co.in\/search\/label\/Ajax)\n- [Sql Keys](https:\/\/www.dotnettutorial.co.in\/search\/label\/Sql%20Keys)\n- [Higest Salary](https:\/\/www.dotnettutorial.co.in\/search\/label\/Higest%20Salary)\n- [ado dot net](https:\/\/www.dotnettutorial.co.in\/search\/label\/ado%20dot%20net)\n- [AngularJS](https:\/\/www.dotnettutorial.co.in\/search\/label\/AngularJS)\n- [Typescript](https:\/\/www.dotnettutorial.co.in\/search\/label\/Typescript)\n- [Diffrence b\/w](https:\/\/www.dotnettutorial.co.in\/search\/label\/Diffrence%20b%2Fw)\n- [Html](https:\/\/www.dotnettutorial.co.in\/search\/label\/Html)\n- [Faq](https:\/\/www.dotnettutorial.co.in\/search\/label\/Faq)\n- [WildCard](https:\/\/www.dotnettutorial.co.in\/search\/label\/WildCard)\n- [general](https:\/\/www.dotnettutorial.co.in\/search\/label\/general)\n- [syntex](https:\/\/www.dotnettutorial.co.in\/search\/label\/syntex)\n\n### About Us\nFind the Daily uses source code for .Net, Jquery, Javascript and SQL Server..\n### Follow Us\n\n### Popular Posts\n## [Authentication in ASP.NET MVC With Example](https:\/\/www.dotnettutorial.co.in\/2025\/07\/authentication-in-aspnet-mvc-with-example.html)\n## [Registration form in asp.net C\\# with validation using SQL Server](https:\/\/www.dotnettutorial.co.in\/2019\/03\/registration-form-in-aspnet-with-store-procedure.html)\n## [Generate random password in asp.net using c\\# and save in database](https:\/\/www.dotnettutorial.co.in\/2018\/07\/how-to-generate-random-password-in-asp-net-and-save-in-databse.html)\n\nDesign by - [Dotnettutorials](https:\/\/www.dotnettutorial.co.in\/)\n\n- [Home](https:\/\/www.dotnettutorial.co.in\/)\n- [Contact Us](https:\/\/www.dotnettutorial.co.in\/p\/contact-us.html)\n- [Privacy Policy](https:\/\/www.dotnettutorial.co.in\/p\/privacy-policy.html)\n- [SQL Course](https:\/\/www.dotnettutorial.co.in\/p\/microsoft-ql-free-course-online.html)\n### Contact Form","attrs_readable_markdown":"In this tutorial, we will see how we can ***Bind JSON Data To Html Table Using JQuery In MVC.*** In this process, we will use the Ajax Method to bind the data from the DataTable.\n\n[![How to bind JSON data to table using Jquery in MVC](https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw\/w400-h261-rw\/ajax_data_bind.PNG)](https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw\/s466\/ajax_data_bind.PNG)\n\n1. Add Controller.\n2. Add a action.\n3. Right Click on Action to add the views.\n4. Add Model Student.cs\n5. Create JsonResult Function to Call bind the data.\n6. Call JsonResult from Ajax on Razor View.\n## **On HomeController**\n```\n\n```\n```\nusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Mvc;usingAjaxDataTable.Models;namespaceAjaxDataTable.Controllers{public class HomeController: Controller{publicActionResult StudentList(){ViewBag.Title = \"Home Page\";returnView();}publicJsonResult GetJsonData(){DataTable dt = newDataTable();dt.Columns.Add(\"ID\", typeof(Int32));dt.Columns.Add(\"Name\", typeof(string));dt.Columns.Add(\"Phone\", typeof(string));dt.Columns.Add(\"EmailID\", typeof(string));dt.Columns.Add(\"Address\", typeof(string));dt.Rows.Add(1, \"Jhon\", \"1234567890\", \"[email protected]\", \"UK\");dt.Rows.Add(2, \"Liam\", \"989898980\", \"[email protected]\", \"UK\");dt.Rows.Add(3, \"William\", \"65656565656\", \"[email protected]\", \"UK\");dt.Rows.Add(4, \"James\", \"9090786745\", \"[email protected]\", \"UK\");List<Student> model = newList<Student>();if(dt.Rows.Count > 0){foreach (DataRow row indt.Rows){model.Add(newStudent{ID = Convert.ToInt32(row[\"ID\"]),Name = Convert.ToString(row[\"Name\"]),Phone = Convert.ToString(row[\"Phone\"]),EmailID = Convert.ToString(row[\"EmailID\"]),Address = Convert.ToString(row[\"Address\"])});}}returnJson(model);}}}\n```\n\n## **On Student.cs Model**\n```\nusing System;using System.Collections.Generic;using System.Linq;using System.Web;namespace AjaxDataTable.Models{public class Student{public int ID { get; set; }public string Name { get; set; }public string Phone { get; set; }public string EmailID { get; set; }public string Address { get; set; }}}\n```\n## **On StudentList.cshtml**\n```\n@{ViewData[\"Title\"] = \"Bind json data to table using jquery in mvc –dotnettutorial.co.in\";}<script src=\"https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/3.3.1\/jquery.min.js\"><\/script><script>$(document).ready(function() {$.ajax({type: \"POST\",url: '@Url.Action(\"GetJsonData\", \"Home\")',data: \"[]\",contentType: \"application\/json; charset=utf-8\",dataType: \"json\",success: function(data){var output = data.map(i => \"<tr><td>\" + i.ID + \"<\/td><td>\" + i.Name + \"<\/td><td>\" + i.Phone + \"<\/td><td>\" + i.EmailID + \"<\/td><td>\" + i.Address + \"<\/td><\/tr>\");$(\"#studentdata\").html(output);}});});<\/script>\n\n<div class=\"text-center\"><h1>Student List<\/h1><table class=\"table table-bordered\"><tr class=\"table-head\"><th class=\"text-center\">ID<\/th><th class=\"text-center\">Name<\/th><th class=\"text-center\">Phone<\/th><th class=\"text-center\">EmailID<\/th><th class=\"text-center\">Address<\/th><\/tr><tbody id=\"studentdata\"><\/table><\/div>\n```\nIn this tutorial, we have learned how to bind Json Data To Html Table. If you have any doubt, feel free to comment below.","meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

11 hours ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://www.dotnettutorial.co.in/2022/05/using-database-bind-json-data-to-html-table-in-mvc.html
Last Crawled	2026-04-06 23:25:29 (11 hours ago)
First Indexed	2022-06-02 00:40:48 (3 years ago)
HTTP Status Code	200
Meta Title	[Using DataTable] Bind Json Data To Html Table Using Jquery In Mvc
Meta Description	In this tutorial, we will see how we can Bind JSON Data To Html Table Using Jquery In MVC. In this process
Meta Canonical	null
Boilerpipe Text	In this tutorial, we will see how we can Bind JSON Data To Html Table Using JQuery In MVC. In this process, we will use the Ajax Method to bind the data from the DataTable. Add Controller. Add a action. Right Click on Action to add the views. Add Model Student.cs Create JsonResult Function to Call bind the data. Call JsonResult from Ajax on Razor View. On HomeController using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Mvc; using AjaxDataTable.Models; namespace AjaxDataTable.Controllers { public class HomeController : Controller { public ActionResult StudentList() { ViewBag.Title = "Home Page" ; return View(); } public JsonResult GetJsonData() { DataTable dt = new DataTable(); dt.Columns.Add( "ID" , typeof (Int32)); dt.Columns.Add( "Name" , typeof ( string )); dt.Columns.Add( "Phone" , typeof ( string )); dt.Columns.Add( "EmailID" , typeof ( string )); dt.Columns.Add( "Address" , typeof ( string )); dt.Rows.Add(1, "Jhon" , "1234567890" , " [email protected] " , "UK" ); dt.Rows.Add(2, "Liam" , "989898980" , " [email protected] " , "UK" ); dt.Rows.Add(3, "William" , "65656565656" , " [email protected] " , "UK" ); dt.Rows.Add(4, "James" , "9090786745" , " [email protected] " , "UK" ); List<Student> model = new List<Student>(); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { model.Add( new Student { ID = Convert.ToInt32(row[ "ID" ]), Name = Convert.ToString(row[ "Name" ]), Phone = Convert.ToString(row[ "Phone" ]), EmailID = Convert.ToString(row[ "EmailID" ]), Address = Convert.ToString(row[ "Address" ]) }); } } return Json(model); } } } On Student.cs Model using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace AjaxDataTable.Models { public class Student { public int ID { get ; set ; } public string Name { get ; set ; } public string Phone { get ; set ; } public string EmailID { get ; set ; } public string Address { get ; set ; } } } On StudentList.cshtml @{ ViewData[ "Title" ] = "Bind json data to table using jquery in mvc –dotnettutorial.co.in" ; } < script src ="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></ script > < script > $(document).ready( function () { $.ajax({ type: "POST" , url: ' @ Url.Action( "GetJsonData" , "Home" ) ' , data: "[]" , contentType: "application/json; charset=utf-8" , dataType: "json" , success: function (data) { var output = data.map(i => "<tr><td>" + i.ID + "</td><td>" + i.Name + "</td><td>" + i.Phone + "</td><td>" + i.EmailID + "</td><td>" + i.Address + "</td></tr>" ); $( "#studentdata" ).html(output); } }); }); </ script > < div class ="text-center"> < h1 > Student List </ h1 > < table class ="table table-bordered"> < tr class ="table-head"> < th class ="text-center"> ID </ th > < th class ="text-center"> Name </ th > < th class ="text-center"> Phone </ th > < th class ="text-center"> EmailID </ th > < th class ="text-center"> Address </ th > </ tr > < tbody id ="studentdata"> </ table > </ div > In this tutorial, we have learned how to bind Json Data To Html Table. If you have any doubt, feel free to comment below.
Markdown	### Facebook SDK [![Dot Net Tutorial For Beginner \\| Download Source Code](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJVXzy5yTCRpikxLIPG9irPendrQOyjPzg-wYFpybV2cDFmAwFep1V0cNB4urcbR_iT_Ge2vVZs_QkTkDUkQhPz0qhs_cPNVEvXLO5uhY783Z1WVWXJ7CZWJwf3n-biEvOdlR0wkW25HZv/s320/dotnet_logo.png)](https://www.dotnettutorial.co.in/) - [Home](https://www.dotnettutorial.co.in/) - [C\#](https://www.dotnettutorial.co.in/2022/05/{getMega}%20$label={c%20sharp}%20$type={msimple}) - [OOPS](https://www.dotnettutorial.co.in/2022/05/{getMega}%20$label={oops}%20$type={msimple}) - [JQuery](https://www.dotnettutorial.co.in/2022/05/{getMega}%20$label={JQuery}%20$type={msimple}) - [SQL](https://www.dotnettutorial.co.in/2022/05/{getMega}%20$label={SQL}%20$type={msimple}) - [More](https://www.dotnettutorial.co.in/) - [\_Asp.Net](https://www.dotnettutorial.co.in/search/label/.net) - [\_Registration Form](https://www.dotnettutorial.co.in/2019/03/registration-form-in-aspnet-with-store-procedure.html) - [\_HTML](https://www.dotnettutorial.co.in/search/label/Html) - [\_SQL Salary Related Q/A](https://www.dotnettutorial.co.in/search/label/Higest%20Salary) [Home](https://www.dotnettutorial.co.in/)[Ajax](https://www.dotnettutorial.co.in/search/label/Ajax) # \[Using DataTable\] Bind Json Data To Html Table Using Jquery In Mvc bySanjay Yadav \- 11:22 PM 0 In this tutorial, we will see how we can *Bind JSON Data To Html Table Using JQuery In MVC.* In this process, we will use the Ajax Method to bind the data from the DataTable. [![How to bind JSON data to table using Jquery in MVC](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw/w400-h261-rw/ajax_data_bind.PNG)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw/s466/ajax_data_bind.PNG) ## Steps to Bind Json Data To Html Table Using Jquery In Mvc 1. Add Controller. 2. Add a action. 3. Right Click on Action to add the views. 4. Add Model Student.cs 5. Create JsonResult Function to Call bind the data. 6. Call JsonResult from Ajax on Razor View. ## On HomeController ``` ``` ``` usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Mvc;usingAjaxDataTable.Models;namespaceAjaxDataTable.Controllers{public class HomeController: Controller{publicActionResult StudentList(){ViewBag.Title = "Home Page";returnView();}publicJsonResult GetJsonData(){DataTable dt = newDataTable();dt.Columns.Add("ID", typeof(Int32));dt.Columns.Add("Name", typeof(string));dt.Columns.Add("Phone", typeof(string));dt.Columns.Add("EmailID", typeof(string));dt.Columns.Add("Address", typeof(string));dt.Rows.Add(1, "Jhon", "1234567890", "[email protected]", "UK");dt.Rows.Add(2, "Liam", "989898980", "[email protected]", "UK");dt.Rows.Add(3, "William", "65656565656", "[email protected]", "UK");dt.Rows.Add(4, "James", "9090786745", "[email protected]", "UK");List<Student> model = newList<Student>();if(dt.Rows.Count > 0){foreach (DataRow row indt.Rows){model.Add(newStudent{ID = Convert.ToInt32(row["ID"]),Name = Convert.ToString(row["Name"]),Phone = Convert.ToString(row["Phone"]),EmailID = Convert.ToString(row["EmailID"]),Address = Convert.ToString(row["Address"])});}}returnJson(model);}}} ``` ## ## On Student.cs Model ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;namespace AjaxDataTable.Models{public class Student{public int ID { get; set; }public string Name { get; set; }public string Phone { get; set; }public string EmailID { get; set; }public string Address { get; set; }}} ``` ## ## On StudentList.cshtml ``` @{ViewData["Title"] = "Bind json data to table using jquery in mvc –dotnettutorial.co.in";}<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script><script>$(document).ready(function() {$.ajax({type: "POST",url: '@Url.Action("GetJsonData", "Home")',data: "[]",contentType: "application/json; charset=utf-8",dataType: "json",success: function(data){var output = data.map(i => "<tr><td>" + i.ID + "</td><td>" + i.Name + "</td><td>" + i.Phone + "</td><td>" + i.EmailID + "</td><td>" + i.Address + "</td></tr>");$("#studentdata").html(output);}});});</script> <div class="text-center"><h1>Student List</h1><table class="table table-bordered"><tr class="table-head"><th class="text-center">ID</th><th class="text-center">Name</th><th class="text-center">Phone</th><th class="text-center">EmailID</th><th class="text-center">Address</th></tr><tbody id="studentdata"></table></div> ``` In this tutorial, we have learned how to bind Json Data To Html Table. If you have any doubt, feel free to comment below. Tags: [Ajax](https://www.dotnettutorial.co.in/search/label/Ajax) [mvc](https://www.dotnettutorial.co.in/search/label/mvc) - [Share on Facebook]("Facebook") - [Share on Twitter]("Twitter") ### You might like #### Post a Comment [Post a Comment (0)]() [Previous Post](https://www.dotnettutorial.co.in/2018/07/stored-procedure-to-insert-data-into-multiple-tables-in-sql-server.html) [Next Post](https://www.dotnettutorial.co.in/2018/04/what-is-the-use-of-static-class-in-c-dot-net-with-example.html) ### Follow Us ### Popular Posts mvc \- 10:33 PM ## [Authentication in ASP.NET MVC With Example](https://www.dotnettutorial.co.in/2025/07/authentication-in-aspnet-mvc-with-example.html) ## [Registration form in asp.net C\# with validation using SQL Server](https://www.dotnettutorial.co.in/2019/03/registration-form-in-aspnet-with-store-procedure.html) ## [Generate random password in asp.net using c\# and save in database](https://www.dotnettutorial.co.in/2018/07/how-to-generate-random-password-in-asp-net-and-save-in-databse.html) ### Search This Blog ### CATEGORIES - [asp dot net](https://www.dotnettutorial.co.in/search/label/asp%20dot%20net) - [SQL](https://www.dotnettutorial.co.in/search/label/SQL) - [javascript](https://www.dotnettutorial.co.in/search/label/javascript) - [JQuery](https://www.dotnettutorial.co.in/search/label/JQuery) - [c sharp](https://www.dotnettutorial.co.in/search/label/c%20sharp) - [.net](https://www.dotnettutorial.co.in/search/label/.net) - [oops](https://www.dotnettutorial.co.in/search/label/oops) - [mvc](https://www.dotnettutorial.co.in/search/label/mvc) - [Ajax](https://www.dotnettutorial.co.in/search/label/Ajax) - [Sql Keys](https://www.dotnettutorial.co.in/search/label/Sql%20Keys) - [Higest Salary](https://www.dotnettutorial.co.in/search/label/Higest%20Salary) - [ado dot net](https://www.dotnettutorial.co.in/search/label/ado%20dot%20net) - [AngularJS](https://www.dotnettutorial.co.in/search/label/AngularJS) - [Typescript](https://www.dotnettutorial.co.in/search/label/Typescript) - [Diffrence b/w](https://www.dotnettutorial.co.in/search/label/Diffrence%20b%2Fw) - [Html](https://www.dotnettutorial.co.in/search/label/Html) - [Faq](https://www.dotnettutorial.co.in/search/label/Faq) - [WildCard](https://www.dotnettutorial.co.in/search/label/WildCard) - [general](https://www.dotnettutorial.co.in/search/label/general) - [syntex](https://www.dotnettutorial.co.in/search/label/syntex) ### About Us Find the Daily uses source code for .Net, Jquery, Javascript and SQL Server.. ### Follow Us ### Popular Posts ## [Authentication in ASP.NET MVC With Example](https://www.dotnettutorial.co.in/2025/07/authentication-in-aspnet-mvc-with-example.html) ## [Registration form in asp.net C\# with validation using SQL Server](https://www.dotnettutorial.co.in/2019/03/registration-form-in-aspnet-with-store-procedure.html) ## [Generate random password in asp.net using c\# and save in database](https://www.dotnettutorial.co.in/2018/07/how-to-generate-random-password-in-asp-net-and-save-in-databse.html) Design by - [Dotnettutorials](https://www.dotnettutorial.co.in/) - [Home](https://www.dotnettutorial.co.in/) - [Contact Us](https://www.dotnettutorial.co.in/p/contact-us.html) - [Privacy Policy](https://www.dotnettutorial.co.in/p/privacy-policy.html) - [SQL Course](https://www.dotnettutorial.co.in/p/microsoft-ql-free-course-online.html) ### Contact Form
Readable Markdown	In this tutorial, we will see how we can *Bind JSON Data To Html Table Using JQuery In MVC.* In this process, we will use the Ajax Method to bind the data from the DataTable. [![How to bind JSON data to table using Jquery in MVC](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw/w400-h261-rw/ajax_data_bind.PNG)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaw1oBlcAGVHi6K9gjCK_miK3yvghfrfFJdUWbjKTxbZ3qeftZ6XUo0-R7E9RwgRDfixWRFAiis6e1FJ0PrnutZjDxc23hpyhFwA25Hyne8Yps7U8JOkppEirgjLqbSc-D7AVQdFX5FeVO_BUGkXtWnpk_OW1Tld1UF_QIjTQkE8toF8s4u6YaejJOtw/s466/ajax_data_bind.PNG) 1. Add Controller. 2. Add a action. 3. Right Click on Action to add the views. 4. Add Model Student.cs 5. Create JsonResult Function to Call bind the data. 6. Call JsonResult from Ajax on Razor View. ## On HomeController ``` ``` ``` usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Mvc;usingAjaxDataTable.Models;namespaceAjaxDataTable.Controllers{public class HomeController: Controller{publicActionResult StudentList(){ViewBag.Title = "Home Page";returnView();}publicJsonResult GetJsonData(){DataTable dt = newDataTable();dt.Columns.Add("ID", typeof(Int32));dt.Columns.Add("Name", typeof(string));dt.Columns.Add("Phone", typeof(string));dt.Columns.Add("EmailID", typeof(string));dt.Columns.Add("Address", typeof(string));dt.Rows.Add(1, "Jhon", "1234567890", "[email protected]", "UK");dt.Rows.Add(2, "Liam", "989898980", "[email protected]", "UK");dt.Rows.Add(3, "William", "65656565656", "[email protected]", "UK");dt.Rows.Add(4, "James", "9090786745", "[email protected]", "UK");List<Student> model = newList<Student>();if(dt.Rows.Count > 0){foreach (DataRow row indt.Rows){model.Add(newStudent{ID = Convert.ToInt32(row["ID"]),Name = Convert.ToString(row["Name"]),Phone = Convert.ToString(row["Phone"]),EmailID = Convert.ToString(row["EmailID"]),Address = Convert.ToString(row["Address"])});}}returnJson(model);}}} ``` ## On Student.cs Model ``` using System;using System.Collections.Generic;using System.Linq;using System.Web;namespace AjaxDataTable.Models{public class Student{public int ID { get; set; }public string Name { get; set; }public string Phone { get; set; }public string EmailID { get; set; }public string Address { get; set; }}} ``` ## On StudentList.cshtml ``` @{ViewData["Title"] = "Bind json data to table using jquery in mvc –dotnettutorial.co.in";}<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script><script>$(document).ready(function() {$.ajax({type: "POST",url: '@Url.Action("GetJsonData", "Home")',data: "[]",contentType: "application/json; charset=utf-8",dataType: "json",success: function(data){var output = data.map(i => "<tr><td>" + i.ID + "</td><td>" + i.Name + "</td><td>" + i.Phone + "</td><td>" + i.EmailID + "</td><td>" + i.Address + "</td></tr>");$("#studentdata").html(output);}});});</script> <div class="text-center"><h1>Student List</h1><table class="table table-bordered"><tr class="table-head"><th class="text-center">ID</th><th class="text-center">Name</th><th class="text-center">Phone</th><th class="text-center">EmailID</th><th class="text-center">Address</th></tr><tbody id="studentdata"></table></div> ``` In this tutorial, we have learned how to bind Json Data To Html Table. If you have any doubt, feel free to comment below.
Shard	160 (laksa)
Root Hash	13553251105045825560
Unparsed URL	in,co,dotnettutorial!www,/2022/05/using-database-bind-json-data-to-html-table-in-mvc.html s443