Click here to Skip to main content
15,885,689 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i may not explain my problem clearly but bellow i written with description..

Actually i am having to check box lists(check-box list1,check-box list2)
for check-box list1 i am binding all the users(registration_id) from registration(registration_id,name,login_id,password) table and for check-box list2 i am binding the records from access table(access_id,description,status) where the records are in static means in that table i am having six records those records are static.
now both the check box lists are displaying on my webpage.
and i am having one more table user_access in that table i am having three fields(registration_id,access_id,status)

example:
//i inserted one record in registration table
------------------------------------------------------------------------------
registration_id | username | loginid | password ------------------------------------------------------------------------------
1 | nitish | ab@gmail.com | 12345

access table(static)
-------------------------------------------------------------------------------
access_id | description | active
-------------------------------------------------------------------------------
1 | reports | 1
2 | leads | 1
3 | import | 1

user_access table (while registration only these records will inserted by taking registration_id from registration table and access_id,active from access table)
------------------------------------------------------------------------------
registration_id | access_id | active
---------------------------------------------------------------------------------
1 | 1 | 1
1 | 2 | 1
1 | 3 | 1


here what i want is when i binded all the users in check-box list1. if i click on any particular user it should check the user_access table whether that user having the active 1 or 0, if it is 1 means check box should be checked in check-list 2 where we already binded the records from access table
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900