jQuery Grid Plugin - jqGridForum

Topic RSS

Set selection when data loaded

27/11/2009
10:16

bernie.blakeney

Member

Members

Forum Posts: 5

Member Since:
27/11/2009

Offline

Is there anyway to return the selection state with my data set so that rows will be selected based on data in my db? I save the selected state of each row into a database so the user can re-use a selection but I can't figure out an effiecient way to set the selection from the query.

Thanks

27/11/2009
11:32

Rumen[Trirand]

Moderator

Members

Moderators

Forum Posts: 81

Member Since:
08/10/2009

Offline

One way to do it is to pass the selected rows as a javascript array, and then hook the gridComplete event, where you can set selected rows based on the values in the array, e.g. something along the lines of

jQuery('#JQGridID').setGridParam( {gridComplete: function()

{

var grid = jQuery('#JQGridID');

grid.setSelection(selectedRowArray[0],false);

}});

Trirand ASP.NET WebForms & MVC components based on jQuery & ThemeRoller

http://www.trirand.net

27/11/2009
11:49

bernie.blakeney

Member

Members

Forum Posts: 5

Member Since:
27/11/2009

Offline

Thanks Rumen,

I've tried something like that but it is dreadfully slow. Here's the code, maybe I'm doing something wrong.

gridComplete: function()
            {
                var uData = jQuery('#list').getGridParam('userData');
                var id_arr=uData.selected.split(",");

                for (var i=0;i<=id_arr.length;i++)
                {
                    jQuery('#list').setSelection(id_arr[i],false);
                }
            }

30/11/2009
12:49

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

It depends how many data you loop.

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

02/12/2009
16:23

bernie.blakeney

Member

Members

Forum Posts: 5

Member Since:
27/11/2009

Offline

Thanks Tony.

I don't have that much data - about 500 rows. Firefox gives me that "a script is running slowly" message after only about 120 records.

It would be really great if in the data I'm returning I could add an attribute to the row element that jqgrid would use to select the row - something like "<row id='1234' selected='Y'>". Then jqgrid could set the value when painting the grid which I assume would be much faster.

Bernie

02/12/2009
16:58

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

You can try to use afterInsertRow - where you can set the selection.

Note that in this case gridview mode should be false.

Please let me know if this is faster.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
53 Guest(s)

Currently Browsing this Page:
1 Guest(s)