This is my Extension Controller
public ActionResult Index()
{
return View();
}
[HttpGet]
public JsonResult LoadData()
{
MvcBasicSiteEntities1 _db = new MvcBasicSiteEntities1();
{
var users = new List<User>();
var userList = _db.Users.ToList();
var data = userList.ToArray();
var result = new
{
rows=(from item in data
select new
{
ID = item.ID,
Username = item.Username,
Password = item.Password,
Role = item.Role,
Email = item.Email
}).ToArray()
};
return Json(result, JsonRequestBehavior.AllowGet);
}
}
This is my index view
<head>
<link href="~/Cont/dd.css" rel="stylesheet" />
<link href="~/Cont/Site.css" rel="stylesheet" />
<link href="~/Cont/ui.jqgrid.css" rel="stylesheet" />
</head>
<table id="_extensionLogGrid" cellpadding="0" cellspacing="0">
</table>
<div id="_extensionLogPager" style="text-align: center;">
</div>
<script src="~/Scripts/jquery-1.8.2.js"></script>
<script type="text/javascript">
$(document).ready(function () {
debugger;
$("_extensionLogGrid").jqGrid({
onload: location.href = '@Url.Action("LoadData", "Extension")',
datatype: 'json',
colNames: ['Id', 'UserName', 'Password', 'Email', 'Role', 'AddressId'],
colModel: [
{ name: '_id', index: '_id', width: 300 },
{ name: 'UserName', index: 'Username', width: 300 },
{ name: 'Password', index: 'Password', width: 150 },
{ name: 'Email', index: 'Email', width: 150 },
{ name: 'Role', index: 'Role', width: 120 },
{ name: 'AddressId', index: 'AddressId', width: 70 }
],
pager: jQuery('#_extensionLogPager'),
sortname: 'ID',
rowNum: 10,
rowList: [10, 20, 50, 100],
sortorder: "desc",
width: 790,
height: 464,
caption: 'Users',
viewrecords: true,
mtype: 'GET',
loadonce: true
});
})
</script>
I added jqGrid script file in Bundle.config file.
After run it displayed like this
{"rows":[{"ID":1,"Username":"Administrator","Password":"tm77dac","Role":1,"Email":"admin@yahoo.com"},{"ID":3,"Username":"Ana","Password":"ana","Role":2,"Email":"ana@yahoo.com"},{"ID":4,"Username":"Ion","Password":"ion","Role":2,"Email":"ion@yahoo.com"},{"ID":5,"Username":"Vasile","Password":"vasile","Role":2,"Email":"vasile@basicsite.ro"},{"ID":6,"Username":"vanmala","Password":"vanmala","Role":1,"Email":"vanmala@basicsite.com"}]}
what is wrong with this.