CheckBoxList Data Binding Problem

[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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!