Methods

How can I submit all the grid to the server at once. Any help would be greatly appreciated.

Hi everyone. Any idea how can i pass parameters to the url invoked by the grid ?

How can I submit all the grid to the server at once. Any help would be greatly appreciated ?

example: ( jQuery ) onSubmit Click function : $(”#buttonId”).click(function(){

 //get total rows in you grid
 var numberOfRecords = $("#gridId").getGridParam("records");
 for(i=1;i<=numberOfRecords;i++)
{
	
	var rowId = $("#gridId").getRowData(i);
	var name = rowId['name'];
              
              //put all rows for your grid
              .
              .
	$('<input type="hidden" />').attr('name', i+'_name').attr('value',ime).appendTo('#hiddenDivId');
}

});

Now, you can read hidden value, on your form submit.

  You can post all datas like this way:

  var rows= jQuery("#jqgrid_id").jqGrid('getRowData');
  var paras=new Array();
  for(var i=0;i<rows.length;i++){
      var row=rows[i];
      paras.push($.param(row));
  }
  $.ajax({
      type: "POST",
      url: "/someurl.do",
      data: paras.join('and'),
      success: function(msg){
          alert(msg);
      }
  });

Hi,

I was wondering if I can put some search option when I use trigger('reloadGrid') method? Like reload only rows where some field is matched to some condition.

Thanks before,

Hi, you can setGridParam url , and then reload grid. With new url, you can get data you want to show.

$(”#grid”).setGridParam({url:'url'}); $(”#grid”).trigger(“reloadGrid”);

Hi,

Is there a way for JavaScript to know which page the grid currently thinks it's on? I would like my page to do some things if the grid is on page 1, but not if it is on another page.

Thank you,

Hi, I've a JqGrid with Json Data mapped in, I want to know if there is a method to change data on the fly… I call an action method via Ajax that return Json Data (the same mapped in jqGrid), so now i want to change the data via jqgrid methods like

$(”#grid”).setGridParam('data',mydata);

Thanks…

SOLVED

I've to use addJSONData!

Sorry… the documentation had to be always read entirely!!

hi, good day. is there a way that i can get the location or path of the url that reads my data from the server? i want to display it in my html. i have this code:..

  $("#btnQuery").click( function() {
     var params = {
        "ID": $("#eSessionID3").val(),
        "Type": "data"
     }
     var url = 'some.php?path=' + encodeURI('some/data') + '&json=' + encodeURI(JSON.stringify(params));

     $('#tblData').setGridParam({
  url:url, 
  datatype: primeSettings.ajaxDataType,  
     });
     $('#tblData').trigger('reloadGrid');   

     $('#firstur').append('the url: ' + url+'<br>');
     $('#secur').append('response: ' + url+'<br>');
  });

my some.php code is something like this:

  <?php 
echo(file_get_contents("http://localhost/" . $_GET["path"] . "?json=" . $_GET["json"]));
  ?>

questions? 1. i want to display/alert the location or path of the url that reads/loads my data from the server?

in firebug console, it's something that looks like this:

http://localhost/..../some.php?path=some/data/&json=%7B%22ID%22:%22PK0hyW%22,%22dataType%22:%22data%22%7D& json={%22ID%22:%22PK0hyW%22,%22dataType%22:%22data%22,%22recordLimit%22:5,%22recordOffset%22:0,%22rowDataAsObjects%22:false,%22queryRowCount%22:true,%22sort_fields%22:%22main_account_group_desc%22}

2. i want to get and display/alert the response body of the url?

is ther anybody here who knows the answer. thank you

An error on the page. in the method column incorect addXMLData corect addXmlData

There appears to be an undocumented parameter for the sortGrid method. It can also take a sort order as the last parameter, which can be 'asc' or 'desc', as the grid tends to use throughout. It seems to default to 'asc'.

Hi,

  I have a select element in my add record dialog. the values are saved successfully to the grid. now I need to get the values to save to the database. But when I try to get the values I get the display text of the selected value.

here's my colmodel:

name:'mpt_ReasonUID',index:'mpt_ReasonUID',width:110, editable: true,edittype:“select”,editoptions:{value:“FE:FedEx;TN:TNT”}}

i need to get the values like 'FE', 'TN'. but I get 'FedEx', 'TNT' by using jQuery(”#list_outcomeReasons”).jqGrid('getLocalRow', rowIDs[i]);

Hello It is possible to obtain the number of rows that fit into the current size of the parent before loading the data from the server?

Hi, in description method hideCol ”… NB: The width of the grid is not changed.”

in code (function hideCol()) ”… if(fndh===true) {

$($t).jqGrid("setGridWidth",$t.p.shrinkToFit === true ? $t.p.tblwidth : $t.p.width );

} …”

in options shrinkToFit default is true

So, NB: The width of the grid will be changed, and it depends on shrinkToFit option.

For those of you still stuck with the inability to save data locally instead of on a server with jqGrid, you can use the data proxy.

When instantiating the jqGrid:

$(”#myTable”).jqGrid({ … dataProxy: dataProxyFn, …});

then when opening your popup:

$(”#myTable”).jqGrid('editGridRow', “new”, { … useDataProxy: true …});

The argument url or editurl are not needed anymore.

Then this is my function dataProxyFn() which can be better but works currently:

function dataProxyFn(t) {

var lastId = 1;
if ($(this).getDataIDs().length > 0) {
	lastId = parseInt($(this).getDataIDs().length) + 1;
}
if (t.data.id == "_empty") {
	$(this).jqGrid("addRowData", lastId, t.data, "last");
} else {
	if (t.data.oper == "del") {
		$(this).jqGrid("delRowData", t.data.id);			
	} else {
		$(this).jqGrid("setRowData", t.data.id, t.data);
	}
}

}

I want to disable enter key after editing any cell. please help me with example code.

I'm try to use hideCol to hide some column.But when I use formedit and the column is first of the row,all of the row's columns is hided. How can I to show column in form.my code:

	colModel:[{name:"id",index:"id",width:100,editable:false},
		{name:"name",index:"name",width:100,editable:true,formoptions:{colpos:1,rowpos:1}},
		{name:"hireDate",index:"hireDate",editable:true,formoptions:{colpos:2,rowpos:1}},
		{name:"birthday",index:"birthday",editable:true,edittype:"text",editoptions:{
		 dataInit:function(elem){
		initdate(elem);//initdatepicker
				} 	    	
			},formoptions:{colpos:3,rowpos:1}},
		{name:"department.id",index:"department.id",editable:true,formoptions:{colpos:1,rowpos:2}},
		{name:"mobilePhone",index:"mobilePhone",editable:true,formoptions:{colpos:2,rowpos:2}}
		]

… jgrid.jqGrid(“hideCol”,[“department.id”,”hireDate”]).trigger(“reloadGrid”);

… if I use this to hide department.id in grid.the row 2 all hided in form.

In v3.6 of jqGrid, a new API was introduced to avoid name-space conflicts. Are there any performance or other advantages to using the new API? Additionally, it states “You are free to use both conventions.” Will the old API be deprecated in a future release?

OLD API <script> … jQuery(”#grid_id”).setGridParam({…}).hideCol(“somecol”).trigger(“reloadGrid”); … </script>

NEW API <script> … jQuery(”#grid_id”).jqGrid('method', parameter1,…parameterN ); … </script>

Thanks.

addRowData currently only knows the position first, last, before and after. It would be nice to have a position sortorder which inserts the new data with respect to the current sort order. Also it would be helpfull if setCell and setRowData optionally would resort the table if necessary.