5,693,936 members and growing! (16,712 online)
Email Password   helpLost your password?
Web Development » Ajax and Atlas » Controls     Intermediate

AJAX AutoComplete/AutoSuggest TextBox

By Cassio Mosqueira

An article on AJAX AutoSuggest control
C#, Javascript, XML, HTML, Windows, .NET, Visual Studio, Ajax, Dev

Posted: 23 Jan 2007
Updated: 2 Oct 2007
Views: 152,402
Bookmarked: 88 times
Announcements
Loading...



Search    
Advanced Search
Sitemap
35 votes for this Article.
Popularity: 7.32 Rating: 4.74 out of 5
0 votes, 0.0%
1
1 vote, 2.9%
2
0 votes, 0.0%
3
3 votes, 8.6%
4
31 votes, 88.6%
5
Sample Image - maximum width is 600 pixels

Introduction

This is an AJAX AutoSuggest ASP.NET textbox I've created a while ago. It is built on top of the Anthem.NET library.

Background

When building enterprise web applications, we often need to let the user select one item from a large list of records. For instance, on an order entry form, the user must be able to select the customer from a large list of customers. For performance reasons, it would be insane to just load a DropDownList with 50000 items. The other alternative would be to open another form where the user would be able to search and select the desired customer. I've used this approach before, but the users usually found it very annoying and were constantly demanding a better solution.

Solution

The AJAX boom made it an easy problem to solve. An AutoSuggest textbox, where the user would type a part of the desired customer name and the control would show the matches, would fit perfectly here. Yet, I couldn't find one that would completely fill my needs. I needed an AutoSuggest textbox with the following features:

  • Built-in validation
  • Template-based content
  • Ability to bind to all sorts of objects (collection, datatables, etc)
  • Ability to work like a DropDownList
  • Smooth integration with Anthem.NET
  • Ability to show a header
  • No need to call webservices

The Control

This custom control is based on the Anthem library. I decided to use Anthem because at that time I was already using it on my projects. The Atlas Project was not mature enough and Anthem seemed much easier and more powerful. The Anthem library now has an official AutoSuggest control, but I haven't checked it out yet. If you are not familiar with Anthem.NET yet, I encourage you to check it out. It's pretty simple and works great. The JavaScript OO model was based on another free AutoSuggest control that I found on this web site. I found it pretty nice, but it was missing some functionality I needed.

Setting Up

To use this AutoSuggest control, you will need to reference both the Anthem.dll and Anthem.AutoSuggest.dll in your project. The download contains these DLLs, the AutoSuggest source code and an example project source code.

Using the Code

The first thing you need to do is to add the control to your page. This can be done through drag and drop or by writing the tags directly into the ASPX source file. Since I didn't add any relevant design-time support, I think you'd better stick with the ASPX source code. In this example we are using the AutoSuggest control to display the names of various bands and the user must select his favorite one.

<Anthem:AutoSuggestBox runat="server" 
    ID="asbFavoriteBand" DataKeyField="ID" 
    TextBoxDisplayField="Name" AutoCallBack="true" 
    ItemNotFoundMessage="Item not found!" >
    <itemtemplate>
        <%# ((Band)Container.DataItem).Name %>
    </ItemTemplate>
</Anthem:AutoSuggestBox>

I think most of the property names are self-explanatory. I encourage you to go through the properties and play with them. For those unfamiliar with the Anthem.NET library, the AutoCallBack attribute tells that after the selected value has changed, the control will trigger a callback to the server. It's equivalent to the AutoPostBack property of the regular ASP.NET controls. Notice that you can use the ItemTemplate in the same manner in which you use it with the Repeater, DataList or DataGrid controls. The DataKeyField property tells the control which field it will use to set the SelectedValue property.

After adding the control to the page, you should set up the event handlers. The most important event you should handle is the TextChanged event. This is where you are going to fill the suggested list. Another important event is the SelectedValueChanged. This event is fired whenever you change the current value. To wire up these handlers, you can write the following code in the OnInit method:

protected override void OnInit(EventArgs e)
{
    base.OnInit(e);
    this.asbFavoriteBand.TextChanged += 
        new Anthem.AutoSuggestBox.TextChangedEventHandler(
        asbFavoriteBand_TextChanged);

    this.asbFavoriteBand.SelectedValueChanged += 
        new Anthem.AutoSuggestBox.SelectedValueChangedHandler(
        asbFavoriteBand_SelectedValueChanged);
}

