Insert values from Checkboxlist

Question

Hi all..

 

I have a page frmLocationMaster.aspx. ..

 

On this, I am having 2 checkboxlist controls -

1. checkboxlistusers

2. checkboxlistlocation

 

Uitlity -

Users must get access to specific locations only ..

 

Eg -

 User Table

ID	User
1	A
2	B
3	C
4	D
5	E

 

ID	Location
1	UP
2	Bihar
3	Andhra Pradesh
4	Karnataka
5	Maharashtra
6	West Bengal
7	Gujarat
8	Rajasthan

 

Suppose, Users - A,B,C must have access to Location - UP, Rajasthan and Bihar.

Then, user will select - users -A,B,C From userscheckboxlist and Location - UP, Rajastahn,Bihar from LocationCheckboxlist.

On button click event - Following data must be inserted -

UserID	Location
A	UP
B	UP
C	UP
A	Rajasthan
B	Rajasthan
C	Rajasthan
A	Bihar
B	Bihar
C	Bihar

 How to do this ??

Please guide ..