i have bind jqgrid at runtime using append method like this:
Public Sub intializegrid()
Try
Dim sb As New StringBuilder
sb.Append("<script type='text/javascript'>")
sb.Append(" $(document).ready(function() {")
sb.Append("var g_inwno;")
sb.Append(" $('#dataGrid').jqGrid({")
sb.Append("url:'../Suganya.xml',")
sb.Append("datatype:'xml',")
sb.Append(" formatter: {")
sb.Append(" number: { decimalSeparator: '.', thousandsSeparator: ', ', decimalPlaces: 2, defaultValue: '0.000' }")
sb.Append("},")
sb.Append("colNames: ['row', 'Inw No', 'Inw Date', 'Order No', 'Accessories Description', 'Uom Desc', 'Quantity', 'Value', 'Party_name', 'Fin_Year', 'Acc_Code', 'Po_No', 'Size_Code'],")
sb.Append(" colModel: [")
sb.Append("{ name: 'row', index: 'row', width: 90, xmlmap: '>row', key: true, hidden: true },")
sb.Append(" { name: 'Inw_No', index: 'Inw_No', width: 100, xmlmap: '>Inw_No', sortable: true, sorttype: 'string' },")
sb.Append(" { name: 'Inw_Date', index: 'Inw_Date', width: 90, xmlmap: '>Inw_Date', key: true, sortable: true, sorttype: 'string' },")
sb.Append(" { name: 'Order_no', index: 'Order_no', width: 100, xmlmap: '>Order_no', sortable: true, sorttype: 'string' },")
sb.Append(" { name: 'Acc_desc', index: 'Acc_desc', width: 100, xmlmap: '>Acc_desc', sortable: true, sorttype: 'string' },")
sb.Append("{ name: 'Size_Name', index: 'Size_Code', width: 100, xmlmap: '>Size_Name', sortable: true, sorttype: 'string' },")
sb.Append("{ name: 'Uom_desc', index: 'Uom_desc', width: 100, xmlmap: '>Uom_desc', sortable: true, sorttype: 'string' },")
sb.Append(" { name: 'Inward_Qty', index: 'Inward_Qty', width: 100, xmlmap: '>Inward_Qty', sortable: true, align: 'right', formatter: 'number', summaryType: 'sum' },")
sb.Append(" { name: 'Value', index: 'Value', width: 100, xmlmap: '>Value', sortable: true, align: 'right', formatter: 'number', summaryType: 'sum' },")
sb.Append("{ name: 'Party_name', index: 'Party_name', width: 100, xmlmap: '>Party_name', hidden: true },")
sb.Append("{ name: 'Fin_Year', index: 'Fin_Year', width: 100, xmlmap: '>Fin_Year',hidden: true },")
sb.Append(" { name: 'Acc_Code', index: 'Acc_Code', width: 100, xmlmap: '>Acc_Code', hidden: true },")
sb.Append(" { name: 'Po_No', index: 'Po_No', width: 100, xmlmap: '>Po_No', hidden: true },")
sb.Append("{ name: 'Size_Code', index: 'Size_Code', width: 100, xmlmap: '>Size_Code', hidden: true }")
sb.Append("],")
sb.Append(" rowNum: 10,")
sb.Append(" viewrecords: true,")
sb.Append(" gridview: true,")
sb.Append("pager: '#pager',")
sb.Append("sortorder: 'asc',")
sb.Append("loadonce: true,")
sb.Append("scroll: true,")
sb.Append("width: 800,")
sb.Append(" height: 240,")
'sb.Append(" footerrow: true,")
sb.Append(" xmlReader: {")
sb.Append("root: 'NewDataSet',")
sb.Append(" row: 'Table1',")
sb.Append("repeatitems: false")
sb.Append(" },")
sb.Append("loadComplete: function() {")
sb.Append(" var rowId = $('#dataGrid').getDataIDs()[0];")
sb.Append(" $('#dataGrid').jqGrid('setSelection', rowId);")
sb.Append(" var Pojono = document.getElementById('txt_Pojono'); Pojono.value = $('#dataGrid').jqGrid('getCell', rowId, 'Po_No');")
sb.Append(" var Order = document.getElementById('txt_Order'); Order.value = $('#dataGrid').jqGrid('getCell', rowId, 'Order_no');")
sb.Append(" var Supp = document.getElementById('txt_Supp'); Supp.value = $('#dataGrid').jqGrid('getCell', rowId, 'Party_name');")
sb.Append(" $('#dataGrid').jqGrid('filterToolbar',")
sb.Append(" { searchOnEnter: false, stringResult: true, defaultsearch: 'cn', ignorecase: true, afterSearch: function()")
sb.Append(" { filteredIDs = $('#dataGrid').getDataIDs(); }")
sb.Append(" });")
sb.Append(" var gridData = $('#dataGrid').jqGrid('getGridParam', 'data'), i = 0, totalval = 0, totalqty = 0;")
sb.Append(" for (; i < gridData.length; i++) {")
sb.Append(" var rowData = gridData[i];")
sb.Append(" totalval += Number(rowData.Value);")
sb.Append(" totalqty += Number(rowData.Inward_Qty);")
sb.Append(" }")
sb.Append(" $('#dataGrid').jqGrid('footerData', 'set', { 'Value': totalval });")
sb.Append(" $('#dataGrid').jqGrid('footerData', 'set', { 'Inward_Qty': totalqty });")
sb.Append("},")
sb.Append(" onSelectRow: function(rowid) {")
sb.Append("var grid = $('#dataGrid');")
sb.Append("var sel_id = grid.getGridParam('selrow');")
sb.Append("var rownum = grid.jqGrid('getCell', sel_id, 0);")
sb.Append("var Pojono = document.getElementById('txt_Pojono'); Pojono.value = grid.jqGrid('getCell', sel_id, 'Po_No');")
sb.Append(" var Order = document.getElementById('txt_Order'); Order.value = grid.jqGrid('getCell', sel_id, 'Order_no');")
sb.Append("var Supp = document.getElementById('txt_Supp'); Supp.value = grid.jqGrid('getCell', sel_id, 'Party_name');")
sb.Append(" var InwNo = grid.jqGrid('getCell', sel_id, 'Inw_No');")
sb.Append("var AccCode = grid.jqGrid('getCell', sel_id, 'Acc_Code');")
sb.Append("var FinYear = grid.jqGrid('getCell', sel_id, 'Fin_Year');")
sb.Append(" var sizecode = grid.jqGrid('getCell', sel_id, 'Size_Code');")
sb.Append("var a_inwno = InwNo + ', ' + AccCode + ', ' + FinYear + ', ' + sizecode;")
sb.Append("g_inwno = a_inwno;")
sb.Append(" },")
sb.Append(" ondblClickRow: function(rowid, iRow, iCol, e) {")
sb.Append(" var grid = $('#dataGrid');")
sb.Append(" var sel_id = grid.getGridParam('selrow');")
sb.Append("var inwno = grid.jqGrid('getCell', sel_id, 'Inw_No');")
sb.Append(" var acccode = grid.jqGrid('getCell', sel_id, 'Acc_Code');")
sb.Append(" var finyr = grid.jqGrid('getCell', sel_id, 'Fin_Year');")
'var sizecode = grid.jqGrid('getCell', sel_id, 'Size_Code');")
sb.Append(" if (sel_id != null) {")
sb.Append(" $.ajax({ type: 'POST',")
sb.Append("contentType: 'application/json; charset=utf-8',")
sb.Append("url: 'InwardWiseAccStock.aspx/SetSession',")
sb.Append(" data: ""{'value1':'"" + inwno + ',' + acccode + ',' + finyr + ""'}"",")
sb.Append("dataType: 'json',")
sb.Append(" success: function(data) {")
sb.Append(" pagename = '../../Accessories/InwardWiseAccStock/Inwwiseaccstockpodetails.aspx';")
sb.Append("window.open(pagename, '_blank', 'top=100,left=100,width=530,height=430,resizable=0');")
sb.Append(" },")
sb.Append(" error: function(result)")
sb.Append(" { alert('Error'); }")
sb.Append(" });")
sb.Append(" }")
sb.Append(" else {")
sb.Append(" alert('pls. Select Row');")
sb.Append("}")
sb.Append("}")
sb.Append("});")
sb.Append("$('#btn_BinDetails').click(function() {")
sb.Append(" $.ajax({")
sb.Append(" type: 'POST',")
sb.Append(" contentType: 'application/json; charset=utf-8',")
sb.Append(" url: 'InwardWiseAccStock.aspx/SetSession1',")
sb.Append(" data: ""{'value2':'"" + g_inwno + ""'}"",")
sb.Append(" dataType: 'json',")
sb.Append(" success: function(data) {")
sb.Append(" pagename = '../../Accessories/InwardWiseAccStock/InwWiseAccStokBinDetls.aspx';")
sb.Append(" window.open(pagename, '_blank', 'top=100,left=100,width=630,height=430,resizable=0');")
sb.Append(" },")
sb.Append(" error: function(result) {")
sb.Append(" alert('Error');")
sb.Append(" }")
sb.Append("});")
sb.Append("});")
sb.Append("});")
sb.Append("</script>")
ScriptManager.RegisterClientScriptBlock(Me, GetType(Page), "UniqueID1", sb.ToString, False)
Catch ex As Exception
Msgbox(ex.ToString(), "Error", 0, False, True)
End Try
End Sub
while binding the record it throws error like "system.web.http unhandled exception"
at server end.
and also none of the button is working after binding the Jgrid
can you say solution for this?how can it overcome?
thanks in advance