search and filter stocknumber binding from sql

Question

HI I want to make a search and filter box where i can search the stock number by typing first or middle or last letter and based on that i can update the stock quantity.Here i have 300 stock numbers where i can bind from sql db. how can i make dropdown list as search box or Is there any other process using asp.net c# and sql db.

Ramya S · Answer

Hi vinay thanks for your code.But exactly what i mean is i want to write my code in codebehind(aspx.cs) and i want to use db to bind with out manual typing the list items coz i have thousands of stock numbers in that so i want quick launch by typing any of the digits or letters to eliminate the limit of stock numbers for user to check. ex:filpkart search boxindian railway From: To:

Vinay Singh · Answer

Hi Please check the code html > head > script type =text/javascript src =http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js> script > script src =Scripts/jquery.searchabledropdown-1.0.8.min.js type =text/javascript> script > script type =text/javascript> $(document).ready( function () { $( select ).searchable(); }); script > head > body > form id =form1 runat =server> asp : DropDownList ID =myselect runat =server> asp : ListItem > Select asp : ListItem > asp : ListItem > venki asp : ListItem > asp : ListItem > venu asp : ListItem > asp : ListItem > charles ven asp : ListItem > asp : ListItem > venuzila asp : ListItem > asp : ListItem > veron philender asp : ListItem > asp : ListItem > india asp : ListItem > asp : ListItem > indianven asp : ListItem > asp : ListItem > vesta asp : ListItem > asp : DropDownList > form > body > html > For detail check the link http://www.fourthbottle.com/2015/03/how-to-create-searchable-dropdown-list.html

Asad Ali · Answer

I would say to load the 300 in memory. Use a text box and on every key pressed event you can search those 300 entires and show(this could be an autofill) the possible match.