$(function () { var data = [ { DEMAS_DCONFIRM: "", DEMAS_DEMAS_CNAMESHORT: "Employee B1732", DEMAS_DEMAS_CNOEESHORT: "B1732", DEMAS_DHIRE: "2002-05-01 00:00:00", DSERVICE_DSERVICE_CDEPARTMEN_L: "OPR" }, { DEMAS_DCONFIRM: "2004-07-11 00:00:00", DEMAS_DEMAS_CNAMESHORT: "Employee B1732", DEMAS_DEMAS_CNOEESHORT: "B1732", DEMAS_DHIRE: "2002-05-01 00:00:00", DSERVICE_DSERVICE_CDEPARTMEN_L: "OPR" } ]; var grid = $("div#grid_showhide_columns"); grid.pqGrid({ dataModel: { data: data }, "colModel":[ {"width":95,"dataIndx":"DSERVICE_DSERVICE_CDEPARTMEN_L","hidden":true, title:"Dept"}, {"width":95,"dataIndx":"DEMAS_DEMAS_CNOEESHORT","hidden":false, title:"Emp. No"}, {"width":374,"dataIndx":"DEMAS_DEMAS_CNAMESHORT","hidden":false, title:"Name"}, {"width":125,"dataIndx":"DEMAS_DHIRE","hidden":false, title:"Hire Date", dataType: "date", format: "dd/M/yy"}, {"width":125,"dataIndx":"DEMAS_DCONFIRM","hidden":false, title:"Confirm Date", dataType: "date", format: "dd/M/yy"} ], "height":600, "width":"100%", "groupModel":{"dataIndx":["DSERVICE_DSERVICE_CDEPARTMEN_L"],"dir":[],"collapsed":[false],"grandSummary":false}, "pageModel":{"rPP":100,"curPage":1}, "sortModel":{"sorter":[{"dataIndx":"DSERVICE_DSERVICE_CDEPARTMEN_L","dir":"up"}]}, "freezeRows":0, "freezeCols":0 }); });