We have a lot of changes inside Trirand. You may need to read this post

The forum is moved to another place.. All the existing users and forum posts are moved successfully in our new side guriddo.net

In the future, please post your questions and problems in the new place.

The existing forum will stay and will  be in read-only mode.

 

Kind Regards

Tony

It worked for me on iPad (iOs 7 & 8) - as well as on my old Samsung S3 (therefore Android), I just needed to get the right CSS Style and change some things in the CSS so the Keyboard pops up and so on.

name: 'SUPER_CLIENT',
index: 'SUPER_CLIENT',
align: 'left',
width: 150,
stype: 'text',
sortable: true,
editable: true,
editrules: { required: true },
edittype: 'select',
editoptions: {
aysnc: false,

dataUrl: '../../../Forms/Admin/MasterModule/AdminCommonHandler.ashx?Page=ProcessMaster',
buildSelect: function (data) {
var json = $.parseJSON(data);
var s = '<select>';
s += '<option value="">--Select--</option>';
$($.parseJSON(data)).map(function () {

s += '<option value="' + this.COMPANY_NAME + '">' + this.COMPANY_NAME + '</option>';
});

var sel_id = $('#jQGridDemo').jqGrid('getGridParam', 'selrow');

var value = $('#jQGridDemo').jqGrid('getCell', sel_id, 'USER_ID');
//alert(value);
$('#COMPANY_NAME').val(value);

return s + "</select>";

},dataInit: function (elem) { $(elem).width(141); }
},
formoptions: { elmsuffix: '' }
},

 

Thanks.

 

Thanks for remind me. This is true and it will be fixed for the next release.

 

Kind Regards

Tony

I've noticed missed two attributes in nav locale files:

Best regards
Oleg

OlegK said
Hello Kiran,

you wrote that you need an example for Add/Edit/Delete on local data. It means that all operation will be done in JavaScript without any code on the server side. So the words like "Gridview" and "I want ASP.NET example" seems me strange. the local editing example is pure JacaScript example without any ASP.NET or other server side code.

The methods delRowData, setRowData, addRowData exist before the version 3.7. The methods allow to make modification of grid contain without user interractionand without any requests to the servr. New in version 3.7 is that jqGrid can hold local data accociated with the grid which are more as the current page displayed. Starting with version 3.7 jqGrid support pure local paging, sorting and filtering/searching. To use it one should use datatype:'local' as the jqGrid parameter. The best wat to fill the data of the local grid is to use data parameter of jqGrid. See here an example.

Now about the local editing of the data. If you have jqGrid with local data (as described above) you can use two editing methods: inline editing and cell editing to edit the local data. One should use editurl:'clientArray' for inline editing and cellsubmit:'clientArray' for cell editing to use local data editing. The form editing implemented in 3.7 has not full local editing support, so jqGrid will do make some requests to the server.

Because you want all Add/Edit and Delete operation on local data you probably want the use form editing.

In my post here and here I describe one trick and include the demo which shows how one do can implement full local form editing in the current version of jqGrid. The demo use jqGrid 3.8.2, but the same idea should work in jqGrid 4.0 and 3.7. The code is not small, but it is probably what you need.

I suggested Tony to modify the code of jqGrid to implement full local form data editing in jqGrid without the tricks which I use. Probably in the next version of jqGrid the feature will be the part of jqGrid.

Best regards
Oleg

Hello Oleg,

Thanks for the Demo you provided above.

I have tried it and i am not able to edit and save in form edit. When I click on submit button nothing happens. No process at all. Please guide me through this issue

 

In this case I recommend you to use server side export to excel string instead of client side.

 

Regards

          Thanks for responding.

One possible solution is to use getrowdata, but with number of records relative big by example 1000.

 

the problem is i canuse get row data for filtered records but when you want  to select all the records to export to excel only first page is capturing suppose if i have 670 pages in that only first page records is showing in the excel..

Where you do this. The code you posted does not speak at all nothing.

 

Regards

 

This request is discussed many times.

One possible solution is to use getrowdata, but with number of records relative big by example 1000.

 

Kind Regards

onClose: function(data){
alert("in onClose");
},

 i am using filter tool bar on export to excel

$("#list").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: true, defaultSearch: "cn" }).navButtonAdd('#pager', {

caption:"Export to Excel",

buttonicon:"ui-icon-disk",

onClickButton:function() {ExportDataToExcel("#list");},

position:"last"});

 

function ExportDataToExcel(tableCtrl) {

ExportJQGridDataToExcel(tableCtrl,

"sample.xlsx");

}

 

This is my ExportJQGridDataToExcel function.

 

function

ExportJQGridDataToExcel(tableCtrl, excelFilename) {

var allJQGridData = $(tableCtrl).jqGrid('getRowData');

var jqgridRowIDs = $(tableCtrl).getDataIDs();
var headerData = $(tableCtrl).getRowData(jqgridRowIDs[0]);

 

when i use this

var allJQGridData = $(tableCtrl).jqGrid('getGridParam', 'data');  it will give all the records in the grid

when i use this

var allJQGridData = $(tableCtrl).jqGrid('getRowData'); it will give the filtered records and only first page is capturing.

 

Can any one plz help me out how to solve this issue,How can i get all the records in the grid as well as when i filter i need to get selected records.

 

Unfortunately no.

Regards

 

1. afterInsertRow is not your solution.

2. afterSubmit as you set is not a grid parameter.

3. You use inlineedit - I suggest you to use aftersavefunc which should be passes as parameter in editRow.

See docs for this purpose.

 

Kind Regards

Unfortunately we do not support such functionality if I right understand the problem.

 

Kind Regards

 

Maybe you use another css which causes this problem.

Try only with grid on page in order to see if the problem comes from another css or styles used on the page.

 

Regards

By default jqgrid renders as

..hdiv

...htable

....thead > tr // Header Row

..bdiv

..btable

..tbody > tr.. //Content Rows

 

Would it be possible to render it as single table instead of htable and btable?

I would like to float the HEADER ROW of the rendered table (hdiv > htable) on page level vertical scroll instead of grid level vertical scroll to the top of the page content.

I tried changing the top on content scroll but the floating header row flickers on vertical scroll.

Is there any hook/piece of code to achieve this?

 

Thanks!