Click here to Skip to main content
13,554,833 members
Click here to Skip to main content
Add your own
alternative version


24 bookmarked
Posted 8 Apr 2011
Licenced CPOL

JQuery + ASP.NET auto complete without web service

, 9 Apr 2011
Rate this:
Please Sign up or sign in to vote.
JQuery + ASP.NET auto complete without web service
Ever thought of creating an auto complete that interact with Database/Data source in ASP.NET and wonder how you going to do it? Well, the answer is simple, you need a web service, right? Wrong!

In this article, I will explain how to create auto complete functionality in ASP.NET JQuery without using a web service.

First, let's make a list of things we are going to use:
1. Jquery Library
2. XML File(Data source)
3. ASP.NET Page

Let's get started.

In Visual Studio, create a web site/ web Application and then create two folders to put the JQuery Library and Css files. Create .aspx file and then add the code in the code behind. All I do in this code is simply read the XML file and then load it to the dataset (you can use xPath to manipulate xml data, I just happen to prefer using dataset.)
Here is my Code:

protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
            XmlDocument xDoc = new XmlDocument();
            DataSet ds = new DataSet();
            XmlNodeReader xnr = new XmlNodeReader(xDoc);
            foreach (DataRow _row in ds.Tables["Customers"].Rows)
                ClientScript.RegisterArrayDeclaration("ListItems", "\"" + _row["ContactName"].ToString() + "\"");

This is a simple straight forward code, but it's important to note the Clientscript.RegisterArrayDeclaration which creates a JavaScript Array. We then Access the Array using Jquery like this:

$(function () {
               source: ListItems

Just few things I need to explain.
  1. Autocomplete expects an Array, so we create this in C#, so you can replace the XML with your Database source and you will be able to create an Array for the Autocomplete.
  2. The Array name is the name you passed in the

    It must exist in runtime for you code to execute correctly.

Now your Autocomplete should be working!

Please feel free to correct me where I am wrong as I am still learning....


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer Supergroup
South Africa South Africa
No Biography provided

You may also be interested in...

Comments and Discussions

GeneralHi Guys Sorry for responding to the questions months after ... Pin
Seabata16-Nov-11 2:43
memberSeabata16-Nov-11 2:43 
Generalwhat if on the other hand anybody adds a new customer into t... Pin
Member 174238114-Nov-11 0:23
memberMember 174238114-Nov-11 0:23 
GeneralRe: what if on the other hand anybody adds a new customer into t... Pin
Seabata19-Jun-12 21:51
memberSeabata19-Jun-12 21:51 
GeneralI tried auto complete with 1.Webservice 2.Handler 3.Jquery ... Pin
jpratik19-Apr-11 4:45
memberjpratik19-Apr-11 4:45 
GeneralGreat short solution. Keep up the good work! Pin
Member 414818817-Apr-11 19:28
memberMember 414818817-Apr-11 19:28 
GeneralExcellent Tip. Keep it up Pin
Wonde Tadesse15-Apr-11 5:04
memberWonde Tadesse15-Apr-11 5:04 
GeneralReason for my vote of 5 Nice Way!! Pin
Gandalf - The White11-Apr-11 22:56
memberGandalf - The White11-Apr-11 22:56 
GeneralYou can create Handlers in place of webservice if you had an... Pin
code in play11-Apr-11 22:10
membercode in play11-Apr-11 22:10 
GeneralReason for my vote of 5 nice Pin
code in play11-Apr-11 22:08
membercode in play11-Apr-11 22:08 
QuestionAny complete code sample? Pin
very-old-timer16-Oct-11 2:34
membervery-old-timer16-Oct-11 2:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01-2016 | 2.8.180515.1 | Last Updated 9 Apr 2011
Article Copyright 2011 by Seabata
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid