Solved

DropDownList assistance

Posted on 2013-12-03
4
356 Views
Last Modified: 2013-12-05
I'm developing a utility for my company in ASP.Net/VB.Net and I need the page to have auto-complete style DropDownList...  Unfortunately when you click on the DropDownList I've added on the webpage it doesn't allow typing entry to simplify search.  I'm loading the DD via a code based ADO-Teradata query into the DropDownList.  I've searched and found a few C# options and Jquery but they seem very involved for something I think should be simple.  Isn't there a control or something that should allow for ease of item location?  Thanks for any assistance!
0
Comment
Question by:EDW_Gideon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 27

Accepted Solution

by:
Chinmay Patel earned 250 total points
ID: 39695089
There are two answers, if you are comfortable with ASP.net AJAX toolkit, you can check out this link:
http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/autocomplete/autocomplete.aspx

if you want to build it from scratch(that's not tough either) you can follow this article and replace

    public string[] FindName(string prefixText, int count) 
    {        
        //return all records whose Title starts with the prefix input string         
        List<string> titleArList = new List<string>();         
        SqlDataReader drProducts = sqlProductProvider.GetNameList(prefixText);         
        while (drProducts.Read()) {            
            string strTemp = Convert.ToString(drProducts("Name")); 
            titleArList.Add(strTemp); 
        }   
        return titleArList.ToArray(); 
    } 

Open in new window


with appropriate code.

http://www.c-sharpcorner.com/uploadfile/raj1979/auto-complete-in-Asp-Net-using-ajax/
0
 
LVL 28

Assisted Solution

by:sybe
sybe earned 250 total points
ID: 39695153
Actually a regular dropdown will respond to letters entered and as such have a form of autocomplete.

Just try in out, focus on a large dropdown in your browser (sopmething like a country list) and start typing some letters....
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question