aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

JQuery Auto Complete textbox with Images in

Feb 22, 2012

In this article I will explain how to display images with auto complete search in using JQuery.

In previous posts I explained many articles relating to
JQuery. Now I will explain another article relating to JQuery. If we search for user in facebook we will get user name with image. After seen that search I decided to write a post to implement auto complete search with images in
To implement this concept first we need to design table in database to save user and image details in database.

Column Name
Data Type
Allow Nulls
int(set identity property=true)
 After completion table design I am using previous post save images in folder and images path in database using to save user and image details in database. After insertion of user details in database that data would be like this
Now create new website using visual studio and Right click on your website >> select Add New Item >> Select Generic Handler and give name as Search.ashx (Here I am using this name to connect with JQuery. If you want different name then change it in your aspx page also). After that write the following code in generic handler file (Search.ashx
C# Code
<%@ WebHandler Language="C#" Class="Search" %>
using System;
using System.Data.SqlClient;
using System.Text;
using System.Web;
public class Search : IHttpHandler {
public void ProcessRequest (HttpContext context)
string searchText = context.Request.QueryString["q"];
SqlConnection con = new SqlConnection("Data Source=SureshDasari; Integrated Security=true; Initial Catalog=MySampleDB");
SqlCommand cmd = new SqlCommand("select UserId,UserName,ImageName from UserImageDetails where UserName Like @Search + '%'", con);
StringBuilder sb = new StringBuilder();
using(SqlDataReader dr=cmd.ExecuteReader())
public bool IsReusable
return false;
If you observe above code this http handler accepts request from JQuery in a Query string parameter “q”. By passing query string parameter as search text and get user details based on that search text.
<%@ WebHandler Language="VB" Class="Search" %>

Imports System.Data.SqlClient
Imports System.Text
Imports System.Web

Public Class Search
Implements IHttpHandler

Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
Dim searchText As String = context.Request.QueryString("q")
Dim con As New SqlConnection("Data Source=SureshDasari; Integrated Security=true; Initial Catalog=MySampleDB")
Dim cmd As New SqlCommand("select UserId,UserName,ImageName from UserImageDetails where UserName Like @Search + '%'", con)
cmd.Parameters.AddWithValue("@Search", searchText)
Dim sb As New StringBuilder()
Using dr As SqlDataReader = cmd.ExecuteReader()
While dr.Read()
sb.Append(String.Format("{0},{1}{2}", dr("UserName"), dr("ImageName"), Environment.NewLine))
End While
End Using
End Sub

Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable
Return False
End Get
End Property
End Class
After completion of write code in HttpHandler add following code in your aspx page
<html xmlns="">
<head runat="server">
<title>Untitled Page</title>
<link href="css/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$("#<%=txtSearch.ClientID%>").autocomplete("Search.ashx", {
width: 200,
formatItem: function(data, i, n, value) {
return "<img style = 'width:50px;height:50px' src= Images/" + value.split(",")[1] + "'/> " + value.split(",")[0];
formatResult: function(data, value) {
return value.split(",")[0];
<form id="form1" runat="server">
<asp:TextBox ID="txtSearch" runat="server" Width = "195"></asp:TextBox>
If you observe above code in header section I added some of script and css files by using those files we have a chance to display auto complete text with images. To get those files download attached sample code and use it in your application.

Another thing here we need to know is script function in header section

Here I given textbox control id and path of handler by using these details we will display auto complete with images for particular textbox.

Now run your application check the output that would be like this  


Download sample code attached


If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Anonymous said...

thanks Suuresh I am waiting for this code
Thanks Thanks Thanks ..................

Sam said...

Smart one....

sami said...

soopar mama.....

Anonymous said...

Dear Sir
i am facing some problem JQuery AutoComplete Image Search(my image not display but name is display)

Suresh Dasari said...

i hope that problem because of your not giving correct Images folder path whether your application contains Images or not .If you observe this line in header section img style = 'width:50px;height:50px' src= Images/" + value.split(",")[1] + "'
Here i given src path from Images folder please check it once whether you given images path correctly or not.

Mohan Krishna said...

ok sir,but iwant retrive the image from the database binary format

please help me sir

Priya said...

How to add chat window in my webpage using with c#??? plz help me......

ketan said...

i have some problem for this code

error message is: "Microsoft JScript runtime error: 'null' is null or not an object"

give me solution... plz... mail on :

Anonymous said...


rajesh said...

thanks sir to provide smart search but i want to display image or name to link(hyperlink or linkbutton) provide by any on (name or image) is it possible please give reply me sir...i am waiting.......

Bharat Gunjal said...

Hi i also want add chat system in my website....plz help me...i search a lot but i didnt get any plz help me.

u can also send me any reference on my email :

thnks in advance.

Abhay Jha said...

Hi suresh, code is very useful. but i facing one problem. i want retrieve user id also for print on label. how is it possible..

Thanks in Advance
Abhay Jha

Unknown said...

Mr. Suresh ... Please ...

At the first: thanks so much for this useful code and project

now .. when I search for any name in the database then select the specific name ... this name will appear in the "txtSearch" ... right?
OK now now I created another textbox called "TextBox1" and I need when I choose the specific name at txtSearch ... then TextBox1 will appear the image page which is related to txtSearch ... so when I select name in txtSearh the image name will appear in TextBox1 ...
please help me ... I tried to modify scrip tag but I can't ...

Hemant Sharma said...

hi Suresh,
first of all thanks for this useful code.

But i am using this functionality on a page which has a master page in c#. in case of master page, it is not working. please provide me a solution to work on pages which has master page.

please give me reply soon

udham Singh said...

Hi suresh, code is very useful. but i facing one problem. i want retrieve user id and store in hidden field. how is it possible..

Please reply asap.

Thanks in Advance
udham singh

Suresh Dasari said...

@udham singh...
Check this article

Anonymous said...

In this same code how should i get userid pls help me and i checked the above article using webmethod but i dont want that the handler page itself how to get userid ......thanks in advance

pet study said...

thank you

Unknown said...

Hi Suresh sir...
You are my problem solving dictionary....

Anonymous said...

raju m tukadiya hello sir .... i create same as facebook but how to open notification windwn message windown plzzzzz plz give me coad this software releatend

D.K. THEBOSS said...

image was show but not visible it show cross sign

D.K. THEBOSS said...

image are show cross sign

Unknown said...

image are show cross sign SAME Errror for me .Clear tis Suresh

Sukanta said...

but how do we use that search in master page

Sukanta said...

actually i am using a search textbox in master i want to display name with image on search. above code running correct in simple aspx page but in master page.
can any one give me solutions for it.


Anonymous said...

img style = 'width:50px;height:50px' src= 'photo/" + value.split(",")[1]

apply img this code.Then image will appear......
a small colon(') missed in that code.


sir this code gives error that " COULD NOT CREATE TYPE AUTOCOMPLETE " plz solve this error sir . i am stuck on this

Unknown said...

Nce Sir Ji.......

Explain React said...

i am facing some problem JQuery AutoComplete Image Search(my image not display but name is display), even i have written the correct name of images folder...

Unknown said...

Hi Suresh
Replace this Line . Because we didnt get image from Folder Path You Missed the Colon(,) after (src)

Hi all Use Below code

img style = 'width:50px;height:50px' src= 'Images/"

Unknown said...

Dear Sir, Why you used Generic Handler for this....???

Unknown said...

Auto Complete in comboBox like in window base application .plz help me .

Hardik Bhavsar said...

when you click on selected search text then how to redierect on another page using this code.

Anonymous said...

This is awesome. I want to know that after showing suggestions in the list if user clicks on ""SureshDasari" How will it open Suresh Dasari's profile?

aman said...

to display image...
replace this code src= Images/" + value.split(",")[1] + "'/>
by this src= '" + value.split(",")[1] + "'/>

aman said...

nice article sir...but if entered value in textbox ,doesn't match with database then show "Record does not found". i have tried whole day but i could not ......sir plzz help's urgennt...
nothing is working inside he handler...

Unknown said...

thanks for the help :) it worked :D :D :D

vcecseb said...

My images are stored in binary format ,then how can i retrieve images in textbox

Unknown said...

It is working fine in simple aspx page but how to work it in Master Pages..please reponse if any solution

Santhosh said...

Thanks for the post, it working for for me. But it showing only 10 names as output can u help me to get all the names the css.

Today News said...

iam use it but how to link photo when click open result

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.