How to get a jqGrid selected row cells value

Question

Does anyone know how to get the cells value of the selected row of JQGrid   i m using mvc with JQGrid  i want to access the value of the hidden column of the selected row

User · Answer

Use  selrow  to get the selected row Id  var myGrid       myGridId     var selectedRowId   myGrid jqGrid  getGridParam    selrow     and then use getRowData to get the selected row at index selectedRowId   var selectedRowData   myGrid getRowData selectedRowId    If the multiselect is set to true on jqGrid  then use  selarrrow  to get list of selected rows   var selectedRowIds   myGrid jqGrid  getGridParam    selarrrow     Use loop to iterate the list of selected rows   var selectedRowData   for selectedRowIndex   0  selectedRowIndex  lt  selectedRowIds  length  selectedRowIds           selectedRowData   myGrid getRowData selectedRowIds selectedRowIndex

User · Answer

You can use in this manner also  var rowId      list   jqGrid  getGridParam   selrow      var rowData   jQuery   list   getRowData rowId   var colData   rowData  UserId         perticuler Column name of jqgrid that you want to access

User · Answer

Just to add  you can also retrieve a jqGrid cell value  based on the rowID plus column index  rather than the Column name    So  to fetch the value in the forth column  column index   3  for the row with primary key ID 1234  we could use this   var rowID   1234  var columnIndex   3  var cellValue           rowID  find  td   eq columnIndex  text      Btw  on a completely unrelated topic  but please don t vote me down     I didn t realise that you can  fairly easily  link text boxes to your jqGrid  so your users can do instant searching  without having to open the Search dialog     To do this  you need a bit of HTML like this    lt input type  text  name  employeeName  id  employeeName  style  width 250px    gt    lt  --  This will be my jqGrid control and pager -- gt   lt table id  tblEmployees  gt  lt  table gt   lt div id  pager  gt  lt  div gt    And a bit of JavaScript like this       employeeName   on  change keyup paste   function          SearchByEmployeeName         function SearchByEmployeeName             Fetch the text from our  lt input gt  control     var searchString       employeeName   val             Prepare to pass a new search filter to our jqGrid     var f     groupOp   AND   rules                 Remember to change the following line to reflect the jqGrid column you want to search for your string in         In this example  I m searching through the UserName column       f rules push   field   UserName   op   cn   data  searchString          var grid       tblEmployees        grid 0  p search   f rules length  gt  0        extend grid 0  p postData    filters  JSON stringify f          grid trigger  reloadGrid      page  1          This is a real game-changer for me    it really makes jqGrid much more user friendly   Users can immediately start typing in their search string  rather than needing to open the Search dialog  remember to change the operator to  contains   then start typing  and close the search dialog again

User · Answer

First you can get the rowid of the selected row with respect of getGridParam method and  selrow  as the parameter and then you can use getCell to get the cell value from the corresponding column   var myGrid       list        selRowId   myGrid jqGrid   getGridParam    selrow        celValue   myGrid jqGrid   getCell   selRowId   columnName      The  columnName  should be the same name which you use in the  name  property of the colModel  If you need values from many column of the selected row you can use getRowData instead of getCell

User · Answer

Just Checkout This    Solution 1    In Subgrid Function You have to write following    var selectid     this  jqGrid  getCell   row id   id    alert selectid     Where row id is the variable which you define in subgrid as parameter  And id is the column name which you want to get value of the cell   Solution 2    If You Get Jqgrid Row Id In alert Then set your primary key id as key true In ColModels  So You will get value of your database id in alert  Like this      name  id  index  id  hidden true  width 15 key true  jsonmap  id

User · Answer

yo have to declarate de vars      var selectedRowId       list   jqGrid   getGridParam    selrow    var columnName       list   jqGrid  getCell   selectedRowId   columnName      var nombre img articulo       list   jqGrid  getCell   selectedRowId   img articulo

[jquery] How to get a jqGrid selected row cells value

Examples related to jquery

Examples related to asp.net-mvc

Examples related to jqgrid

Examples related to jqgrid-asp.net