进段时间在做的jqgrid 的项目,总结一下用法
1.首先下载 jquery.jqGrid 的js包把它放到你的项目里。
GRID首页
http://www.trirand.com/blog/
demo地址
http://www.trirand.com/blog/jqgrid/jqgrid.html
文档地址
http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs
下载地址
http://www.trirand.com/blog/?page_id=6
theme的选择参考:
http://www.trirand.com/jqgridwiki/doku.php?id=wiki:download
我自己做的一个demo
jQuery("#list1").jqGrid({
url: 'Home/LoadAll',
width: 470,
mtype:"post",
height: 700,
datatype: "json",
colNames: ['名称', '性别', '考试日期', '考场编号', '成绩'],
colModel: [
{ name: 'Name', index: 'Name', width: 90 },
{ name: 'Sex', index: 'Sex', width: 30 },
{ name: 'ExamDate', index: 'ExamDate', width: 90 },
{ name: 'ExamRoom', index: 'ExamRoom', width: 90 },
{ name: 'Sore', index: 'Sore', width: 90 }
],
jsonReader: {
root: "rows",
page: "page",
total: "total",
records: "records",
repeatitems: false,
id: "0"
},
rowNum: 10,
rowList: [10, 20, 30],
pager: '#pager1',
sortname: 'ID',
viewrecords: true,
sortorder: "desc",
caption: "考试成绩"
});
jQuery("#list1").jqGrid('navGrid', '#pager1', { edit: false, add: false, del: false });
<table id="list1">
</table>
<div id="pager1">
</div>
controller代码:
[AcceptVerbs(HttpVerbs.Post)]
public JsonResult LoadAll()
{
//JQGrid.JqgridData jqData = new JQGrid.JqgridData();
Object[] rows = new Object[100]; //存储全部数据
for (int i = 0; i < 100; i++)
{
string sex = null;
if (i % 3 == 0)
sex = "女";
else
sex = "男";
rows[i] = (new {Name = "考生" + i, Sex = sex, ExamDate =string.Format("{0:D}",DateTime.Now), ExamRoom = "考场" + i % 3, Sore = 88 + (i % 9).ToString() });
}
return this.Json(new { rows = rows, page = 1, total = 10, records = 100}, JsonRequestBehavior.AllowGet);
}