Drop Down Menu asp.net web page+VB+SQL Batabse

Posted by Baijuep under Regular Expressions on 3/19/2011 | Points: 10 | Views : 2322 | Status : [Member] | Replies : 0
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
slno, int
veheqpt, varcahar(200)
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

Baiju EP

Baiju EP


(No response found.)

Login to post response