search and filter stocknumber binding from sql

Ramya S

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramya S10y ago
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 box,indian railway From: To:
0
Vinay Singh10y ago
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>Selectasp:ListItem>

<asp:ListItem>venkiasp:ListItem>

<asp:ListItem>venuasp:ListItem>

<asp:ListItem>charles venasp:ListItem>

<asp:ListItem>venuzilaasp:ListItem>

<asp:ListItem>veron philenderasp:ListItem>

<asp:ListItem>indiaasp:ListItem>

<asp:ListItem>indianvenasp:ListItem>

<asp:ListItem>vestaasp:ListItem>

asp:DropDownList>

form>

body>

html>
For detail check the link
http://www.fourthbottle.com/2015/03/how-to-create-searchable-dropdown-list.html
0
Asad Ali10y ago
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.
0