Jquery datatables, checkboxes and asp.net

Question

I'm working with Jquery datatables with asp.net repeaters and 90% of everything is working ok. Problem is that I've got a column of checkboxes and if I page through the datatable checking some boxes and then submit, I only get the last page of details, it forgets all other pages where checkboxes were checked.

This is covered more or less here:

http://www.datatables.net/forums/discussion/7700/repeater-checkbox-and-paging/p1

However, I've no idea how to get that data from an asp.net postback, anyone shed any light on how I'd be able to iterate through the repeater and get all checked boxes?

Thanks.

Anyone? I suppose I could use some sort of postback oncheckchanged solution but it's not ideal and could be messy. Anyone know of a better solution which would tie in nicely with .net's postback model? — Full Time Skeleton
– Full Time Skeleton, Commented Feb 6, 2012 at 10:08

Jovan MSFT · Accepted Answer · 2012-02-14 21:33:10Z

I would add click handler on each check box that adds/remove id of the selected checkbox in some list (e.g. as a content of some hidden field as a comma separated list or something similar).

When you post form you can read this content from Request["hiddenFieldName"], split it by comma and save it.

Regarding the lost checkbox values on page change there is not direct solution. My choice would be to bind "page" event handler to datatable - something like this:

$('#example')
    .bind('page',   function () { populateCheckboxes(  ); })
    .dataTable();

function populateCheckboxes will be called on each page change and here you can go through all checkboxes in the table and check whether their value is in the list in the hidden field.

Sorry but there is not easier solution for this, however this is not too complex script either.

Jovan

Alfred · Accepted Answer · 2012-08-17 17:28:30Z

0

Use the below approach in your code-behind. "rptrPayableItems" is the name of repeater.

foreach (RepeaterItem ri in rptrPayableItems.Items){                    
  CheckBox cbPaid = (CheckBox)ri.FindControl("chkbxPayItem");
  if (cbPaid.Checked){       
    //Do your operation here for checked checkbox.
  }
}

edited Aug 17, 2012 at 17:28

Alfred

21.5k64 gold badges175 silver badges258 bronze badges

answered Mar 29, 2012 at 19:14

gpr

1

1 Comment

Full Time Skeleton Over a year ago

Unfortunately that doesn't work. With Datatables, if you've paged then when you iterate through the repeater in code behind it doesn't remember the items checked on the other pages.

Collectives™ on Stack Overflow

Jquery datatables, checkboxes and asp.net

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related