checklistbox - insert in database.

Question

Hi all... I am not able to form a logic -- Please help -- I have a checklistbox - With a list of names (total 56 names)... Now I want that - If I select 5 users  then total 5 records/rows must be saved in the database... Eg - If I select ABCDE - Then in database - 5 rows must be inserted in table A with values - A B C D E ----------- How do I form this loop ??

Francis · Answer

How do I form this loop ?? You need to form the loop as below: // Loop thru the check box list items foreach(ListItem lstItem in chkBoxList.Items) { // check the list item is selected if(lstItem.Selected) { // To do your insert logic here } } Hope this helps!

Francis · Answer

You need to refer the current item. Not the entire Checkbox List. Try with this code: private void INsertdata() { foreach (ListItem lstItem in chkboxEmpNames.Items { if (lstItem.Selected == true) { Insert into EmpTable (EmpID) values( convert.toint32(lstItem.Value)); } } }

Riddhi Valecha · Answer

private void LoadCheckboxList() { chkboxEmpNames.DataSource = Datatable; chkboxEmpNames.DataTextField = EmpName; chkboxEmpNames.DataValueField = ID; chkboxEmpNames.DataBind(); } -- private void INsertdata() { foreach (ListItem lstItem in chkboxEmpNames.Items { if (lstItem.Selected == true) { Insert into EmpTable (EmpID) values( convert.toint32(chkboxEmpNames.SelectedValue)); } } } --------- In If-Condition - I get next value  but in convert.toint32(chkboxEmpNames.SelectedValue) the value is not moving.

Francis · Answer

Have you debugged the application by keeping break points? If possible share your code.

Riddhi Valecha · Answer

Hi I have Datatable is the datasource of checklistbox1 .... (in short I have binded it with datatable)... checklistbox1.datatextfield=Name checklistbox1.datavaluefield=ID foreach(listitems lst in checklistbox1.items) { if(lst.selected == true) { // Insert -1 } } Likewise I have selected 123 values ( DataValueFileds) So I want 3 rows - 123 in database. This loop is not iterating on button click event. Only 1 is being saved 3 times. Please help !

Francis · Answer

I guess I have answered your first question. The question you have asked now is not relevant with your first question. So you need to create a new thread for your question. The reason is if any one refer this thread in future he get confused because of the subject you gave and questions you asked. :)

Riddhi Valecha · Answer

Also How to do paging in checkboxlist ?? I have total 45 book names to be loaded in checkboxlist - I want to display only 10 names at a time .. How to do this ?? And  the selection must remain...