how to get jqgrid first row data with out select in jsp?

Question

How to get table first row data in jqgrid?

enter image description here

Here I want 2 and 4.0 data from jqgrid how to get this value without click table value?

var rowId = $("#gridtable2").getRowData(0);
var name = rowId['m_tab_p'];

Here gridtable2 is jqgrid id, and m_tab_p is 1st column id..

JSP grid code:

<s:url id="remoteurl2" action="add_act" />
                        <sjg:grid caption="RECORDS" gridModel="dto_plot_rep" width="250"
                            height="70" href="%{remoteurl2}" id="gridtable2" rownumbers="true"
                            viewrecords="true" pager="true" pagerPosition="centar"
                            navigator="true" navigatorSearch="true"
                            navigatorSearchOptions="{multipleSearch:true}"
                            navigatorDelete="false" navigatorEdit="false" loadonce="true"
                            onCompleteTopics="cal_tot" userDataOnFooter="true"
                             rowNum="0">

                            <sjg:gridColumn name="m_tab_p" index="m_tab_plotno"
                                title="PLOT" width="180" align="left" search="true"
                                searchoptions="{sopt:['eq','cn']}" sortable="true" />
                            <sjg:gridColumn name="m_tab_c" index="m_tab_cent" title="CENT"
                                width="180" align="left" search="true"
                                searchoptions="{sopt:['eq','cn']}" sortable="true" />
                        </sjg:grid>

Runcorn · Answer 1 · 2014-07-09T07:32:44.673

2

To get the data of first row you can use following in loadComplete

        //Call On JqGrid Load Complete
        loadComplete:function(data){
                    //id list value
                    var ids = $("#gridtable2").jqGrid('getDataIDs');
                    //get first id
                    var cl = ids[0];
                    var rowData = $(this).getRowData(cl); 
                    var temp= rowData['UserId']
            },

And if you are using it outside of loadComplete use :

  var ids = $("#gridtable2").jqGrid('getDataIDs');
                //get first id
 var cl = ids[0];
    //fetch row data 
 var rowData = $("#gridtable2").getRowData(cl); 
    //fetch individual cell value
 var celValue = $("#gridtable2").jqGrid ('getCell', cl, 'UserId');

And here is the working JSFIDDLE

edited Jul 09 '14 at 07:32

answered Jul 09 '14 at 07:04

Runcorn

5,144
5
34
52

which value is returning null? Check the updated answer. – Runcorn Jul 09 '14 at 07:12
Now you can check yourself the fiddle, P.S yes it was returning null. – Runcorn Jul 09 '14 at 07:33
Thank u so much runcorn – sathya Jul 09 '14 at 07:35

score 1 · Answer 2 · answered Jul 09 '14 at 07:00

1

You can have data of raw in the rowData

> var rowId =$("#gridtable2").jqGrid('getGridParam','selrow');   
> var rowData = jQuery("#gridtable2").getRowData(rowId);

you can also get particulate column value by this code

var colData = rowData['UserId'];

answered Jul 09 '14 at 07:00

Mitul Maheshwari

2,647
4
24
38

it's inbuilt keyword of jqgrid. which will give you selected row id – Mitul Maheshwari Jul 09 '14 at 07:04
But I cannot select table's row.I want to get 1st row only – sathya Jul 09 '14 at 07:05
1st row datas I want. that is row id is 0.Your code 1st line rowId returns null 2nd row has error – sathya Jul 09 '14 at 07:48

Bhushan Kawadkar · Answer 3 · 2014-07-09T07:24:48.697

1

Try this : you want to read only first row hence rowId =1. get row object and read each column value by its name.

var rowObj = $("#gridtable2").getRowData(1);
var name_p = rowObj['m_tab_p'];
var name_c = rowObj['m_tab_c'];

alert(name_p);
alert(name_c);

edited Jul 09 '14 at 07:24

answered Jul 09 '14 at 07:10

Bhushan Kawadkar

28,279
5
35
57

are you calling this after $("#gridtable2").jqGrid(.. call? are there any errors on console? Can you share jsfiddl of it so that i can help you better way. Also I forgot to define name_c variable in my post. please update it and try again. – Bhushan Kawadkar Jul 09 '14 at 07:24
Refer this link http://stackoverflow.com/questions/24603337/how-to-load-data-in-jqgrid-manually and after table load then if add some more data I want previous record in table so I want to do this task.. – sathya Jul 09 '14 at 07:26

how to get jqgrid first row data with out select in jsp?

3 Answers3

Linked