jqgrid

jqGrid viewGridRow modal dialog labels

Hi, i am trying to manually override the value for caption and bClose for the modal "View Record" Dialog but am unable to do so? I am calling it with jQuery("#list2″).jqGrid('navGrid','#pager2', { view:true, deltext:dt, deltitle:delt, viewtext:vt, viewtitle:vddt, }, //options { ...

Custom "Add Data" - how to post data to PHP server?

I have the following PHP script: $OperMode = $_POST['oper']; switch($OperMode) { /* [...] */ case 'ManAdd': // get data $Firma = $_POST['Name']; $Adresse = $_POST['Address']; $PLZ = $_POST['PLZ']; $Ort = $_POST['Ort']; $TelNr = $_POST['TelNr']; /* [...]...

jqGrid 'selarrrow' returning row numbers instead of row IDs

I can see from the jqGrid JSON data being posted to the browser that the row ID (denoted by "i" in the JSON row data) is coming through correctly, but when I make a selection and check the $('#list').getGridParam('selarrrow') it is showing the selected row numbers as opposed to their IDs. Does anyone have experience with this? Thanks U...

Expanding jqgrid subgrid

I have a jqgrid that has a subgrid. How can I expand the subgrid without having to click on the plus sign? I came across $("#jqgrid_id").expandSubGridRow(rowId); but am unsure which rowId to use to expand the subgrid. Thanks. ...

Subgrid Caching or Stopping Subgrid data from being removed (jqGrid)

Is there any way to force jqGrid not to remove the subgrid data when its row is toggled? My current process for loading the datagrid is as follows: 1) Setup main grid, setting subgrid up programatically with an ID that I can use later 2) Load data into main grid locally via json 3) Add data to subgrid locally via json Due to the f...

jqgrid reload grid partially working

Hi, I have a client side managed jqgrid that I reload when some external event are fired. Everything is fine when I reload the grid with more data but when I reload it with less data, the amount of rows is incorrect. For instance, when the is currently 100 rows in the grid and I reload it with 200, then the nav bar shows 200 records. I...

jqGrid does not display search button(icon)

hello all, i have this following code for displaying data , it works fine , but it does not show search icon, what things i lost in my code? jQuery("#list2").jqGrid({ url:'post2.php', datatype:"json", colNames:['id','lastname','fname'], colModel:[ {name:'id',index:'id',hidden:true, width:90}, {name:'fname',index:'fname', width...

JQGrid loading message displayed after the grid container is hidden

I have a jqgrid whose html is displayed in the following way. I build this myTable as a jqgrid using some custom javascript. This was working fine for a long time. I made a change to collapse(in simple terms to hide) the div "tableSectionDiv" when the grid does not have any records. In order to do this, on the grid complete eve...

JqGrid pager problem - Total pages and records does not display correctly

Issue: My jqGrid pager shows Page 1 of NaN instead of the correct number of pages. Fiddler shows that I am getting the correct json from my WCF call: {"total":1,"page":1,"records":2,"rows":[{JDEVendorNumber":99999999, "VendorName":"Super Vendor","BillID":"99999999wwerer ", "CommunityName":"Post Abbey ...

how do I submit jqgrid values as formfields?

I am trying to use jqGrid within a form where the user fills out traditional formfields such as username, phone, etc. The form contains a jqGrid for line items where the user can add/edit/del the rows, and when done, submit the entire form. I have the grid working as I want it to appear, I just can't get the contents of the grid submitte...

Using JQgrid and sortableRows. Update table row order

Using: http://stackoverflow.com/questions/2382879/using-sortablerows-and-know-when-rows-have-been-moved I have been able to call an alert after the modification of my row order. How would I send this data to PHP/ call the editurl passing this data, similar to when adding or editing rows the editurl receives a $_POST['oper'] variable? ...

How to handle a JqGrid event programmatically?

I'm using the ASP.NET wrapper for JqGrid. I'd like to programmatically wire up handlers for some of the grid's events (e.g. gridComplete, resizeStop). All the examples I've seen have you wire up the event as part of the options when creating the grid object - for example: $("#gridid").jqGrid({ ... onSelectRow: function(){ ... },...

jqGrid: sending edit data

I'm trying to use form editing on jqgrid. When the data is sent to the webserver, I want an extra field sent in the get/post data. It sounds like editData is what I want to use. How do I hook this into the navbar? <script type="text/javascript"> $(document).ready(function(){ if (jQuery('#ReferenceGrid').attr('role') == '...

What is the best way to reorder 1000 rows at one shot

I have 1000 records in a table which holds position field starting from 1 to 1000. Now I want to implement the reorder functionality for 1000 records. Suppose, If I move the 1000th record to 1st position then the 1st record should move to 2nd positon, 2nd record move to 3rd position and 999th record move to 1000th position. NOTE: I am...

ASP.NET sorting for jQuery Grid

hi, i want to do sorting for jQGrid in ASP.NET. For that i have pass the sidx and sord for column name and sorting order.but it was giving error "Incorrect syntax near '0'. Statement(s) could not be prepared." i wrote query for this select Image,CategoryName,Status,CategoryId from Category Order by {0} {1} ...

How do you export a JQGrid configuration to XML?

I have a number of users that need to save off very specific table configurations, which are to be loaded each h time they visit my application. How would I go about exporting my JQGrid column configuration to XML so that it can be loaded later. ...

Using jqGrid with HTML5 local database

I would like to use jqGrid for a pretty large HTML5/SQLite application. All of the data will be local and I'll never be calling a server. I've build a pretty simple bridge class that sort of hijacks the normal server-client communication by setting the url to '#' capturing the changed data with afterSubmit but it is very, very hacky. Is ...

JavaScript slowness outside events

How do I diagnose web page performance problems if none of my JavaScript events seem to be the cause? I have a web application using jqGrid. Clicking on the grid causes a 2-3 second freeze before anything happens (including any click events being hit). Clicking anywhere else on the page is fine (instant response). Removing rows red...

How can jqGrid be used when the number of columns is dynamic (i.e. determined by the data set)?

I have a generalized php routine which generates xml results from different mySQL queries. The actual structure of the xml will vary depending on which query is used. (Actually, the number of columns will vary.) I've just started to explore using jqGrid, and I'd like to write a generalized display routine where I do an ajax call to my...

jqGrid - subgrid doesn't work when load once is true

I have a problem to use subgrid. I want to use the nice feature of loadoce(local search etc.). And I also want to use subgrid. But it doen't work to put them together. I don't know if it's a bug or I miss some thing. If I set loadonce:false, the subgrid works. I tried both 3.7.1 and 3.7.2 Or should I only use one at a time? Many thank...