Getting columns and rows from jqx grid

[palaskarvidyaMember]

Hi,

I am using jqwidget grid and I am passing columns and rows dynamically to the grid. And on click of save button I am fetching all the rows  using api –  $(‘#jqxgrid’).jqxGrid(‘getrows’);

However my problem is, I also needed column names. I have tried with api – exportdata in json format which is giving me what exactly I wanted, but it is in downloable file format.

How can I get the rows and columns directly in one of the variable instead of in a file?

Waiting for soonest reply

Thanks,

Vidya

 

[econceptMember]

How to get all the row values in grid ?any code please

[Peter StoevKeymaster]

Hi econcept,

“getrows” returns an Array of the Rows displayed in the Grid. To access a value of a row, you can do that:

var rows = $("grid").jqxGrid('getrows');
var firstRow = rows[0];
var cellValue1 = firstRow.FirstName;

In the above code FirstName is the name of a data field i.e the value of the “datafield” property of a Grid column.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[palaskarvidyaMember]

Hi econcept,

Here is the code I am using to get all rows in a grid-

var rows = $(‘#jqxgrid’).jqxGrid(‘getrows’);
var str = JSON.stringify(rows);
alert(str);

Can any on help me to get all the rows and columns in a grid once in a one json or array object?

Thanks & Regards,
Vidya Palaskar

[Author]

Posts