Riddhi Valecha

Riddhi Valecha

  • 443
  • 3.3k
  • 413.1k

Insert values from Checkboxlist

Nov 29 2016 4:31 AM
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
 2B
 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
 BUP
 C UP
 A Rajasthan
 B Rajasthan
 C Rajasthan
 A Bihar
 B Bihar
 C Bihar
  
 How to do this ??
Please guide ..
 

Answers (4)