Here's the code to handle the TextChanged event:

void asbFavoriteBand_TextChanged(object source, 
        Anthem.AutoSuggestEventArgs e)
{
    //Creates a dataview from a datatable

    DataView dv = new DataView(_dtBands);

    //Filters the datatable based on the CurrentText property

    dv.RowFilter = string.Format("BandName LIKE '%{0}%'", e.CurrentText);

    //Sets the dataview as the control's datasource

    asbFavoriteBand.DataSource = dv;
    asbFavoriteBand.DataBind();
}

In the snippet above, you can use any data source on the AutoSuggest control. Usually you would query the database for the result set. It's when you call the DataBind method that the suggested list appears on the screen.

Points of Interest

There are, definitely, some nice aspects of this control that demand a closer look at how .NET controls work, like using embedded web resources (images, JavaScript and CSS files), supporting template based content, triggering events and handling the JavaScript integration.

Object-Oriented JavaScript is also worth a look. It really makes things easier.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Cassio Mosqueira


I've been developing .NET enterprise applications since 2002.

I am originally from Rio de Janeiro and I am currently working as a developer for Sales Resource Group in Oakville, Ontario.

I'm vegetarian and I like surfing and listening to progressive metal bands like Dream Theater and Pain of Salvation.

Check out my blog!

Occupation: Web Developer
Location: Brazil Brazil

Other popular Ajax and Atlas articles:

Article Top
Sign Up to vote for this article
You must Sign In to use this message board.
FAQ FAQ Noise ToleranceSearch Search Messages 
 Layout  Per page   
 Msgs 1 to 25 of 186 (Total in Forum: 186) (Refresh)FirstPrevNext
GeneralEvent SelectedValueChanged does only raise when clicking with mousememberd00_ape3:35 8 Nov '08  
GeneralOnly fill value when click on item!memberhapytran23:38 5 Nov '08  
GeneralAny suggestion to how to hide the suggestions box when the text has changedmemberthomasa6:10 5 Nov '08  
GeneralVS 2003 doesn't allow me to add these dll's :(memberVenkata Siva15:13 20 Oct '08  
GeneralRe: VS 2003 doesn't allow me to add these dll's :(memberCassio Mosqueira17:03 20 Oct '08  
GeneralNice!memberJasonC726:18 13 Oct '08  
Generalhow can I use a mysql database in this sample?memberjason_wang1122:19 3 Oct '08  
GeneralHow can I find get a control inside HeaderTemplate?membermoufis12:08 1 Jul '08  
GeneralCouldnt load controlmemberairbase4:48 24 Jun '08  
QuestionLinking within the autocompletememberddoug239:12 23 Jun '08  
AnswerRe: Linking within the autocompletememberlaoyingisme1:23 25 Jun '08  
GeneralRe: Linking within the autocompletememberddoug233:04 25 Jun '08  
QuestionI find a small bug [modified]memberlaoyingisme18:36 11 Jun '08  
GeneralSetting another control based on this control problemmemberStonkers13:22 4 Jun '08  
GeneralRe: Setting another control based on this control problemmemberStonkers6:31 5 Jun '08  
QuestionUsing Database table instead of Static datatablememberGiveDcode2:48 9 Apr '08  
AnswerRe: Using Database table instead of Static datatablememberlaoyingisme18:15 11 Jun '08  
QuestionBug Autosuggest projectmembersameer_wanwey21:26 25 Mar '08  
GeneralCalling a client side function upon SelectedValueChangememberMember 189180212:44 24 Mar '08  
GeneralAutosuggest selecting with arrow and enter key fixmembertmrhymer8:26 12 Mar '08  
GeneralProblem with spacememberPrithwish Biswas5:50 6 Mar '08  
Generaltwo autosuggest in one pagememberpn_renju2:21 22 Feb '08  
AnswerRe: two autosuggest in one pagemembersaro_ja8:40 25 Feb '08  
Question"'JSAutoSuggestBox' is undefined". Java script errormembersaro_ja8:54 19 Feb '08  
GeneralOnFocus of Autosuggestmembertmrhymer9:32 3 Jan '08  

General General    News News    Question Question    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

PermaLink | Privacy | Terms of Use
Last Updated: 2 Oct 2007
Editor: Deeksha Shenoy
Copyright 2007 by Cassio Mosqueira
Everything else Copyright © CodeProject, 1999-2008
Web08 | Advertise on the Code Project