I've created a dropdownlist whose values are drawn from an Access
database. This list of items represents a user account. In the same
record is a boolean field which records whether the user is an
administrator.
On my web form, I want a checkbox labelled "Is Admin" which will take
the appropriate value from the Access database depending on which value
is chosen in the dropdownlist.
I'm using a checkboxlist in this case as it has databinding built into
it. I know my AccessDBConnect ion_UserList is working correctly because
it populates the dropdownlist with the right values and I know that my
AccessDBConnect ion_IsAdmin is working correctly because I run a test
test query on it from inside Visual Studio.
However, when I run the website, the checkboxlist is not working
correctly. It doesn't take the right values.
Anyway, here's my code
<asp:AccessData Source ID="AccessDataS ource_UserList"
runat="server" DataFile="~/App_Data/AvailReport.mdb "
OnSelecting="Ac cessDataSource1 _Selecting"
SelectCommand=" SELECT DISTINCT [Name] FROM [UserList]">
</asp:AccessDataS ource>
<asp:DropDownLi st ID="DropDownLis t1" runat="server"
AutoPostBack="T rue" DataSourceID="A ccessDataSource _UserList"
DataTextField=" Name" DataValueField= "Name" Style="z-index:
103; left: 41px; position: absolute;
top: 38px">
</asp:DropDownLis t>
<asp:AccessData Source ID="AccessDataS ource_AdminInfo "
runat="server" DataFile="~/App_Data/AvailReport.mdb "
SelectCommand=" SELECT [Name], [isAdmin] FROM [UserList]
WHERE ([Name] = ?)">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="Drop DownList1"
DefaultValue="f alse" Name="Name"
PropertyName="S electedValue" Type="String" />
</SelectParameter s>
</asp:AccessDataS ource>
<asp:CheckBoxLi st ID="CheckBoxLis t1" runat="server"
DataSourceID="A ccessDataSource _AdminInfo"
DataTextField=" Name" DataValueField= "isAdmin"
Style="z-index: 104; left: 337px;
position: absolute; top: 59px">
</asp:CheckBoxLis t>
