jqgrid autoincrement Sr No.

Question

Hi Friends, how to get auto incremented Serial no in jqgrid when i m adding data in jqgrid?? Plesae help me if you have knowledge in jqgrid....

Khargesh Rajput · Answer

visit http://www.trirand.net/examples/grid/appearance/rownumbers/default.aspx view C# tab here row numer are on selected index. we can use this on page load

dipti prasad · Answer

thanks for reply sir, but i dont know how to apply this code??? my jqgrid: $("#list").jqGrid({ url: '/BankPay/GetRecords/', datatype: "Json", contentType: "application/json; charset-utf-8", mtype: 'GET', colNames: ['Sr No.', 'Code', 'Plan/BU', 'Account Description', 'Sub Ldgr', 'Debit', 'Credit', 'Cost Center', 'Profit Center', 'Chq Type', 'Narr'], colModel: [ { name: 'Sno', index: 'Sno', align: "center", sortable: false, editable: true, editoptions: { size: 5 } }, { name: 'Code', index: 'Code', align: "center", sortable: false, editable: true, edittype: 'text' }, { name: 'Branch', index: 'Branch', align: "right", sortable: false, editable: true, edittype: 'text', editoptions: { dataInit: function (elem) { NameSearch(elem) } }}, { name: 'BankCode', index: 'BankCode', align: "right", sortable: false, editable: true, edittype: 'text', editoptions: { maxlength: 6 } }, { name: 'SubLdgr', index: 'SubLdgr', align: "right", sortable: false, editable: true, edittype: 'text' }, { name: 'Debit', index: 'Debit', align: "right", sortable: false, editable: true, edittype: 'text', formatter: 'integer' }, { name: 'Credit', index: 'Credit', align: "right", sortable: false, editable: true, edittype: 'text' }, { name: 'CostCentre', index: 'CostCentre', align: "center", sortable: false, editable: true, edittype: 'text' }, { name: 'ProfitCenter', index: 'ProfitCenter', align: "center", sortable: false, editable: true, edittype: 'text' }, { name: 'Cheque', index: 'Cheque', align: "center", sortable: false, editable: true, edittype: 'text' }, { name: 'Narr', index: 'Narr', align: "center", sortable: false, editable: true, edittype: 'text' } ], pager: "#pager", rowNum: 5, rownumbers: true, rowList: [5, 10, 15], height: 'auto', //height:'110', width: '940', viewrecords: true, reloadAfterSubmit: true, multiselect: true, reloadAfterSubmit: true, gridview: true, sortname: 'Sno', editurl: '/BankPay/EditRecords/', loadonce: true, reloadAfterSubmit: true, footerrow: true, loadComplete: function () { var $grid = $("#list"); var sum = $grid.jqGrid('getCol', 'Debit', false, 'sum'); $grid.jqGrid('footerData', 'set', { SubLdgr: 'Total (Dbt/Crt):', Debit: sum }); var sum1 = $grid.jqGrid('getCol', 'Credit', false, 'sum'); $grid.jqGrid('footerData', 'set', { Total: 'Total:', Credit: sum1 }); }, userDataOnFooter: true, caption: "Bank Payment", }); jQuery("#list").jqGrid('navGrid', '#pager', { edit: true, edittext: "Edit", add: true, addtext: "Add", del: true, deltext: "Delete", search: true, searchtext: "Search", refresh: true, refreshtext: "Refresh", alertcap: "Warning", alertext: "Please Select Row", }); please help me

Khargesh Rajput · Answer

var rowKey = jqgrid . getGridParam ( "selrow" ); var index = jqgrid . getInd ( rowKey ); var dataIDs = jqgrid . getDataIDs (); Together, you can get the id for the next row in your grid: var nextID = ( dataIDs . length index + 1 ) ? dataIDs [ index + 1 ] : dataIDs [ 0 ];

jqgrid autoincrement Sr No.

Answers (3)