如何将数据从ms sql加载到jqGrid [英] how to load data from ms sql to jqGrid
本文介绍了如何将数据从ms sql加载到jqGrid的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请帮帮我
我在jqgrid工作
i想把数据加载到jq网格
我的代码如下< br $>
Please help me
i'm working in jqgrid
i want to load the data to jq grid
my codes are as follows
$("#jqgEmpSearch").jqGrid({
url:"Servicelibrary/employeesearch.aspx", //?empid="+$("[id*=txtSrchEmpID]").val()+""
datatype:"json",
colNames:['Emp Number','Emp Name'], // UM_Employee_Number UM_FirstName
colModel:[
{name:'UM_Employee_Number', index:'UM_Employee_Number',width:'150'},
{name:'UM_FirstName', index:'UM_FirstName',width:'150'}
],
rowNum:5,
rowList:[5, 10,20,30,40,50],
pager:'#jqgEmpSearchPager',
sortname:'EmpNum',
viewrecords:true,
pager:'#jqgDiv',
caption:"Employee Search Result",
loadonce:true
});
推荐答案
( #jqgEmpSearch)。jqGrid({
url: Servicelibrary / employeesearch.aspx, // ?empid =+
("#jqgEmpSearch").jqGrid({ url:"Servicelibrary/employeesearch.aspx", //?empid="+
([id * = txtSrchEmpID])。val()+
数据类型: json,
colNames:[' Emp Number',' Emp Name'], // UM_Employee_Number UM_FirstName
colModel:[
{name:' UM_Employee_Number' ,index:' UM_Employee_Number',width:' 150'},
{name:' UM_FirstName',索引:' UM_FirstName',width:< span class =code-string>' 150'}
],
rowNum: 5 ,
rowList:[ 5 , 10 , 20 , 30 , 40 , 50 ],
pager:' #jqgEm pSearchPager',
sortname:' EmpNum',
viewrecords : true ,
pager:' #jqgDiv ',
标题: 员工搜索结果,
loadonce: true
});
("[id*=txtSrchEmpID]").val()+"" datatype:"json", colNames:['Emp Number','Emp Name'], // UM_Employee_Number UM_FirstName colModel:[ {name:'UM_Employee_Number', index:'UM_Employee_Number',width:'150'}, {name:'UM_FirstName', index:'UM_FirstName',width:'150'} ], rowNum:5, rowList:[5, 10,20,30,40,50], pager:'#jqgEmpSearchPager', sortname:'EmpNum', viewrecords:true, pager:'#jqgDiv', caption:"Employee Search Result", loadonce:true });
这篇关于如何将数据从ms sql加载到jqGrid的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文