hi i have a checkboxlist with ID=cbl_news,
and the list of checkboxlist items is from datasource (database table : newsgroup).
i would like to retrieve a list of newsgroupID (from another database table: selectednewsgroup), which have records of previously stored newsgroupIDs when they are selected from cbl_news and stored.
finally, i would like the results to appear as selected values in cbl_news.
(which means that the whole list of items from db: newsgroup is displayed (e.g 4 records), and the records from selectednewsgroup (e.g 2 records) will be displayed as selected values),
and thus it'll be shown as 4 items in checkboxlist with 2 selected items.
may i know how do i go about doing it? thanks alot!
and the list of checkboxlist items is from datasource (database table : newsgroup).
i would like to retrieve a list of newsgroupID (from another database table: selectednewsgroup), which have records of previously stored newsgroupIDs when they are selected from cbl_news and stored.
finally, i would like the results to appear as selected values in cbl_news.
(which means that the whole list of items from db: newsgroup is displayed (e.g 4 records), and the records from selectednewsgroup (e.g 2 records) will be displayed as selected values),
and thus it'll be shown as 4 items in checkboxlist with 2 selected items.
may i know how do i go about doing it? thanks alot!