CheckBoxList Data Binding Problem

A

Agi Chen

Hello, theres,
I'm newbie in asp.net. I have problem in CheckBoxList binding to
database. Considering my case in a member system,
if I have 2 tables one for interest, one for memberInterest
the SQL DDL like follows:
create table interest ( intId int, intName varchar(20))
go
Insert into interest values ( 1, 'Music')
Insert into interest values ( 2, 'Jogging')
Insert into interest values ( 3, 'Fishing')
Insert into interest values ( 4, 'Reading')
go
create table MemberInterest ( memName varchar(10),
meminterest int)
go
-- Peter like Music, Reading
insert into MemberInterest values ('Peter', 1)
insert into MemberInterest values ('Peter', 4)
-- Nick like Music,Jobbing, Fishing
insert into MemberInterest values ('Nick', 1)
insert into MemberInterest values ('Nick', 2)
insert into MemberInterest values ('Nick', 3)
go

Now I want to use a checkBoxList to show the records when the user
login, how to use dataset to bind the checkboxlist
and when updating checkboxlist also sync to database ??

Any idea or example ??
(Is it need to update to db via iterate each listitem like
asp ?? )

Regards,
Agi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,278
Latest member
BuzzDefenderpro

Latest Threads

Top