Use Grid as input to db

[sakthisainathParticipant]

Can anyone explain how to use our jqxgrid as input to the db?

I mean, while loading the page, I will load an empty grid with 10 rows and 5 columns. Now I fill the rows with data and if I click ‘Add’ button, all the 10 rows in the grid must be inserted into my db. How can I achieve this in our grid?

[Peter StoevKeymaster]

Hi sakthisainath,

jqxGrid has method called “getrows” which returns all rows displayed in the Grid as a JavaScript Array. Then using the jQuery’s AJAX function, you can make an ajax call to your server and pass that Rows array as parameter. On your Server’s script, you’ll have to write logic for adding these rows to the DB.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[sakthisainathParticipant]

Thanks Peter Stoev,

But how to load a empty grid in my page and fill the rows with the data I want?

[Peter StoevKeymaster]

Hi sakthisainath,

You can use the “addrow” method for adding rows in the Grid.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[sakthisainathParticipant]

Ya I understand Peter,

But my question is how to load an empty grid with no values while loading the page?

[Peter StoevKeymaster]

Hi sakthisainath,

To load empty grid with no values, you may set its source property to null. Example: http://jsfiddle.net/bgzzp492/

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[sakthisainathParticipant]

Sorry Peter, I know I’m disturbing you a lot.

Now I’ve loaded an empty grid. Consider there are 3 editable columns (Firstname,lastname,age).

Initially the grid is empty.

Now, I start entering values for firstname(Sakthi),lastname(Sainath),age(24) in the grid that is displayed.

Now, I have a button called ‘Save’. When I click Save, I want to retreive all the 3 values, so that I can store them in a separate variable and insert into my DB.

How to get all the 3(Firstname,lastname,age) values entered in the grid during runtime?

[Peter StoevKeymaster]

Hi sakthisainath,

By using “getrows” again. It returns an array of rows. That array contains All your Grid data values.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts