无法编辑jqgrid中从数据库中获取数据的数据 [英] unable to edit data in jqgrid fetching data from database
本文介绍了无法编辑jqgrid中从数据库中获取数据的数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
$(document).ready(function() {
$.ajax({
type: "POST",
contentType: "application/json",
data: "{}",
url: "MooseUpdate.aspx/getEditMoose",
dataType: "json",
shrinkToFit: false,
success: function(data) {
data = data.d;
$("#list").jqGrid({
datatype: "local",
colNames: ['Event ID', 'SBCUID', 'Event Description', 'Calendar Date', 'Availablity'],
colModel: [{ name: 'EventID', index: 'EventID', width: 65, stype: 'text', sortable: true, sorttype: 'int', editable: false, editrules: { integer: true} },
{ name: 'SBCUID', index: 'SBCUID', width: 75, stype: 'text', sortable: true, editable: false },
{ name: 'EventDesc', index: 'EventDesc', width: 140, stype: 'text', sortable: true, formoptions: { rowpos: 1, colpos: 1 }, editrules: { integer: false }, align: 'center',
editable: true,
edittype: 'select',
formatter: 'select',
editoptions: { value: "Office:Office;unavailable:unavailable" }
},
{ name: 'CalDate', index: 'CalDate', width: 150, stype: 'text', sortable: true, editable: false },
{ name: 'avbl', index: 'avbl', width: 150, stype: 'text', sortable: true, editable: true, formoptions: { rowpos: 2, colpos: 1 }, editrules: { string: true} }
],
data: JSON.parse(data),
rowNum: 60,
loadonce: false,
cmTemplate: { sortable: false },
rowlist: [10, 20, 30],
emptyrecords: "Nothing to display",
pager: '#pager',
viewrecords: true,
gridview: true,
sortorder: 'asc',
toppager: true,
cloneToTop: true,
altrows: true,
autowidth: false,
hoverrows: true,
width: 700,
caseSensitive: false,
ignoreCase: true,
enabletooltips: true,
height: 400,
jsonReader: {
repeatitems: true
},
sortname: 'EventID',
toolbar: [true, "top"],
rownumbers: true,
caption: "Moose Update",
editurl: 'MooseUpdate.aspx/UpdateMoose',
'cellEdit': true
})
推荐答案
(document).ready(function(){
(document).ready(function() {
.ajax({
type:POST,
contentType:application / json ,
数据:{},
url:MooseUpdate.aspx / getEditMoose,
dataType:json,
shrinkToFit:false,
成功:function(data){
data = data.d;
.ajax({ type: "POST", contentType: "application/json", data: "{}", url: "MooseUpdate.aspx/getEditMoose", dataType: "json", shrinkToFit: false, success: function(data) { data = data.d;
(#list)。jqGrid({
datatype:local,
colNames:['Event ID','SBCUID','Event Description','Calendar Date','Availablity'],
colModel:[{name:'EventID',index:'EventID',width: 65,stype:'text',sortable:true,sorttype:'int',editable:false,editrules:{integer:true}},
{name:'SBCUID',index:'SBCUID',width: 75,stype:'text',sortable:true,editable:false},
{name:'EventDesc',index:'EventDesc',width:140,stype:'text',sortable:true,formoptions: {rowpos:1,colpos:1},editrules:{integer:false},align:'center',
editable:true,
edittype:'select',
formatter:'select ',
editoptions:{值:办公室:办公室;不可用:不可用}
},
{名称:'CalDate',索引:'CalDate',宽度:150,stype:'text',sortable:true,editable:false},
{name:' avbl',index:'avbl',width:150,stype:'text',sortable:true,editable:true,formoptions:{rowpos:2,colpos:1},editrules:{string:true}}
],
数据:JSON.parse(数据),
rowNum:60,
loadonce:false,
cmTemplate:{sortable:false},
rowlist: [10,20,30],
emptyrecords:无显示,
寻呼机:'#pager',
viewrecords:true,
gridview:true,
sortorder:'asc',
toppager:true,
cloneToTop:true,
altrows:true,
autowidth:false,
hoverrows:true,
width:700,
caseSensitive: false,
ignoreCase:true,
enabletooltips:true,
height:400,
jsonReader:{
repeatitems:true
},
sortname:'eventID',
toolbar:[true,top],
rownumbers:true,
标题:驼鹿更新,
editurl:'MooseUpdate.aspx / UpdateMoose',
'cellEdit':true
})
("#list").jqGrid({ datatype: "local", colNames: ['Event ID', 'SBCUID', 'Event Description', 'Calendar Date', 'Availablity'], colModel: [{ name: 'EventID', index: 'EventID', width: 65, stype: 'text', sortable: true, sorttype: 'int', editable: false, editrules: { integer: true} }, { name: 'SBCUID', index: 'SBCUID', width: 75, stype: 'text', sortable: true, editable: false }, { name: 'EventDesc', index: 'EventDesc', width: 140, stype: 'text', sortable: true, formoptions: { rowpos: 1, colpos: 1 }, editrules: { integer: false }, align: 'center', editable: true, edittype: 'select', formatter: 'select', editoptions: { value: "Office:Office;unavailable:unavailable" } }, { name: 'CalDate', index: 'CalDate', width: 150, stype: 'text', sortable: true, editable: false }, { name: 'avbl', index: 'avbl', width: 150, stype: 'text', sortable: true, editable: true, formoptions: { rowpos: 2, colpos: 1 }, editrules: { string: true} } ], data: JSON.parse(data), rowNum: 60, loadonce: false, cmTemplate: { sortable: false }, rowlist: [10, 20, 30], emptyrecords: "Nothing to display", pager: '#pager', viewrecords: true, gridview: true, sortorder: 'asc', toppager: true, cloneToTop: true, altrows: true, autowidth: false, hoverrows: true, width: 700, caseSensitive: false, ignoreCase: true, enabletooltips: true, height: 400, jsonReader: { repeatitems: true }, sortname: 'EventID', toolbar: [true, "top"], rownumbers: true, caption: "Moose Update", editurl: 'MooseUpdate.aspx/UpdateMoose', 'cellEdit': true })
这篇关于无法编辑jqgrid中从数据库中获取数据的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文