Somebody knows a way to export the data from a jqgrid to excel? I want to do a report using this jqgrid that i think is awsome. But i need to save or print this report somehow, because is information to be keeped. Somebody knows any way?? ...
Hello all, I am trying to get this awesome JQuery plugin working with SQL Server. I have setup PDO as I use it elsewhere (with MS Access) - I think I have it setup with sql server (2008) now. Here is how I connect: define('DB_DSN',"odbc:Driver={SQL Server};Server=MyInstance;Database=table1;"); define('DB_USER', ''); define('DB_PASSWOR...
Hallo, I have a problem. I'am trying to get some data from my database. But with a limit. So i use the selectLimit command. But when i load the grid my firebug gives the following error: "parsererror"?e:null},parse:function(d...d(a.fn.jqGrid,d);this.no_legacy_api|| When I go to the selectLimit in the jqgrid.php and print out what the ...
Hi , I am using jqGrid 3.6.4 and a jquery 1.4.2 . in my sample i am getting following json data format & i want to map these json data into rows of a jqgrid { "page": "1", "total": 1, "records": "6", "rows": [ { "head": { "student_name": "Mr S. Jack ", "year": 2007 }, "sub": [ ...
Hey guys, Did you guys know how to prevent the open of a Form when I click on a add button? Maybe using beforeShowForm? function(formid) { if(jQuery('#gridap').getGridParam('selrow')) { idgridap=jQuery('#gridap').getGridParam('selrow'); jQuery('#FK_numerocontrato_ap',formid).val(idgridap).attr('readonly','rea...
Hi, I'm trying to get work this code: $("#list").jqGrid({ url: 'employers.php', datatype: 'json', mtype: 'POST', postData: {c : "", n: "", a: "", d: "", t: "", e: "", f: "", g: $('#selectSalary').value(), p: "", call: "report"}, colNames:...
Hello, In a php file, i use the jqGridRender Class to build and manage a grid. To add a new item in my SQL table, i use (among others things) a php variable named $start. This variable is known, it belong to the PRIMARY KEY of this new item i want to add. Its type in the table is DATETIME and its value is "2010-06-16 06:00:00" How t...
I am trying to implement jqgrid v3.7 in my webapplication created using cakephp v1.3. My controller code is as follows function admin_index() { // get how many rows we want to have into the grid - rowNum parameter in the grid $limit = $this->params['url']['rows']; // get index row - i.e. user click to sort. At first time s...
hi, how to work on add row, edit, del the row in jqgrid? how to invoke editurl?? my code is below... jqgrid.php page. var $mygrid= jQuery("#list").jqGrid({ url:'example.php', datatype: 'xml', mtype: 'GET', ...
How to work this code without pdo connection.? want to use normal db connection. if i use normal db connection, jqGridRender class not found. plz give me the soln.. enter code here <? php require_once 'jq-config.php'; // include the jqGrid Class require_once "php/jqGrid.php"; ...
Hello, I'm building a grid in a php file. Some fields are displayed as images. To do so, i use something like that (here is a example for one field): ... $grid->setColProperty("sample_global", array("label"=>"Sample", editable"=>true,"edittype"=>"select","editoptions"=>array("value"=>"0:Container;1:Automatic sampler;2:Transporting syst...
I have 2 Grids on my HTML page. When I click a row in one grid, it needs to load data into the other based on the selected row. Therefore I need to send the rowId as an extra parameter for the second grid.. Can't figure out how.. (I'd rather not like to use the subgrid functionality) ...
Hi all, In JQGRID top Toolbar, want to add the check boxes. these checkboxes are display from static array.. its used for search.. help me.. i did, toolbar: [true,"top"] thanks, vijay. ...
I want to create Jqgrid add row button as iframe..when i click the add button it will open as iframe.. how to make it? plz give me an idea. ...
1) I am using the jqgrid plugin to show results from different selections a user can make on sliders and such. The jqgrid loads via a php command: $grid->SelectCommand = 'MySQL SELECT statement here'; But I want to change this, and reload the data at runtime (via jquery) when the user makes a change. (Also if possible I would like t...
Hi. I need to pre-load some values from a php script, I'm using a $.post call (jquery) as follows: ... var grade, section,from,until,user; function loadData(){ $.post('procstring.php', {data: window.location.hash}, function(result){ grade = result.grade; ...
I'm using the jqgrid plugin for jquery and jquery ui and I would like to change the AJAX url on a dom event. this is the instatiation of the jqgrid table: jQuery("#list").jqGrid({ url:'AJAX/JSON/json_member_mail.aspx', datatype: 'json', mtype: 'GET', colNames:['','Title', 'from','message',''], colModel :[ {name:...
my jqgrid doesnt seem to reload.. can anyone help me with this?.. $(function(){ $last_name = $("#search_last_name").val(); $first_name = $("#search_first_name").val(); }); $("#search").click(function(){ jQuery("#list2").jqGrid('setGridParam',{url:"http://localhost/bcb/index.php/bcb_c/grid"}); jQuery("#list2").trigger...
Hi I have created a user message page with this plugin. The grid will show the user inbox and the user outbox(sent) messages. here's a little code: jQuery(document).ready(function() { //...some stuff currentURL = function() { return 'json_member_mail.php?task='+ currentBox; //where cur...
Need help in changing the caption of the subgrid of jQgrid also can I designed it based on my want's? When it collapsed it will show a certain layout out? ex: id: 200-2010 thanks! ...