Code Bank
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingCode Bank

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old May 25th, 2004, 01:06 AM
M3L M3L is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 2 M3L User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy CheckListBox control and Database (URGENT, pls help..)

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

Reply With Quote
  #2  
Old May 30th, 2004, 08:09 PM
M3L M3L is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 2 M3L User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy anyone?

Why has no one replied my posting ...

Reply With Quote
  #3  
Old May 31st, 2004, 10:44 AM
tsunami tsunami is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: May 2004
Posts: 38 tsunami User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
Smile

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

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingCode Bank > CheckListBox control and Database


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT