我有一个相对简单的.NET应用程序,只有一个页面。
当调用相关控制器以获取代码并使用脚本打印出来时,代码旨在在运行时填充表格。
我的控制器:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;
using techTest3.Models;
namespace techTest3.Controllers
{
public class HomeController : Controller
{
public ActionResult Index()
{
return View();
}
public JsonResult GetAllPeople()
{
TechTestEntities testTechObj = new TechTestEntities();
var people = testTechObj.People.Select(x => new
{
Id = x.PersonId,
Name = x.FirstName,
Surname = x.LastName,
Valid = x.Var1,
Authorised = x.Var2
}).ToList();
return Json(people, JsonRequestBehavior.AllowGet);
}
}
}
我的观点:
@{
ViewBag.Title = " Showing Data Using jQuery Ajax Call JSON in ASP.NET MVC";
}
<h1>Showing Data Using jQuery Ajax Call JSON in ASP.NET MVC </h1>
<div>
<table id = "tblEmployee" class = "tblEmployee" >
<thead>
<!---<img src = "~/Loading.gif" alt = "Loading" id = "imgLoading" class = "Load" />-->
</thead>
<tbody>
</tbody>
</table>
</div>
<script src="~/Scripts/jquery-1.10.2.min.js"></script>
<script type = "text/javascript" >
$(document).ready(function()
{
$("#tblEmployeetbodytr").remove();
$.ajax
({
type: 'POST',
url: '@Url.Action("GetAllPeople")',
dataType: 'json',
data: {},
success: function(data)
{
$("#imgLoading").hide();
var items = '';
var rows = "<tr>" +
"<th align='left' class='EmployeeTableTH'>Employee ID</th><th align='left' class='EmployeeTableTH'>Name</th><th align='left' class='EmployeeTableTH'>Project Name</th><th align='left' class='EmployeeTableTH'>Manager Name</th><th align='left' class='EmployeeTableTH'>City</th>" +
"</tr>";
$('#tblEmployeetbody'
).append(rows);
$.each(data, function(i, item)
{
var rows = "<tr>" +
"<td class='EmployeeTableTD'>" + item.Id + "</td>" +
"<td class='EmployeeTableTD'>" + item.FirstName + "</td>" +
"<td class='EmployeeTableTD'>" + item.LastName + "</td>" +
"<td class='EmployeeTableTD'>" + item.Var1 + "</td>" +
"<td class='EmployeeTableTD'>" + item.Var2 + "</td>" +
"</tr>";
$('#tblEmployeetbody').append(rows);
});
},
error: function(ex)
{
var r = jQuery.parseJSON(response.responseText);
alert("Message: " + r.Message);
}
});
return false;
}); </script>
<style type = "text/css" >
</style>
TechTestEntities是一个edmx模型的名称,该模型引用了一个SQL数据库。
当我调试应用程序时,出现404未找到错误。这种情况发生在url为'<%= Url.Action("GetAllPeople", "HomeController") %>'、'/Controllers/HomeController/GetAllPeople'和'@Url.Action("/HomeController.cs/GetAllPeople")'时。
是否有什么显而易见的问题我忽略了?请注意,我对AJAX和Javascript非常陌生。
[HttpPost]
修饰GetAllPeople
操作,否则它只会响应GET请求。 - Maria Ines Parnisari@Url.Action("GetAllPeople", "Home")
中删除单词“Controller”。 - JasenHttpPost
并返回JsonResult
,因此请删除JsonRequestBehavior.AllowGet
并改为使用return Json(people)
。 - Tetsuya Yamamoto