How to bind checked list box to databasetable or list?

Question

Hi I have a form with binding navigator datasource of the binding navigator is a list of master table(ie the list contain another list of child table). I could bind all the controls to the mastertable listand could navigate properlly with the binding navigator. But facing problem with checked list box. I need to bind all the selected values to child table list. anyone can help me on this? Thanks in advance.

Raheena · Answer

Hi Althaf I am using vb.net language. I found a way using BindingList. but happy to know if you have some other ideas.

Altaf Patel · Answer

you need a code for it in which language?

Raheena · Answer

Hi Sam sorry that i dint make it clear before. ok I will explain. I am having a main form with binding navigator in vb.net data entry application. and by clicking a menu item in the main form I am opening a child form. The child form contains a number of textboxes and one checked list box. For e.g. consider it as a student details form for convenience I have 3 tables in the database. Student details(Master table - studentID name) Selected_Subjects(child table - studentID subjectID) and subject(SubjectID Subject Name). Subject table is the datasource of checked list box. User will enter student name student id and checked the selected subjects on the checked list box(student id and selected subject's id should go to the Selected_Subjects table). And adding a new record using the binding navigator addnew button. so whats my problem is i could bind the text boxes to the binding navigator so that i can navigate through different student records using the move next move previous button in the binding navigator and correct student id and student name is displaying in the text boxes. but the checked box list is not showing the correct checked items. Did you get something? or still confused?

Sam Hobbs · Answer

I am sorry but I don't understand. Where is the checked listbox? Is it in the mastertable list? Is it in the navigator? Is it in the child table? Of course none of those possibilities make sense but it is not clear what does make sense. Please clarify; what data is in the checked listbox? What data needs to be in the child table list?