jQWidgets Forums
Forum Replies Created
Viewing 11 posts - 1 through 11 (of 11 total)
-
Author
-
October 11, 2012 at 6:39 pm in reply to: Uncaught TypeError: Cannot call method ‘toString’ of null Uncaught TypeError: Cannot call method ‘toString’ of null #9307
So it isn’t possible to delete a date once input into the grid (in edit mode)? I saw a post on the DateTimeInput forum that talked about that functionality and that it had been added to the control itself. I thought perhaps I was just doing something wrong (which is most likely).
Robert
October 10, 2012 at 8:39 pm in reply to: Uncaught TypeError: Cannot call method ‘toString’ of null Uncaught TypeError: Cannot call method ‘toString’ of null #9217Any update on this?
Robert
October 5, 2012 at 12:13 pm in reply to: Uncaught TypeError: Cannot call method ‘toString’ of null Uncaught TypeError: Cannot call method ‘toString’ of null #8980Peter,
Yes, I usually select it all and then click delete.
Robert
October 4, 2012 at 7:22 pm in reply to: Uncaught TypeError: Cannot call method ‘toString’ of null Uncaught TypeError: Cannot call method ‘toString’ of null #8933HTML:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="DBIW.Tabs.test" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <link href="../Includes/CSS/uploadify.css" rel="stylesheet" type="text/css" /> <link href="../Includes/Themes/base/base.css" rel="stylesheet" type="text/css" /> <link href="../Includes/CSS/jqx.base.css" rel="stylesheet" type="text/css" /> <link href="../Includes/CSS/jqx.classic.css" rel="stylesheet" type="text/css" /> <script src="../Includes/JS/jquery-1.7.1.min.js" type="text/javascript"></script> <script src="../Includes/JS/jquery-ui-1.8.18.custom.min.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jquery.global.js" type="text/javascript"></script> <script src="../Includes/JS/jquery.ui.widget.js" type="text/javascript"></script> <script src="../Includes/JS/jquery.ui.position.js" type="text/javascript"></script> <script src="../Includes/JS/jquery.global.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxcore.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxbuttons.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxdata.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxdata.export.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.pager.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxlistbox.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxdropdownlist.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.selection.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxmenu.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxscrollbar.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.aggregates.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.columnsresize.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.edit.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.export.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.filter.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.grouping.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.sort.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxnumberinput.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxdatetimeinput.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxcalendar.js" type="text/javascript"></script> <script src="../Includes/JS/jquery.uploadify.min.js" type="text/javascript"></script> <script src="../Includes/JS/date.js" type="text/javascript"></script><style type="text/css"> html,body{ font-family: Tahoma; font-size: 10px; text-align: left; color: #000000; height: 98%; margin-top: 0; padding: 1px; margin-left: 0; margin-right: 0;} .dtpicker { width: 65px; } /* IE 6 doesn't support max-height * we use height instead, but this forces the menu to always be this tall */ * html .ui-autocomplete { height: 100px; } </style><script type="text/javascript"> $(document).ready(function () { // divUpload alert("I am currently working on this page. If you experience errors that is why. ~ MSG Lewis"); $("#btnAddNew").jqxButton({ width: '80px', height: '25px', theme: 'darkblue' }); $("#btnAddNew").click(function () { $("#dialog-form").dialog("open"); }); $(".dtpicker").datepicker(); $.getJSON("uspfo/log/logajax.aspx?id=getADUsers", function (data) { $.each(data, function (key, value) { $("#FROM_USER").append('<option value="' + value + '">' + key + '</option>'); }); }); $.getJSON("uspfo/log/logajax.aspx?id=cardHolders", function (data) { $.each(data, function (key, value) { $("#CARD_HOLDER").append('<option value="' + value + '">' + key + '</option>'); }); }); $("#btnExportExcel").jqxButton({ width: '80px', height: '25px', theme: 'darkblue' }); $("#btnExportExcel").click(function () { $("#jqxgrid").jqxGrid('exportdata', 'xls', 'jqxGrid'); }); //Getting the source data with ajax GET request source = { datatype: "xml", datafields: [ { name: 'DOC_NBR' }, { name: 'FROM_USER' }, { name: 'STATUS' }, { name: 'DATE_RECEIVED', type: 'datetimeinput' }, { name: 'DATE_FUNDED', type: 'datetimeinput' }, { name: 'MERCH_RCVD_DATE', type: 'datetimeinput' }, { name: 'REASON_DELAYED' }, { name: 'CARD_HOLDER' }, { name: 'PURCHASE_DESC' }, { name: 'PURCHASE_AMT', type: 'float' }, { name: 'REQ_DELIVERY_DATE', type: 'datetimeinput' }, { name: 'VENDOR_NAME' }, { name: 'SAG' }, { name: 'DOC_ID' }, { name: 'FILES' } ], async: false, record: 'Table', url: 'uspfo/log/logajax.aspx?id=ngil715', sortcolumn: 'DOC_NBR', sortdirection: 'asc', data: { featureClass: "P", style: "full", maxRows: 50 }, success: function (data) { $("#jqxgrid").jqxGrid('updatebounddata'); }, sort: function () { $("#jqxgrid").jqxGrid('updatebounddata'); }, filter: function () { // update the grid and send a request to the server. $("#jqxgrid").jqxGrid('updatebounddata'); }, updaterow: function (rowid, rowdata) { var data = "id=ngil715Update" + "&DOC_NBR=" + rowdata.DOC_NBR + "&FROM_USER=" + rowdata.FROM_USER + "&STATUS=" + rowdata.STATUS + "&DATE_RECEIVED=" + rowdata.DATE_RECEIVED.toString('MM/dd/yyyy') + "&DATE_FUNDED=" + rowdata.DATE_FUNDED.toString('MM/dd/yyyy') + "&MERCH_RCVD_DATE=" + rowdata.MERCH_RCVD_DATE.toString('MM/dd/yyyy') + "&REASON_DELAYED=" + rowdata.REASON_DELAYED + "&CARD_HOLDER=" + rowdata.CARD_HOLDER + "&PURCHASE_DESC=" + rowdata.PURCHASE_DESC + "&PURCHASE_AMT=" + rowdata.PURCHASE_AMT + "&REQ_DELIVERY_DATE=" + rowdata.REQ_DELIVERY_DATE.toString('MM/dd/yyyy') + "&VENDOR_NAME=" + rowdata.VENDOR_NAME + "&SAG=" + rowdata.SAG + "&DOC_ID=" + rowdata.DOC_ID; $.ajax({ url: "uspfo/log/logajax.aspx?" + data, type: "POST", success: function (message) { }, // success: function(), error: function (message) { $('#divErrorMsg').html('An error occurred:' + message.responseText); var modal = $('#divDialog').dialog({ modal: true, closeOnEscape: true, title: "SAVE RESULTS" }); // var modal = $('#divDialog').dialog( $('#divDialog').dialog(); } // error function() }); // $.ajax({ $("#jqxgrid").jqxGrid('updatebounddata'); } // updaterow: function (rowid, rowdata) { }; // source = { // Sorting $("#jqxgrid").bind("sort", function (event) { var sortinformation = event.args.sortinformation; var sortdirection = sortinformation.sortdirection.ascending ? "ascending" : "descending"; if (!sortinformation.sortdirection.ascending && !sortinformation.sortdirection.descending) { sortdirection = "null"; } $("#jqxgrid").jqxGrid('updatebounddata'); }); $.ajax({ url: 'test.aspx/GetTotalRowsCount', contentType: 'application/json; charset=utf-8', async: false, success: function (data) { source.totalrecords = data.d; } }); var linkrenderer = function (row, column, value) { var arrFile = value.split('/'); var html = '<a href="' + value + '" target="_blank">' + arrFile[arrFile.length - 1] + '</a>'; return html; } var dataAdapter = new $.jqx.dataAdapter(source, { contentType: 'application/json; charset=utf-8' } ); $("#jqxgrid").jqxGrid({ source: dataAdapter, width: '98%', columnsresize: true, theme: 'classic', pageable: true, autoheight: true, virtualmode: true, sortable: true, editable: true, selectionmode: 'singlecell', sorttogglestates: 1, autoshowfiltericon: true, filterable: true, rendergridrows: function () { return dataAdapter.records; }, columns: [ { text: 'DOC NBR', dataField: 'DOC_NBR', width: 175, sortable: true }, { text: 'FROM', dataField: 'FROM_USER', width: 150, sortable: true }, { text: 'STATUS', dataField: 'STATUS', columntype: 'dropdownlist', width: 100, sortable: true }, { text: 'DATE RECEIVED', dataField: 'DATE_RECEIVED', width: 100, sortable: true, columntype: 'datetimeinput', cellsalign: 'right', cellsformat: 'MM/dd/yyyy', validation: function (cell, value) { var dtEntered = value.toString("MM/dd/yyyy"); if (Date.parse(dtEntered)) return true; else { return { result: false, message: "Invalid date entered" }; } } }, { text: 'DATE FUNDED', dataField: 'DATE_FUNDED', columntype: 'datetimeinput', cellsformat: 'MM/dd/yyyy', width: 100, sortable: true, validation: function (cell, value) { var dtEntered = value.toString("MM/dd/yyyy"); if (Date.parse(dtEntered)) return true; else { return { result: false, message: "Invalid date entered" }; } } }, { text: 'DATE MERCH RCVD', dataField: 'MERCH_RCVD_DATE', columntype: 'datetimeinput', cellsformat: 'MM/dd/yyyy', width: 100, sortable: true }, { text: 'REASON DELAYED', dataField: 'REASON_DELAYED', width: 200, sortable: true }, { text: 'ACTION TAKEN BY', dataField: 'CARD_HOLDER', columntype: 'dropdownlist', width: 150, sortable: true }, { text: 'PURCHASE DESC', dataField: 'PURCHASE_DESC', width: 200, sortable: true }, { text: 'PURCHASE AMT', dataField: 'PURCHASE_AMT', width: 100, sortable: true, cellsalign: 'right', cellsformat: 'c2' }, { text: 'REQ DELIVERY DATE', dataField: 'REQ_DELIVERY_DATE', columntype: 'datetimeinput', cellsformat: 'MM/dd/yyyy', width: 100, sortable: true }, { text: 'VENDOR NAME', dataField: 'VENDOR_NAME', width: 200, sortable: true }, { text: 'SAG', dataField: 'SAG', width: 75, sortable: true }, { text: 'DOC_ID', datafield: 'DOC_ID', width: 25, sortable: false }, { text: 'FILES (double click to view)', datafield: 'FILES', width: 200, sortable: false, cellsrenderer: linkrenderer } ] }); $('#jqxgrid').jqxGrid('hidecolumn', 'DOC_ID'); $("#jqxgrid").bind('cellendedit', function (event) { var args = event.args; //if ((args.datafield == "DATE_FUNDED") && (args.value == "")) // $("#jqxgrid").jqxDateTimeInput('DATE_FUNDED', null); }); $("#jqxgrid").bind('cellselect', function (event) { var columnheader = $("#jqxgrid").jqxGrid('getcolumn', event.args.datafield).text; var rowindex = event.args.rowindex; var DOC_ID = $('#jqxgrid').jqxGrid('getcellvalue', rowindex, "DOC_ID"); $('#selectedRow').val(rowindex); $('#divUpload').uploadify({ height: 30, buttonText: 'Upload', swf: '../Includes/swf/uploadify.swf', uploader: '../Includes/swf/uploadify.php', width: 120, onUploadStart: function (file) { var formData = { 'DOC_ID': DOC_ID } $('#divUpload').uploadify("settings", "formData", formData); }, onUploadComplete: function (file) { $("#jqxgrid").jqxGrid('updatebounddata'); } }); }); // Dialog box function checkLength(o, n, min, max) { if (o.val().length > max || o.val().length < min) { o.addClass("ui-state-error"); updateTips("Length of " + n + " must be between " + min + " and " + max + "."); return false; } else { return true; } } var DODAAC = $("#DODAAC"), JULIAN = $("#JULIAN"), SEQUENCE = $("#SEQUENCE"), FROM_USER = $("#FROM_USER"), DATE_RECEIVED = $("#DATE_RECEIVED"), STATUS = $("#STATUS"), CARD_HOLDER = $("#CARD_HOLDER"), PURCHASE_DESC = $("#PURCHASE_DESC"), PURCHASE_AMT = $("#PURCHASE_AMT"), VENDOR_NAME = $("#VENDOR_NAME"), REQ_DELIVERY_DATE = $("#REQ_DELIVERY_DATE"), SAG = $("#SAG"), allFields = $([]).add(DODAAC).add(JULIAN).add(SEQUENCE).add(STATUS).add(FROM_USER).add(DATE_RECEIVED).add(CARD_HOLDER).add(PURCHASE_DESC).add(PURCHASE_AMT).add(VENDOR_NAME).add(REQ_DELIVERY_DATE).add(SAG), tips = $(".validateTips"); function updateTips(t) { tips .text(t) .addClass("ui-state-highlight"); setTimeout(function () { tips.removeClass("ui-state-highlight", 1500); }, 500); } $("#dialog-form").dialog({ autoOpen: false, height: 475, width: 525, modal: true, buttons: { "Add Record": function () { var bValid = true; allFields.removeClass("ui-state-error"); bValid = bValid && checkLength(DODAAC, "DODAAC", 6, 6); bValid = bValid && checkLength(JULIAN, "JULIAN", 4, 4); bValid = bValid && checkLength(SEQUENCE, "SEQUENCE", 4, 4); bValid = bValid && checkLength(DATE_RECEIVED, "DATE_RECEIVED", 10, 10); bValid = bValid && checkLength(PURCHASE_DESC, "PURCHASE_DESC", 5, 255); bValid = bValid && checkLength(PURCHASE_AMT, "PURCHASE_AMT", 3, 10); bValid = bValid && checkLength(VENDOR_NAME, "VENDOR_NAME", 5, 255); bValid = bValid && checkLength(REQ_DELIVERY_DATE, "REQ_DELIVERY_DATE", 10, 10); if (bValid) { $.ajax({ url: "uspfo/log/logajax.aspx?id=add715" + "&DODAAC=" + $('#DODAAC').val() + "&JULIAN=" + $('#JULIAN').val() + "&SEQUENCE=" + $('#SEQUENCE').val() + "&FROM_USER=" + $('#FROM_USER').find("option:selected").val() + "&DATE_RECEIVED=" + $('#DATE_RECEIVED').val() + "&STATUS=" + $('#STATUS').find("option:selected").val() + "&CARD_HOLDER=" + $('#CARD_HOLDER').find("option:selected").val() + "&PURCHASE_DESC=" + $('#PURCHASE_DESC').val() + "&PURCHASE_AMT=" + $('#PURCHASE_AMT').val() + "&VENDOR_NAME=" + $('#VENDOR_NAME').val() + "&REQ_DELIVERY_DATE=" + $('#REQ_DELIVERY_DATE').val() + "&SAG=" + $('#SAG').find("option:selected").val(), type: "POST", success: function (msg) { $("#jqxgrid").jqxGrid('updatebounddata'); $(this).dialog("close"); }, error: function (msg) { updateTips("Error: " + msg.responseText); return false; } // error function() }); // $.ajax( } // if (bValid) }, Cancel: function () { $(this).dialog("close"); } }, close: function () { allFields.val("").removeClass("ui-state-error"); } }); });</script></head><body><div id="divOuter" class="ui-dialog ui-widget ui-widget-content ui-corner-all" style="width: 99%; text-align: left; position: relative;"> <div id="divTitle" class="ui-dialog-titlebar ui-widget-header ui-corner-all ui-helper-clearfix"> GPC Purchase Request </div> <div id="divControl" style="width: 99%;" class="ui-dialog-content ui-widget-content" id="dialog"> <div id="divUses" class="instructions">Uses: Used to track GPC Purchases requests.</div> <div id="divInstructions" class="instructions">To add a GPC Purchase request, click the "Add" button. <br /> To edit an existing record, just click in the grid where you need to edit, make whatever changes are necessary, and then click on a different cell in the grid. Updates are saved as you make them. <br /> To upload a supporting document, click any field in the row to which you would like to attach the document and then click the upload button. Select the file that you wish to upload and then click the "Open" button. Under the "Upload" button you will see the upload progress. Once uploaded, the file will show up for that record in the "Files" column of that row.</div> <hr /><table border="0" cellpadding="2" cellspacing="2"> <tr> <td><div id='btnAddNew'><img style='float: left; margin: 4px;' src='../Includes/Images/File-New-icon.png' alt="" height="16" width="16" /><div style='float: left; margin: 4px;'>Add</div></div> </td> <td><div id='btnExportExcel'><img style='float: left; margin: 4px;' src='../Includes/Images/iconPDF.gif' alt="" height="16" width="16" /><div style='float: left; margin: 4px;'>Export</div></div> </td><td><div id='divUpload'></div> </td><td> <input id="selectedRow" type="text" readonly="readonly" style="border-style: none; border-color: #FFFFFF; width: 0px;" /></td> </tr></table><div id="jqxgrid"></div></div> <!-- divControl --></div> <!-- divOuter --><div id="divDialog"><div id="divErrorMsg"></div></div><div id="dialog-form" title="Add Record"> <p class="validateTips">All form fields are required.</p> <fieldset> <table cellpadding="2" cellspacing="0"> <tr> <td>DOC NBR</td> <td> <table cellpadding="0" cellspacing="0" style="width: 100%"> <tr> <td style="text-align: center; background-color: #E9E9E9">DODAAC</td> <td style="text-align: center; background-color: #E9E9E9">Julian Date</td> <td style="text-align: center; background-color: #E9E9E9">Sequence</td> </tr> <tr> <td style="text-align: center"><input type="text" name="DODAAC" id="DODAAC" class="text ui-widget-content ui-corner-all" maxlength="6" style="width: 75px" /></td> <td style="text-align: center"> <input type="text" name="JULIAN" id="JULIAN" class="text ui-widget-content ui-corner-all" maxlength="4" style="width: 75px" /></td> <td style="text-align: center"><input type="text" name="SEQUENCE" id="SEQUENCE" class="text ui-widget-content ui-corner-all" maxlength="4" style="width: 75px" /></td> </tr> </table> </td> </tr> <tr> <td>Received From:</td> <td> <select id="FROM_USER" name="FROM_USER"></select> </td> </tr> <tr> <td>Date Received:</td> <td> <input id="DATE_RECEIVED" class="dtpicker" name="DATE_RECEIVED" style="width: 100px" type="text" maxlength="10" /> </td> </tr> <tr> <td>Status:</td> <td> <select id="STATUS"> <option value="PENDING">PENDING</option> <option value="APPROVED">APPROVED</option> <option value="DISAPPROVED">DISAPPROVED</option> <option value="HELD">HELD</option> </select> </td> </tr> <tr> <td>Card Holder:</td> <td><select id="CARD_HOLDER"></select></td> </tr> <tr> <td>Purchase Description:</td> <td><textarea id="PURCHASE_DESC" cols="1" rows="5" style="width: 250px"></textarea></td> </tr> <tr> <td>Purchase Amount:</td> <td><input type="text" name="PURCHASE_AMT" id="PURCHASE_AMT" class="text ui-widget-content ui-corner-all" maxlength="9"/></td> </tr> <tr> <td>Vendor Name:</td> <td> <input type="text" name="VENDOR_NAME" id="VENDOR_NAME" class="text ui-widget-content ui-corner-all" maxlength="254" style="width: 250px"/></td> </tr> <tr> <td>Req Delivery Date:</td> <td> <input type="text" name="REQ_DELIVERY_DATE" id="REQ_DELIVERY_DATE" class="dtpicker" maxlength="10" style="width: 100px"/></td> </tr> <tr> <td>SAG:</td> <td><select id="SAG"> <option value="111">111</option> <option value="112">112</option> <option value="113">113</option> <option value="114">114</option> <option value="115">115</option> <option value="116">116</option> <option value="OTHER">OTHER</option> </select></td> </tr> </table> </fieldset></div></body></html>
Data:
<NewDataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Table"> <xs:complexType> <xs:sequence> <xs:element name="DOC_ID" type="xs:string" minOccurs="0" /> <xs:element name="DOC_NBR" type="xs:string" minOccurs="0" /> <xs:element name="FROM_USER" type="xs:string" minOccurs="0" /> <xs:element name="STATUS" type="xs:string" minOccurs="0" /> <xs:element name="DATE_RECEIVED" type="xs:string" minOccurs="0" /> <xs:element name="DATE_FUNDED" type="xs:string" minOccurs="0" /> <xs:element name="MERCH_RCVD_DATE" type="xs:string" minOccurs="0" /> <xs:element name="REASON_DELAYED" type="xs:string" minOccurs="0" /> <xs:element name="CARD_HOLDER" type="xs:string" minOccurs="0" /> <xs:element name="PURCHASE_DESC" type="xs:string" minOccurs="0" /> <xs:element name="PURCHASE_AMT" type="xs:string" minOccurs="0" /> <xs:element name="REQ_DELIVERY_DATE" type="xs:string" minOccurs="0" /> <xs:element name="VENDOR_NAME" type="xs:string" minOccurs="0" /> <xs:element name="SAG" type="xs:string" minOccurs="0" /> <xs:element name="FILES" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <Table> <DOC_ID>395331120100940</DOC_ID> <DOC_NBR>WYDEE0-0300-0301</DOC_NBR> <FROM_USER>renee.waller</FROM_USER> <STATUS>APPROVED</STATUS> <DATE_RECEIVED>11/01/2010</DATE_RECEIVED> <DATE_FUNDED>10/04/2012</DATE_FUNDED> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>patricia.turner1</CARD_HOLDER> <PURCHASE_DESC>UNIT CRESTS</PURCHASE_DESC> <PURCHASE_AMT>569</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>SUPPLY ROOM</VENDOR_NAME> <SAG>116</SAG> <FILES>https://ngilc2spi740b22.ng.ds.army.mil/tabs/uspfo/715_1/395331120100940/ServicemembersRightandBenefits.pdf</FILES> </Table> <Table> <DOC_ID>3953181120101347</DOC_ID> <DOC_NBR>WY7490-0313-0301</DOC_NBR> <FROM_USER>fray.f.figueroa</FROM_USER> <STATUS>APPROVED</STATUS> <DATE_RECEIVED>11/10/2010</DATE_RECEIVED> <DATE_FUNDED>11/22/2010</DATE_FUNDED> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>michele.l.purcell</CARD_HOLDER> <PURCHASE_DESC>COINS</PURCHASE_DESC> <PURCHASE_AMT>420</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>MTM</VENDOR_NAME> <SAG>NULL</SAG> <FILES /> </Table> <Table> <DOC_ID>3953181120101355</DOC_ID> <DOC_NBR>WY7490-0306-0301</DOC_NBR> <FROM_USER>pearlie.aaron</FROM_USER> <STATUS>PENDING</STATUS> <DATE_RECEIVED>11/16/2010</DATE_RECEIVED> <DATE_FUNDED>10/04/2012</DATE_FUNDED> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>patricia.turner1</CARD_HOLDER> <PURCHASE_DESC>MAGNET CALENDAR AND MISC. </PURCHASE_DESC> <PURCHASE_AMT>2624.68</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>GSA MAGNATAG VISIBLE SYSTEMS</VENDOR_NAME> <SAG>NULL</SAG> <FILES /> </Table> <Table> <DOC_ID>395328120111057</DOC_ID> <DOC_NBR>WPBGC0-1028-0301</DOC_NBR> <FROM_USER>keith.rogers1</FROM_USER> <STATUS>PENDING</STATUS> <DATE_RECEIVED>01/28/2011</DATE_RECEIVED> <DATE_FUNDED>10/04/2012</DATE_FUNDED> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>unassigned</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>1276.8</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>HAMPTON INN OF CARBONDALE</VENDOR_NAME> <SAG /> <FILES /> </Table> <Table> <DOC_ID>395329112011145633</DOC_ID> <DOC_NBR>W9AH3F-1333-0301</DOC_NBR> <FROM_USER>phil.tuttle</FROM_USER> <STATUS>PENDING</STATUS> <DATE_RECEIVED>11/29/2011</DATE_RECEIVED> <DATE_FUNDED /> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>UNASSIGNED</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>1368</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME> <SAG /> <FILES /> </Table> <Table> <DOC_ID>395314220111423</DOC_ID> <DOC_NBR>W9AH3F-1035-0301</DOC_NBR> <FROM_USER>gary.cunningham5</FROM_USER> <STATUS>APPROVED</STATUS> <DATE_RECEIVED>02/11/2011</DATE_RECEIVED> <DATE_FUNDED>02/14/2011</DATE_FUNDED> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>rhonda.gilbert3</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>957.6</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME> <SAG>Other</SAG> <FILES /> </Table> <Table> <DOC_ID>395328120110732</DOC_ID> <DOC_NBR>W9AH3F-1014-0301</DOC_NBR> <FROM_USER>gary.cunningham5</FROM_USER> <STATUS>APPROVED</STATUS> <DATE_RECEIVED>01/25/2011</DATE_RECEIVED> <DATE_FUNDED>01/26/2011</DATE_FUNDED> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>rhonda.gilbert3</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>1026</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME> <SAG>Other</SAG> <FILES /> </Table> <Table> <DOC_ID>395361220101539</DOC_ID> <DOC_NBR>W9AH3F-0340-0301</DOC_NBR> <FROM_USER>gary.cunningham5</FROM_USER> <STATUS>PENDING</STATUS> <DATE_RECEIVED>12/06/2010</DATE_RECEIVED> <DATE_FUNDED /> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>UNASSIGNED</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>1368</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME> <SAG /> <FILES /> </Table> <Table> <DOC_ID>3953241120101047</DOC_ID> <DOC_NBR>W9AH3F-0328-0301</DOC_NBR> <FROM_USER>gary.cunningham5</FROM_USER> <STATUS>PENDING</STATUS> <DATE_RECEIVED>11/24/2010</DATE_RECEIVED> <DATE_FUNDED /> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>UNASSIGNED</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>1231.2</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME> <SAG /> <FILES /> </Table> <Table> <DOC_ID>395391120100738</DOC_ID> <DOC_NBR>W9AH3F-0312-0301</DOC_NBR> <FROM_USER>gary.cunningham5</FROM_USER> <STATUS>PENDING</STATUS> <DATE_RECEIVED>11/09/2010</DATE_RECEIVED> <DATE_FUNDED /> <MERCH_RCVD_DATE /> <REASON_DELAYED /> <CARD_HOLDER>UNASSIGNED</CARD_HOLDER> <PURCHASE_DESC>IDT LODGING</PURCHASE_DESC> <PURCHASE_AMT>820.8</PURCHASE_AMT> <REQ_DELIVERY_DATE /> <VENDOR_NAME>FAIRFIELD INN</VENDOR_NAME> <SAG /> <FILES /> </Table></NewDataSet>
Good deal, thanks!
Robert
September 26, 2012 at 3:22 pm in reply to: Uncaught TypeError: Cannot call method ‘unbind’ of undefined Uncaught TypeError: Cannot call method ‘unbind’ of undefined #8534Ok, I got this to work. I had to set:
width: 650,
columnresize: trueAt that point I saw that the data was there but the columns weren’t big enough to show the data.
Robert
September 26, 2012 at 2:18 pm in reply to: Uncaught TypeError: Cannot call method ‘unbind’ of undefined Uncaught TypeError: Cannot call method ‘unbind’ of undefined #8527We’re defining “source” as “xml” but in the var dataAdapter line we’re saying its contentType is ‘application/json; charset=utf=8’. Is that an issue?
Robert
September 26, 2012 at 2:13 pm in reply to: Uncaught TypeError: Cannot call method ‘unbind’ of undefined Uncaught TypeError: Cannot call method ‘unbind’ of undefined #8526Here is what the writer in data.Tables[0].WriteXml(writer, XmlWriteMode.WriteSchema, false); looks like:
{<NewDataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Table" msprop:BaseTable.0="PERS_PERSON_TBL"> <xs:complexType> <xs:sequence> <xs:element name="NAME_IND" msprop:BaseColumn="NAME_IND" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="ST_ADDR" msprop:BaseColumn="ST_ADDR" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="ADDR_CITY" msprop:BaseColumn="ADDR_CITY" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="STATES_US" msprop:BaseColumn="STATES_US" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="ZIP" msprop:BaseColumn="ZIP" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <Table> <NAME_IND>SMITH TODD ANTHONY</NAME_IND> <ST_ADDR>4680 TIMBERVIEW</ST_ADDR> <ADDR_CITY>AUBURN</ADDR_CITY> <STATES_US>IL</STATES_US> <ZIP>62615</ZIP> </Table> <Table> <NAME_IND>SMITH MICHAEL BRUCE</NAME_IND> <ST_ADDR>922 N 9TH ST</ST_ADDR> <ADDR_CITY>DEKALB</ADDR_CITY> <STATES_US>IL</STATES_US> <ZIP>60115</ZIP> </Table></NewDataSet>}September 26, 2012 at 2:00 pm in reply to: Uncaught TypeError: Cannot call method ‘unbind’ of undefined Uncaught TypeError: Cannot call method ‘unbind’ of undefined #8525Ok, one issue at a time I guess. The problem was that I was using an old version of jqxcore.js. I put all the .js files into a new folder and pulled them directly from that folder. Now I don’t get the error, but I also still don’t get data. I have a grid with no data that shows 484 records at the bottom.
Robert
September 26, 2012 at 1:41 pm in reply to: Uncaught TypeError: Cannot call method ‘unbind’ of undefined Uncaught TypeError: Cannot call method ‘unbind’ of undefined #8521Ok, I went line-by-line on the javascript includes. The only thing I changed (because I had to) was how I’m getting the data. I have a function that I use that returns me a dataset for an SQL that I pass in. I’m locally debugging and getting results for both the “GetCustomers” and the “GetTotalRowsCount” and now I get a grid with rows that are empty and still the “unbind” error.
Does it matter if I use the trial commercial version or the free version? Also, I’m not using a master page, but that shouldn’t make a difference….Here is my code:
test.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="test.aspx.cs" Inherits="DBIW.Tabs.test" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <link href="../Includes/CSS/jqx.base.css" rel="stylesheet" type="text/css" /> <link href="../Includes/CSS/jqx.classic.css" rel="stylesheet" type="text/css" /> <script src="../Includes/JS/jquery-1.7.1.min.js" type="text/javascript"></script> <script src="../Includes/JS/jqxcore.js" type="text/javascript"></script> <script type="text/javascript" src="../Includes/JS/jqxbuttons.js"></script> <script src="../Includes/JS/jqxdata.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.pager.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxlistbox.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxdropdownlist.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxgrid.selection.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxmenu.js" type="text/javascript"></script> <script src="../Includes/jqxWidgets/jqxscrollbar.js" type="text/javascript"></script><script type="text/javascript">$(document).ready(function () { //Getting the source data with ajax GET request source = { datatype: "xml", datafields: [ { name: 'name_ind' }, { name: 'st_addr' }, { name: 'addr_city' }, { name: 'states_us' }, { name: 'zip' } ], async: false, formatdata: function (data) { return { pagenum: data.pagenum, pagesize: data.pagesize } }, record: 'Table', url: 'test.aspx/GetCustomers' }; $.ajax({ url: 'test.aspx/GetTotalRowsCount', contentType: 'application/json; charset=utf-8', async: false, success: function (data) { source.totalrecords = data.d; } }); var dataAdapter = new $.jqx.dataAdapter(source, { contentType: 'application/json; charset=utf-8' } ); $("#jqxgrid").jqxGrid({ source: dataAdapter, theme: 'classic', pageable: true, autoheight: true, virtualmode: true, rendergridrows: function () { return dataAdapter.records; }, columns: [ { text: 'name_ind', dataField: 'name_ind', width: 25 }, { text: 'st_addr', dataField: 'st_addr', width: 25 }, { text: 'addr_city', dataField: 'addr_city', width: 25 }, { text: 'states_us', dataField: 'states_us', width: 25 }, { text: 'zip', dataField: 'zip', width: 25 } ] }); }); </script></head><body><div id="jqxgrid"></div></body></html>
test.aspx.cs
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.Services;using System.Web.Script.Services;using System.Data;using System.Data.SqlClient;using System.Configuration;using System.Web.Script.Serialization;namespace DBIW.Tabs{ public partial class test : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } [WebMethod] [ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Xml)] public static string GetCustomers(int pagenum, int pagesize) { string strSQL = "select name_ind, st_addr, addr_city, states_us, zip " + "from pers_person_tbl where name_ind like '%SMITH%'"; DataSet data = DBFunctions.parseSQLDS(strSQL, "PRIV", "DBIWWS"); // return the Customers table as XML. System.IO.StringWriter writer = new System.IO.StringWriter(); data.Tables[0].WriteXml(writer, XmlWriteMode.WriteSchema, false); return writer.ToString(); } private static DataSet GetData(SqlCommand cmd) { string strConnString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataSet ds = new DataSet()) { sda.Fill(ds); return ds; } } } } [WebMethod] [ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)] public static int GetTotalRowsCount() { string strSQL = "select count(*) as CNT from pers_person_tbl where name_ind like '%SMITH%'"; int count = int.Parse(DBFunctions.parseSQLString(strSQL, "PRIV", "DBIWWS")); return count; } private static int GetRowsCount(SqlCommand cmd) { string strConnString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(strConnString); cmd.Connection = con; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); int rows = (int)reader[0]; con.Close(); return rows; } }}Robert
September 25, 2012 at 4:42 pm in reply to: ‘dataAdapter’: object is null or undefined ‘dataAdapter’: object is null or undefined #8446Right, and I got that problem fixed. I updated the question, but don’t see that on the post above. Anyway, now I get no errors, but also don’t see a grid.
Robert
-
AuthorPosts
Viewing 11 posts - 1 through 11 (of 11 total)