asp.net dropdownlist and checkboxlist problem

See more:

C#

ASP.NET

Dear All,

I Have problems with dropdownlist and checkbox control.

In my application I have one Dropdownlist1 which I fill manually with five items like this...

----select----
NationalSalesManager value=1
RegionalManager value=2
DepotManager value=3
AreaManager value=4
Supervisor value =5
salesman value=6

I want to populate one checkboxlist on the selected event of dropdownlist from the database- Dropdownlist1_SelectedIndexChanged.

When I select the NationalSalesManager then the record of National Sales Manager table display in checkBoxlist, when I select the RegionalManager from dropdownlist then the record of RegionalManager Table display in checkBoxList same as for others.


Please help me.