i have a asp.net+VB+SQL2005 database. Login is made through user id, sect, password. means diffrent sect has separate user id and password. when a user named veh and password veh123 login the web page named new job card open the jobnumber is automatically created (for different sections ie veh=B/0001, tcm= l/0001/ etc) every thing is working fine.In initial stage vehicle name and equipment names were inserted manually when i created drop down menu which collects data from sql table. the entire list is comming in the dropdown menu i want to restrict the list as per sections only
database named workshop and table named menu with following fields
i used the following code to make the dropdown menu
<asp:Dropdownlist id="atMyDropDownList" DataValueField = "veheqpt"
DataTextField = "veheqpt" runat="server" DataSourceID="SqlDataSource1" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:workshopConnectionString %>"
SelectCommand="SELECT [veheqpt] FROM [Menu]"></asp:SqlDataSource>
please help me