<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/jsdb2.mdb" SelectCommand="SELECT [room_nb] FROM [room] WHERE ([room_name] = DropDownList1) ">
<asp:ControlParameter ControlID="DropDownList1" Name="newparameter" PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>