| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
How to have a check box list that contains checked or unchecked boxes depending on the fields'
value being in the database, and the allow the user to check/uncheck, and then recors the new checks states in the database for that rows? Eg. I have two tables: Person table (Person ID, Name, InterestID(FK)),' and Interest table (InterestID, Interest). When showing a particular person in a window form, the check list box will contains all interests from the interest table (for this I use array and manual Select SqlCommand), as well as checked boxes, the value of that person's interests in the InterestID(FK). Then, user will be able to change the value in the person table by checking/unchecking the boxes, saving any changes when a save button is click. Last edited by M3L : May 26th, 2004 at 12:58 AM. Reason: no response |
|
#2
|
|||
|
|||
|
Why has no one replied my posting ...
![]() |
|
#3
|
|||
|
|||
|
read the value from the database and perform a series of checks using Case statements.
As for updating the fields - create a form around the check boxes which get posted to an asp prog that updates the database. let me know if you need further help |
![]() |
| Viewing: ASP Free Forums > Programming > Code Bank > CheckListBox control and Database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|