473,659 Members | 3,631 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

drop down list should display data as user enters value in it

Hi,

I have a drop down list bound to a database thorugh a data reader. It reads
the customer names from data reader.

Now, I want the user to be able to type more than one alphabet & the list
becomes shorter & shorter for the user to choose a value from. For example,
suppose the user wants to select the name "Michael" from the dop down list .
So when he tabs over & reaches this drop down list, he types "Mi" , then all
the names beginning with "Mi " are displayed . When he ttypes "Mic", then the
drop down list becomes shorter & all the names beginning with "Mic" are
displayed.

The drop down list which I have now allows typing only the first letter &
not subsequent letters. Presently, if a user types "M" , then all names
beginning with M are displayed but when the user types the next letter "i"
(from "Michael) , then the list shows all the letters beginning with "I"
rather than beginning with "Mi".

How to go about doing this?

Thanks

--
Nov 19 '05 #1
3 2469
You can't find this kind of functionality in the standard controls. You
have to either write your own control or buy it from a third party, i
know infragistics WebCombo has that.

Nov 19 '05 #2
Standard HTML does not support such a control, however it can be faked
fairly effectively with client side script.
Here's a free control that does what you describe, and the source code is
freely available in case you'd like to enhance it:
http://www.metabuilders.com/tools/ComboBox.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"pmud" <pm**@discussio ns.microsoft.co m> wrote in message
news:25******** *************** ***********@mic rosoft.com...
Hi,

I have a drop down list bound to a database thorugh a data reader. It
reads
the customer names from data reader.

Now, I want the user to be able to type more than one alphabet & the list
becomes shorter & shorter for the user to choose a value from. For
example,
suppose the user wants to select the name "Michael" from the dop down list
.
So when he tabs over & reaches this drop down list, he types "Mi" , then
all
the names beginning with "Mi " are displayed . When he ttypes "Mic", then
the
drop down list becomes shorter & all the names beginning with "Mic" are
displayed.

The drop down list which I have now allows typing only the first letter &
not subsequent letters. Presently, if a user types "M" , then all names
beginning with M are displayed but when the user types the next letter "i"
(from "Michael) , then the list shows all the letters beginning with "I"
rather than beginning with "Mi".

How to go about doing this?

Thanks

--

Nov 19 '05 #3
Thanks, I will try that.
:))

"Steve C. Orr [MVP, MCSD]" wrote:
Standard HTML does not support such a control, however it can be faked
fairly effectively with client side script.
Here's a free control that does what you describe, and the source code is
freely available in case you'd like to enhance it:
http://www.metabuilders.com/tools/ComboBox.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"pmud" <pm**@discussio ns.microsoft.co m> wrote in message
news:25******** *************** ***********@mic rosoft.com...
Hi,

I have a drop down list bound to a database thorugh a data reader. It
reads
the customer names from data reader.

Now, I want the user to be able to type more than one alphabet & the list
becomes shorter & shorter for the user to choose a value from. For
example,
suppose the user wants to select the name "Michael" from the dop down list
.
So when he tabs over & reaches this drop down list, he types "Mi" , then
all
the names beginning with "Mi " are displayed . When he ttypes "Mic", then
the
drop down list becomes shorter & all the names beginning with "Mic" are
displayed.

The drop down list which I have now allows typing only the first letter &
not subsequent letters. Presently, if a user types "M" , then all names
beginning with M are displayed but when the user types the next letter "i"
(from "Michael) , then the list shows all the letters beginning with "I"
rather than beginning with "Mi".

How to go about doing this?

Thanks

--


Nov 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
11037
by: ehm | last post by:
I am working on creating an editable grid (for use in adding, deleting, and editing rows back to an Oracle database). I have a JSP that posts back to a servlet, which in turns posts to a WebLogic SFSB and, from there, to the database. On the front end, all cells appear as text fields. However, for certain cells, when the user clicks on the cell, the text field turns into a drop-down field (i.e. Select object), defaulting to the value...
2
9462
by: kmnotes04 | last post by:
Is it possible to link one drop-down box to another? For example, if a name is chosen from a drop-down list, can another drop-down list then automatically display the person's office as a result of the choice made in the first drop-down list? If so, how can that be done? I am working with 'Teach Yourself Microsoft Access' and I didn't see it discussed in that book (if it's even possible to do). Or would I just have to create linked tables...
0
1084
by: Esteban404 | last post by:
I have an ASP.NET page with two drop down lists and several text boxes. A dataset is created based on the first list's selected value and then it's stored in the page's ViewState. It loads the first record fine, but how do I allow a user to select an item from the second drop down list and update the page's display? The users do not want a grid because there is too much data to display in a glance. I don't have an ASP.NET reference with...
2
2393
by: Eric Dan | last post by:
Hi, Even tough I was able to implement what I want in a weird and non efficient way, I would like to get an opinion what is the right way to achieve my task: Scenario: • Display a DataGrid that contains rows from a table from a databse (so far easy). • I would like to add a column to the DataGrid that will be a drop-down list so the user will be able to select a value from a pre-defined list of values
2
12612
by: Yoshitha | last post by:
hi I have 2 drop down lists in my application.1st list ontains itmes like java,jsp,swings,vb.net etc.2nd list contains percentage i.e it conatains the items like 50,60,70,80,90,100. i will select any skill in 1st drop down list then i'll select % of this skill in the 2nd list box , based on the percentage i've selected in the 2nd list box it has to display 2 sets of drop down list boxes at run time one for selecting skill and
5
4219
by: Vigneshwar Pilli via DotNetMonster.com | last post by:
string connectionString1 = "server=(local); user=sa;password=sa; database=sonic"; System.Data.SqlClient.SqlConnection dbConnection1 = new System.Data.SqlClient.SqlConnection(connectionString1); System.Data.SqlClient.SqlCommand dbCommand1 = new System.Data.SqlClient.SqlCommand();
0
2151
by: weiwei | last post by:
Hi here is my scenario, I create a drop down list in itemtemplate.(that drop down is created from db), after user click edit command, my ideal plan is have another drop down list in edititemtemplate with preselected value from the previous drop down list, so far I can only achieved with the regular drop down list in edititemtemplate with no preselected value from previous one. anyone can help me. thanks in advance. below is my current...
2
3201
by: leeperman | last post by:
In Dreaweaver I cannot filter my database results to display only specific data that is retrieved from mulptile drop down list on my search page. The drop down list selections are posted to my display page by GET. How do i write my sql code so to only display info where TOWN = "Town selected from list" AND BEDS ="No of Beds selected from list My search page form is below <form action="tsearchresults.asp" method="get" name="townSearchForm"...
1
3912
by: deerick | last post by:
Hi there I want to know how to add a drop down list based on value from a table in an asp form. Then I want the user to be able to submit the form, and the drop down list value that they have selected to be stored in a different table. Does anyone know how to do this, I present I am using the code below, which does create the drop down list, but then I not sure how to add its value to another table in my database ( Acesss) If anyone can...
0
8428
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8337
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
8531
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7359
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6181
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5650
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2754
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1978
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.