AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 AutoComplete From Database
Posted by Moderator1 on 6/11/2007 10:54:58 AM Category: AJAX
Total Views : 241174
Add to my favorites
Email to friend
  
Introduction
This article explains to fill a AutoComplete Textbox from the data fetched from database.
Description
Everyone knows about the AutoComplete Textbox. It is an ASP.NET AJAX extender that can be attached to any TextBox control. When the user types some letters in the Textbox, a popup panel will come to action and displayed the related words. So that the user can choose exact word from the popup panel. Here I tried to explain how this AutoComplete fetches data from the database through a Webservice.
Open Microsoft Visual Studio, click on New Website. Then choose ASP.NET Ajax Enabled Website and change the location to point your http://localhost/AutoComplete folder. Obviously, Default.aspx is added to your solution explorer.

Now drag and drop a Textbox from your Toolbox. Then drag and drop a ScriptManager and AutoCompleteExtender to your Default.aspx page. Then add a webservice to your project as WebService.asmx. First thing you have to do is to add the ScriptService reference to the webserive as follows.
[System.Web.Script.Services.ScriptService]
Now, write a webmethod ‘GetCountryInfo’ to fetch the data from the country table as follows
[WebMethod]
public string[] GetCountryInfo(string prefixText)
{
 int count = 10;
 string sql = "Select * from Country Where Country_Name like @prefixText";
 SqlDataAdapter da = new SqlDataAdapter(sql,”Your Connection String Comes Here”));
 da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText+ "%";
 DataTable dt = new DataTable();
 da.Fill(dt);
 string[] items = new string[dt.Rows.Count];
 int i = 0;
 foreach (DataRow dr in dt.Rows)
 {
  items.SetValue(dr["Country_Name"].ToString(),i);
  i++;
 }
 return items;
}
The above webmethod takes prefixText as argument, sends it to the query to fetch only the related words that starts with the prefixText values. Then it returns the result as an array of strings.

Next, in the Default.aspx page, set the AutoCompleteExtender’s TargetControlID property to the TextBox Id. Now you can see a new Extenders Tab is added in the Textbox’s Property window. Set ServicePath as WebService.asmx, ServiceMethod as GetCountryInfo and MinimimPrefixLength as 1.
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" MinimumPrefixLength="1" ServiceMethod="GetCountryInfo" ServicePath="WebService.asmx" TargetControlID="TextBox1"> </cc1:AutoCompleteExtender>
Now, its time to run the project. Select the Default.aspx and click on View in Browser. You can see the excellent application starts to run. Type your country’s first letter. See all the countries starts with that letter will appear in the popup.

Else if you would like to see the application, it is just below.. 

Enter Your Country :
Viewer's Comments
Posted by Excellent on 7/1/2007 11:54:12 PM
Thanks a ton man, I couldn't find the correct parameter to get the textbox value to my webservice. Appreciate it. Tim
 
Posted by G on 7/24/2007 1:39:12 PM
Do you know if there are any issues with implementing the same logic for an oracle back end ? (I am trying to fill it a text box using oracle client library fetching results in a data set using stored procedures)
 
Posted by c on 7/27/2007 2:24:05 AM
This is a good article. it helps to use autocomplete extender for text box.
 
Posted by Uma Ramiya on 8/27/2007 4:15:12 AM
Ajax Control AutoCompleteExtender is missing in my .Net framework Components. How to go about it
 
Posted by Alan on 8/27/2007 4:14:42 PM
Uma: I had to download from the link below, and added the AjaxControlToolKit.DLL to my VS 2005 toolbox. http://www.codeplex.com/AtlasControlToolkit/Release/ProjectReleases.aspx?ReleaseId=1425 For some reason this is not included with the Microsoft Ajax release, not clear why.
 
Posted by Shankar on 9/27/2007 4:23:02 AM
This is a good article. it helps to use autocomplete extender for text box at the right time. Thanks Dear
 
Posted by Bhargavi on 10/10/2007 2:19:30 AM
I did all the steps given here. I had declared a static dataset and filled with country Name in Page load of Default.aspx. In the Webmethod i do a search in the Dataset DataTable that has been filled already using the "Select" method of a Datatable I add All the results to String Item. But mY autocomplete doesnot work Help Me
 
Posted by naresh on 10/14/2007 5:40:26 PM
Hi, I am getting undefined values in the div. Please help me Thanks In advance
 
Posted by naresh on 10/14/2007 5:41:49 PM
Hi please send me the vb.net code Thanks
 
Posted by ganapathi on 10/15/2007 5:16:45 AM
Nice article
 
Posted by ganapathi on 10/15/2007 7:12:30 AM
Can you send the code of Autocomplete TextBox using C#
 
Posted by nirut on 10/15/2007 10:12:08 PM
Hi please send me the C#.net code Thanks
 
Posted by Mukesh Mishra on 10/20/2007 2:10:03 PM
Please Help me that how can i get AutoCompleteExtender in asp.net... its urgent
 
Posted by jcuney on 10/22/2007 1:25:35 PM
Can you please provide me with the vb.net code?
 
Posted by Nice on 10/23/2007 6:40:01 AM
Nice Article
 
Posted by Milind on 10/25/2007 1:56:22 PM
hi, How do I obtain the country ID of the selected country instead of the name? I would still like to display the name of the country in the textbox howver, be able to access the ID associated with it either from a hidden field or something upon selection? Do you think it's possible do so? thanks
 
Posted by Serdar on 11/18/2007 6:48:29 AM
No VB codes ?
 
Posted by Adamsakli on 11/28/2007 3:10:21 AM
Thank you very.you are wonderful
 
Posted by Varun Thakur on 11/29/2007 5:12:05 AM
Thank you for giving the solution in such a easy way . I liked the way you present and express the article. Thanx God Bless You
 
Posted by Varun Thakur on 11/29/2007 5:12:18 AM
Thank you for giving the solution in such a easy way . I liked the way you represent and express the article. Thanx God Bless You
 
Posted by rajesh on 12/1/2007 12:52:27 AM
Thank you it help full on my project
 
Posted by rajesh on 12/1/2007 12:53:44 AM
sir, how can i get same thing in vb.net deskop application
 
Posted by rajesh on 12/2/2007 1:07:19 AM
sir, i'm noit able get output in my textbox,my webservice is perfectly working. when i debug services i get XML form on the browser,in aspx page it not shown
 
Posted by Faheem Ahmad on 12/6/2007 1:56:23 AM
Excellent work done. Keep it up to get attention of us. Thanks
 
Posted by ashish on 12/13/2007 5:25:52 AM
can u let me know how do i make one item default selected.
 
Posted by ashish on 12/13/2007 5:26:25 AM
can u let me know how do i make one item default selected.
 
Posted by chee seng on 12/18/2007 12:51:09 AM
hi, thanks for them example, but if it can be in VB codes it will good.
 
Posted by Nicholas on 12/23/2007 4:27:41 AM
Excellent example, I found many examples for AutoComplete Extender but not the ones for use with a database. Thanks.
 
Posted by Evandro on 1/3/2008 11:48:16 AM
My Method works fine, but the autocomplete doesn't work. Could you help me?
 
Posted by Alan on 1/7/2008 11:41:59 PM
How do i do it for Visual Studio 2003
 
Posted by sandeep on 1/11/2008 4:16:34 AM
hi, can any one suggest how can dispaly more than one column in autocomplete Please its very urgent. Thanks in advance
 
Posted by sandeep on 1/11/2008 4:57:10 AM
hi, can any one suggest how can dispaly more than one column in autocomplete Please its very urgent. Thanks in advance
 
Posted by ricardochois on 1/14/2008 3:24:39 PM
Hi, i have varchar codes like 001, 002, 012, and when i enter de digit 0 it returns 1, 2, 12. it is removing the zeros, what can i do????
 
Posted by Varsha Aruja on 1/22/2008 8:27:20 AM
Hi i go through your code,it doesn't giving me any errors so my assumption is Everything was fine,But it also doesn't giving me any output.why this is so? Should i able to Debug the web-service method? here is my code. Public Function GetCompletionList(ByVal prefixText As String) As String() Dim sString As String = "User Id=SYSTEM;Password=manager;Data Source=SoilTest;" Dim strCon As New OracleConnection(sString) Dim strArray(10) As String Dim dt As N
 
Posted by Lucy on 1/25/2008 1:42:39 AM
Hi, Nice aritcle.I got the result.
 
Posted by badari on 1/28/2008 4:04:06 AM
hw to add scriptservices to my application
 
Posted by konda reddy on 2/5/2008 4:51:32 AM
my webservice working fine ,but application is not working(autocomplete textbox) how to send parameter to web method
 
Posted by konda reddy on 2/5/2008 4:52:45 AM
it's urgent plz
 
Posted by konda reddy on 2/5/2008 4:54:19 AM
upto scritp.services only i got as a reference
 
Posted by konda reddy on 2/5/2008 4:54:24 AM
upto scritpt.services only i got as a reference
 
Posted by konda reddy on 2/5/2008 4:54:25 AM
upto scritpt.services only i got as a reference
 
Posted by swati on 2/11/2008 12:17:20 AM
Hi... i dont have autocomplete extender component ....i am having AJAX extender.. i do i get it?
 
Posted by jack on 2/13/2008 12:16:39 AM
Hi, can you profile the whole asp.net page. I would greatly appreciated. Thanks in advance
 
Posted by chennuru gangaiah on 2/28/2008 12:26:29 PM
Thanks , it is very nice i got solution i need one more how can we develop like google search page using user control so that we can make use this other website Thanks and Regards, Chennuru Gangaiah
 
Posted by Azee on 3/6/2008 8:26:41 AM
Thanks, thats what i was looking for. Great job.... looking forward to get more article like this.....
 
Posted by Shahzad Ahmad on 3/9/2008 3:42:26 AM
You are rocking man, this article is too short and concise what a beginner need. Thanks Moderator1
 
Posted by bibhuti on 3/14/2008 2:15:19 AM
How do I obtain the country ID of the selected country instead of the name?
 
Posted by Prem on 3/25/2008 8:09:28 AM
i tried a lot but i couldn't create the auto complete extender tool in .net 2.0 , please help me ...urgent need
 
Posted by Krish on 4/1/2008 1:49:14 AM
Really nice article but do you have any idea how to do same thing using page methods rather than web service?
 
Posted by SS on 4/8/2008 8:04:18 AM
How to add reference to a web service i.e, System.Web.Script.Services.ScriptService. Plz let me know ASAP.
 
Posted by Karthikeyan on 4/12/2008 8:52:44 AM
Thanks man.........
 
Posted by Najib on 4/15/2008 11:53:00 AM
hi, this article is very fine and thanks a lot. i have one question. how can i implement this control to my user control. it works fine in the page. but wen i use a user control, it is not working.pls help me ASAP. thank you so much
 
Posted by Namlet on 4/17/2008 4:09:30 PM
I can't get this to work. What does add this: [System.Web.Script.Services.ScriptService] to your webserive mean? I added that line to my webservice.asmx file and it won't compile because of some temporary .cs file that gave this error: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\mod\1f211d0b\9fb6dad0\App_Web_f3q_o5zb.0.cs(10,1): error CS1518: Expected class, delegate, enum, interface, or struct Then I added: using System.Web.Script.Services.ScriptService to the top
 
Posted by Deepa on 4/28/2008 12:50:00 AM
hi ur article was very help full to me , but i also need the id, for eg if i select a country its id should also be displayed. how to do this,can you help me. Thanks
 
Posted by Bùi Công Duy?n on 5/2/2008 10:22:06 PM
Thanks! C?m on!
 
Posted by Fred on 5/12/2008 10:35:46 AM
Does anyone have the c# code? thanks
 
Posted by John Manavalan on 5/23/2008 1:51:29 AM
Very good. Thanks Man.
 
Posted by rajendra on 5/30/2008 2:58:09 AM
hi this is working but u can ServicePath="../WebService.asmx" thanks
 
Posted by Ashwani on 5/30/2008 7:23:53 AM
this is an excellent article. thanks for this article. it helps me a lot.
 
Posted by Seth on 6/2/2008 1:22:27 PM
I am trying to incorporate a web service that was created for me. Is there any documentation on how to incorporate that into the autocomplete ?
 
Posted by Adam on 6/5/2008 1:31:27 PM
I wanted to implement this but in my query I have to meet a few other requirements. Here is the SQL query that I use. SELECT * from Orders where CstNbr = @Cust and OrderNbr =OrderNbr I need to keep the customer nbr static while searching but the order number to do the autocomplete. What is the best way to do that.
 
Posted by Manel on 6/6/2008 11:12:20 AM
Hi it is only possible to do the function with a webservice or it could be done without using a webservice ?
 
Posted by Manel on 6/6/2008 11:12:22 AM
Hi it is only possible to do the function with a webservice or it could be done without using a webservice ?
 
Posted by Mehar on 6/17/2008 6:20:07 AM
Very nice..
 
Posted by TheDirtyBird on 6/20/2008 7:51:57 AM
How is int count = 10; being used?
 
Posted by Rajesh on 6/24/2008 2:48:58 AM
I follow your step but my textbox not autocoplete so pls reply as possible as early
 
Posted by carlos olivera on 6/30/2008 3:16:38 PM
I get a null option in final position of the list, please help me
 
Posted by Excellent on 7/1/2008 2:01:34 AM
thanks genius its a wonderful code. main hai
 
Posted by Fahad Zia on 7/7/2008 7:49:11 PM
Hi, I have an Ajax AutoCompleteExtender control through which I am populating the UserNames. In my AutoComplete Service Method, I am calling my "CallGetUsers" webmethod which invokes a stored procedure and gets all the Users. When i publish my web service i get all the names pertaining to a single last name, however, my application is not getting the list of these names. I am using ASP.NET 2.0 and C#.
 
Posted by Yuting on 7/9/2008 10:07:58 AM
Hi, can you please email me this code in VB? it will save my project. Thanks in advance...
 
Posted by Maheswari on 7/10/2008 9:57:58 PM
Hi, Its very useful. Thanks... Hi All, Answer for the people who are finding difficult to add reference "System.Web.Script.Services.ScriptService" U dont need to add using System.Web.Script.Services.ScriptService Just write [System.Web.Script.Services.ScriptService] under other references. That's it... And if you add AjaxToolkit reference you will get AutoComplete extender. You dont need to drag and drop. Just in source paste this
 
Posted by Prcsalm on 7/15/2008 3:52:12 PM
Hi, i tried the code with MySql data base, i had some difficulties in the begining but i solved the problème. in fact no data was retrived from DB cause i had't set welle my connectionstring data base. the little mozilla plugin "Fire Debug" helped me a lot. I was able to detect the post and the get of all the request throw my local server and point right to the problem. I hope that would help you. good luck.
 
Posted by gopi on 7/21/2008 5:56:57 AM
Hi Anyone help me, how to capture the country code, in the text box showing country name and hidden control store the country code, how can achive this. please guide me. thanks gopi
 
Posted by deepak on 7/28/2008 6:57:50 AM
Hi Anyone help me, how to capture the country code, in the text box showing country name and hidden control store the country code, how can achive this. please guide me. thanks
 
Posted by mayank on 8/7/2008 4:52:07 AM
Hello every one can anyone suggest me how to filter particular column data in cache data table? I am using same code in my application
 
Posted by Avinash on 8/11/2008 7:41:57 AM
can u provide me the asp.net with .vb coding, instead of .cs extending coding to auto-suggest exactly for this. And i tried to implemented the Ajax Control Toolkit by downloading but i can't clear with auto extender. kindly help me with this. Thanks in advance..
 
Posted by Deepesh on 8/21/2008 3:18:33 AM
Hi, This is great article, just need a help. When i put "I ", space the autocomplete does not work. Is there any work around for that ?
 
Posted by Varun B M on 8/27/2008 4:40:52 AM
HI..i followed ur steps..bt itz nt working..i did one small change..i used mysql connection instead of sql....wat to do...??
 
Posted by Varun B M on 8/27/2008 4:41:05 AM
HI..i followed ur steps..bt itz nt working..i did one small change..i used mysql connection instead of sql....wat to do...??
 
Posted by Ehtesham on 9/1/2008 4:59:17 AM
Can you send me code. Thanks
 
Posted by bindesh agrawal on 9/4/2008 12:46:10 AM
problem in searching ..when column datatype is varchar and some values in the column is numeric like(010101) then searchlist shows undefined...
 
Posted by Jo on 9/16/2008 1:21:12 PM
Can you send me all project with C# code. Where need add the [System.Web.Script.Services.ScriptService] Thanks
 
Posted by mahadev Kurade on 9/17/2008 2:44:49 AM
autocomleteextender not working in master pages.. please suggest solution for that or send me code for that.. thanx in advance..
 
Posted by Saravana on 9/20/2008 12:10:33 AM
Can you send me code. Thanks
 
Posted by shankar on 9/21/2008 1:14:56 AM
you are the best.Article is excellent
 
Posted by shankar on 9/21/2008 1:19:10 AM
i have to wait for a second after typing the letter in my textbox to get the result,in your case it's pretty fast .plz let me know how do i do that,i have done the way u mentioned above .it work pretty well only issue is it's slow i have to wait after typing the word in the text box plz let me know Thanks in advance
 
Posted by dheeru on 9/24/2008 5:19:23 AM
thanks for your article can u let me know why u intialised count=10 and also for me it is not listing down in the textbox but from that method i am getting data.So is there any thing i have to add rather than this.please help me out tHANKS IN ADVANCE
 
Posted by anyone on 9/25/2008 11:02:00 AM
Nice article. It'd be better if you reply to comments too.
 
Posted by Petulka77 on 9/26/2008 12:56:24 PM
To everybody how runs it without error and still cant get it work: I just found that if in your webmethod have a diffrent argument's name than "prefixText" - it doesn't work!!!. You have to name it exactly: "prefixText". What a limitation!!! It would be nice to mention it in the article. I hope this helps.
 
Posted by goog guy on 10/8/2008 6:15:42 AM
What if parameter have to pass that comes from the database . you should give example about that also. It is a request.
 
Posted by marko on 10/19/2008 9:52:50 AM
you forgot using System.Configuration; using System.Data; using System.Data.SqlClient; and then you can do this: string connstring = ConfigurationManager.ConnectionStrings["CONNECTIONSTRING_NAME"].ConnectionString; REPLACE: SqlDataAdapter da = new SqlDataAdapter(sql,”Your Connection String Comes Here”)); WITH THIS: SqlDataAdapter da = new SqlDataAdapter(sql,”connString”)); this is never used and can be removed: //int count = 10;
 
Posted by Shanmuganand on 10/23/2008 2:02:44 AM
Its a great code..very simple and effective..can anyone suggest me...that can the same auto complete be done without using webservice ... ie in the .aspx page itself can we bind it with data base
 
Posted by soniya on 10/24/2008 1:56:41 AM
Thank you very much.
 
Posted by Sunesh S Nair on 10/24/2008 3:15:17 AM
Hi There! This requirement comes up very frequently in Web Applications.Really a nice way to achieve it.Helped me as well.Well Explained and presented in simplest way.
 
Posted by santhosh on 11/3/2008 3:59:04 AM
can i know how to tab out from current page to next page when an item is selected from the AutoCompleteExtender
 
Posted by Rakhi on 11/20/2008 5:09:55 AM
i had followed the steps specified by u..... but my autoextender is not working the country name are not displayed in the textbox
 
Posted by Rahul Sarkar on 11/28/2008 12:36:25 AM
Thanks boss. it's nice code and very usefull for me
 
Posted by sunil on 11/28/2008 1:53:37 AM
I really appreciate ur article. i used the tool in the same way u told.but i'm not gettting any thing.wen i enter a letter it is not showing anything.can u help me out.
 
Posted by srinivas on 12/1/2008 3:17:50 AM
gud article. i have small doubt in this. can u fetch the respective cities of selected country without posting back the page.
 
Posted by Archana on 12/16/2008 6:59:32 AM
Hi , Nice article but i have a question regarding this .. while we r using autocomplete extender with database it shows the result very slowly the user has to wait to see the result Is there any way aroud it ..Please suggest Thanks n Regards, Archana.
 
Posted by SA on 12/18/2008 9:04:42 AM
Hi, AutoCompleteExtender is not working in iis 7.0 and Windows Server 2008/ Vista. Is there anything we need to write in we.config for web service.
 
Posted by AnilM on 1/2/2009 2:34:56 AM
Hi, This is working in the Webroot directory. If I need to implement this in multiple directories, do I need to copy and paste the WebService or only just reference the file path? Thanks Anil
 
Posted by varun on 1/6/2009 12:09:43 PM
Thank's alot for that code....
 
Posted by syc on 1/6/2009 7:13:34 PM
nice thanks dude!
 
Posted by Parin on 1/7/2009 1:01:07 AM
Tnx a Lot... It really Hellped.... though I still have a question... how can we separate two searches with comma(,)....
 
Posted by koti on 1/27/2009 5:36:29 AM
Thank's a lot... Could you send me this code sir
 
Posted by ss on 2/4/2009 4:06:23 PM
http://www.webresourcesdepot.com
 
Posted by ss on 2/4/2009 4:07:28 PM
http://www.webresourcesdepot.com
 
Posted by ss on 2/4/2009 4:08:18 PM
http://www.google.com ssss
 
Posted by Matt on 2/12/2009 3:46:33 AM
My god there are some stupid people posting here. Can you send me C# example? ITS IN C#! I wouldn't trust some of you with a plastic fork! Nice article btw.
 
Posted by Ktmu on 2/17/2009 10:56:11 AM
Thanks a lot
 
Posted by Danish on 2/24/2009 8:00:33 AM
HI, How can i make the code with store procedure how i will call store procedure. Thanks with best regards,
 
Posted by sapan on 2/25/2009 4:38:14 AM
does any one have code to save webpage as word document?
 
Posted by Ted Porter on 2/25/2009 11:13:23 AM
Hi, Nice clear, easy to understand example - 10 out of 10
 
Posted by kavitha on 2/26/2009 3:42:57 AM
Hi friend, AutoComplete From Database article is very useful to me.Thanks a lot. By Kavitha
 
Posted by Michae on 3/8/2009 10:34:55 AM
please i want to know if there is any c# code i will write it in the page_load of any other textbox events
 
Posted by josey on 3/12/2009 1:44:21 AM
can i use ajax AutoCompleteExtender( for asp.net ) with out using webservies
 
Posted by steve on 3/14/2009 12:31:56 AM
nice.. thanks - that helped a lot. You can also see a nice way to use Linq instead of sql here: http://aspguy.wordpress.com/2008/09/28/linqdatasource-with-select-method/#comments
 
Posted by Ankit on 3/14/2009 10:35:21 AM
It's not working for me. I agree that you give a nice & simple explanation but I need complete code or project. please provide me
 
Posted by dhanya on 3/22/2009 9:25:12 AM
thanxs for this excellent code.Where need to add the [System.Web.Script.Services.ScriptService]
 
Posted by Giridhar on 3/23/2009 9:19:29 AM
hi, I have added multiple autocomplete extenders in the page at the run time which are placed in different section which are in collapsible panels. Each collapsible panel contains two auto complete extenders. when the page is loaded i am getting an error from the java script alert box "invalid character". Please try to throw some light. Thanks Giridhar
 
Posted by amir hossein akbari on 3/24/2009 8:44:59 AM
i use it and very thanks .i'm pleasure for this.
 
Posted by os_os on 4/6/2009 8:24:02 AM
the example is not working... it got run but no values populated in the texbox... knowing i have modified it according to my database with string connection and command... pls anyone can feed me back regarding this .. i am urgent ... Thanks in advance
 
Posted by Muthu on 4/9/2009 1:41:54 AM
This is excellent
 
Posted by jahir on 4/10/2009 8:38:25 AM
No question. But much helpfull that i expect. Thanks a lot
 
Posted by suguna on 4/13/2009 1:25:47 AM
Hi, This is great article, just need a help. When i put "I ", space the autocomplete does not work. Is there any work around for that ?
 
Posted by Hariom thakur on 4/13/2009 4:43:33 AM
this is fabouls article .it's working frequently.thnx for this nice article.keep it up .
 
Posted by Renuga on 4/23/2009 2:23:50 AM
Very helpful...Thanks a lot.
 
Posted by vivek j s on 4/27/2009 9:12:32 AM
Plz send me code for autocompleted dropdown box in Ajex with Php and Mysql
 
Posted by topaz on 4/29/2009 4:19:59 AM
Thanks a lot....
 
Posted by Aman on 4/29/2009 11:27:01 AM
Yeah It worked for a single text box, when I added second textbox and added web method for second textbox and also changed the service method, Its not working for the second text box. What modifications do I need to do to add auto complete feature to second textbox too
 
Posted by jonathan on 5/1/2009 11:31:33 PM
hi everyone.... i have a webservice like this tutorial on a server... but i dont know how i put a this textbox in other asp.net with the funcionality please somebady tell me how to make it!!!!!!!!!!!!!!!!!!
 
Posted by Herry on 5/5/2009 5:47:37 AM
I have question Regarding Autocomplete Ajax control. for the first time if i search country from the textbox i.e in... so list of words are display starting from in but after rempve in from the textbox and if search another word than nothing to be come in to searchlist.. its postback problem bt how is it use i dont know so pls any one know than let me inform. Thanks..
 
Posted by Shan on 5/9/2009 4:48:39 PM
how can make multi list with autocomplete and also show image from database like facebook autocomplete
 
Posted by Hemant on 5/11/2009 3:21:22 AM
Thanks Dude,keep on helping the .Net world.
 
Posted by pravin gare on 5/12/2009 6:23:46 AM
Is this possible to use without webservice?
 
Posted by Sanjay on 5/14/2009 4:12:37 PM
Thanks this worked perfectly the frist time. The actual search runs a little slow on my vista though..
 
Posted by krishna on 5/15/2009 9:12:54 AM
Hi, Could you someone help me out . I have to pass another ID value of County to the webservice other than the Prefix. I am using vs.net 2005 and .NET 2.0 I cant find any other properties here. Really dont know how to achieve this. <asp:TextBox runat="server" ID="txtAddress1" Height="14px" Style="border-right: #6dabe3 1px solid; border-top: #6dabe3 1px solid; font-size: 11px; border-left: #6dabe3 1px solid;
 
Posted by krishna on 5/15/2009 9:13:31 AM
<ajaxToolkit:AutoCompleteExtender runat="server" ID="autoComplete1" TargetControlID="txtAddress1" ServicePath="~/WebService1.asmx" ServiceMethod="GetCountryInfo" MinimumPrefixLength="1" EnableCaching="true" />
 
Posted by Nishant on 5/18/2009 4:29:58 AM
Its very useful article.
 
Posted by Jasmine on 5/20/2009 4:36:10 AM
Hi, In Database i want to retrieve 20000 records. Those records i want in autocomplete dropdown list in alphabetical order.Please any code in ajax or javscript
 
Posted by vijay kumar on 5/22/2009 6:21:55 AM
i am doing same thing but not getting result............... will u pls send me the code project of this........... Thanx for advance.......
 
Posted by Ben on 5/23/2009 3:00:41 AM
Thanks Alot! Very short, clear, and useful explanation.
 
Posted by TAPAN MISHRA on 5/30/2009 1:41:21 AM
THANK'S ALOT, PLEASE ATTACH LINK TO DOWNLOAD PROJECT LIKE SITE- WWW.CODEPROJECT.COM
 
Posted by Dinnu on 6/5/2009 2:13:42 AM
Thx a lot its good coding but u did not explain how to "write a webmethod ‘GetCountryInfo’ to fetch the data from the country table" plz help me in this issue i need urgently.Just mail the code to my GmailID. I hope i wil get respone as soon as possible plz dont forget to mail to my id.
 
Posted by Hiren solanki on 6/19/2009 2:54:20 AM
thanks for the fabulous code friend, i was trying to do it from last 2 days, now i got it , Thank you again keep coding
 
Posted by Raza on 6/23/2009 6:11:54 AM
Nice article Please send me in vb code
 
Posted by svk on 6/30/2009 5:51:29 AM
i did as said above but using vb code i dont get any error but when i type in text ox i dont get anything
 
Posted by svk on 6/30/2009 8:06:41 AM
i got the above its excellent. i just wanted to make few changes is it possible. 1) i need to implement the same on a button click , not on textchange
 
Posted by svk on 7/1/2009 2:08:52 AM
one more issue it works fine & fast with small records, but for large records its very very slow . how to increase the performance
 
Posted by Pallavi on 7/2/2009 6:28:58 AM
Can you Plzzzzz...Help me , i need this code..Plz send me at my Email Id.. Its not working in Asp.net C#...I have already used this code for autocomplete extender.i have added web service also.bt its not working.please give me any solution.
 
Posted by Zubayed on 7/4/2009 3:59:13 AM
its a really helpful resource.
 
Posted by Ramanathan on 7/5/2009 1:03:26 AM
one more issue it works fine & fast with small records, but for large records its very very slow . how to increase the performance
 
Posted by parth on 7/5/2009 10:43:28 PM
hi thankx for this code but i am having problem in this code at da.Fill(dt); in the code, this code does not work after this line in asp.net (vs 2008) please give me solution for this problem.
 
Posted by help from anybody on 7/6/2009 3:54:42 AM
not working correctly
 
Posted by Patel DIvyesh on 7/7/2009 6:14:49 AM
thanks for your code its working correctly. thank you very much
 
Posted by Mittal on 7/20/2009 7:43:18 AM
I try same way but in Asp.net i am not getting pop up. My SP return value in string array. can you send me code on same email please.. thanks, Mittal.
 
Posted by Zipper on 7/21/2009 1:56:25 AM
10Q, very helpful information
 
Posted by sreenu on 7/25/2009 3:58:24 AM
System.Web.Script.Services.ScriptService add chesthe you r missing assemblyreference error coming . could you help me
 
Posted by swapneel on 8/4/2009 6:59:11 AM
that one i use already but when database contain same name data more than 50000 at that time how to increase the performance of this control???
 
Posted by Talley Ouro on 8/8/2009 4:00:48 PM
Here is similar code in VB.NET <WebMethod()> _ Public Function getFirstName(ByVal prefixText As String) As String() Dim count As Integer = 10 Dim sql As String = "SELECT * FROM Employees WHERE FirstName LIKE @prefixText" Dim da As SqlDataAdapter = New SqlDataAdapter(sql, Config.AppSettings("SQLCONN")) da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.NVarChar, 40).Value = prefixText + "%" Dim
 
Posted by Bikash on 8/27/2009 11:32:58 PM
Please make sure that you will make your webservice code in one file. Then only it will work.
 
Posted by Siddharth on 9/1/2009 8:23:24 AM
thnks man .. very nice ... this code is absolutely working .. vey gud .. u solved my problem.
 
Posted by ansuya on 9/5/2009 5:42:34 AM
My web service is working fine.But auto dropdown not visible.Please send me default.aspx's code
 
Posted by reshma hankare on 9/10/2009 4:22:17 AM
excellent article.i implemented ,but still its nt giving me output.pls is there are other settings?
 
Posted by rams on 9/16/2009 8:10:40 AM
i am new this.this article is verygood but i want 2 dropdownlists one for states and another for cities pls helpme.....
 
Posted by jesuraj on 9/24/2009 12:18:39 AM
i can get datas from database to webservice but it is working in textbox. can u help me. thanks
 
Posted by vipin on 9/29/2009 10:12:03 AM
hey u rock man...it worked plz explain this code to me in detail
 
Posted by zakir on 10/5/2009 2:56:43 AM
hi, How do I obtain the country ID of the selected country instead of the name? I would still like to display the name of the country in the textbox howver, be able to access the ID associated with it either from a hidden field or something upon selection? Do you think it's possible do so? thanks
 
Posted by mass on 11/5/2009 4:11:34 AM
hi, I got error more errors: CS0103: The name 'SqlDbType' does not exist in the current context Error 2 The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?) E:\gowri's doc\WebSite16\App_Code\WebService.cs Error 7 Cannot apply indexing with [] to an expression of type 'DataRow' E:\gowri's doc\WebSite16\App_Code\WebService.cs
 
Posted by kingmaker on 11/5/2009 4:25:45 AM
hi, I got error more errors: CS0103: The name 'SqlDbType' does not exist in the current context Error 2 The type or namespace name 'DataTable' could not be found (are you missing a using directive or an assembly reference?) E:\gowri's doc\WebSite16\App_Code\WebService.cs Error 7 Cannot apply indexing with [] to an expression of type 'DataRow' E:\gowri's doc\WebSite16\App_Code\WebService.cs AnyBody's help me.....
 
Posted by murali on 11/29/2009 11:24:33 AM
Thanks folks!!
 
Posted by Roy on 12/2/2009 10:22:04 PM
Hi, may i know where is it possible to get vb code for auto complete text box?
 
Posted by fayza rekaby on 12/8/2009 5:23:53 AM
hi all i want Knowing how attachment database to Application from autocomplete
 
Posted by fayza rekaby on 12/8/2009 5:24:19 AM
thanks hi all i want Knowing how attachment database to Application from autocomplete
 
Posted by fayza rekaby on 12/8/2009 5:24:39 AM
hi all i want Knowing how attachment database to Application from autocomplete thanks
 
Posted by fayza rekaby on 12/8/2009 5:25:11 AM
hi all i want Knowing how attachment database to Application from autocomplete thanks floks
 
Posted by matz on 1/1/2010 8:47:21 PM
my code is this: <asp:TableCell> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:AutoCompleteExtender ID="AutoCompleteExtender1" MinimumPrefixLength="1" ServiceMethod="GetUsersName" ScriptPath="../WebServic
 
Posted by matz on 1/1/2010 8:52:55 PM
ScriptPath="../WebService.asmx" TargetControlID="TextBox1" runat="server"> </asp:AutoCompleteExtender> </asp:TableCell> and my webservice is working 100% but the autocomplet don't..whats wrong? thanks
 
Posted by sirge on 1/16/2010 9:36:54 PM
Hi, I followed your article and when invoke my web service method it returns a result set through a xml file but unfortunately, when I'll set my Defaul.aspx as start-up page my auto-complete textbox does not act like an auto-complete. I don't know what is wrong...can anyone help me. It seems that matz and I have the same problem.
 
Posted by Md. Shohel Rana on 1/18/2010 1:56:27 AM
Thank you for gime codding. You are so great.
 
Posted by vishakha on 2/10/2010 4:00:44 AM
sir, i'm not able get output in my textbox,my webservice is perfectly working. when i debug services i get XML form on the browser,in aspx page it not shown.
 
Posted by hari on 2/12/2010 1:14:05 AM
hi,i am new to this blogs,i have developed RDLC Reports, i have developed Charts type is line,age on x axis and weight on y-aixs we have one age column and many weight columns,reports is completed,i want to show one text lik (p1 weigh)like for all weight,how i can show one fixed text on line,i think iots on like Datapoint,how i show i text on one line,different text on different lines,or how i show one text one data point in one line,by using datapoint it can repeated,cann i show data point onc
 
Posted by Excellent on 2/16/2010 10:47:44 AM
Can't get items to display in text box after webservice call I debugged webservice; it returns proper items. If I type letter A in text box, cntName contains states beginning with A. No errors in FireBug. What am I missing?? [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.Web.Script.Services.ScriptService] public class WebService1 : System.Web.Services.WebService {
 
Posted by Antonyraj on 3/10/2010 2:52:53 AM
Nice, but i need the same problem without using Ajax
 
Posted by Sarath on 3/10/2010 7:09:22 AM
Hi the code is fine, but while typing the data in textbox, my service method is not being called and not displaying in the textbox.
 
Posted by Sarath on 3/10/2010 7:10:43 AM
can u give where my code goes wrong,i did everything fine. <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" TargetControlID="TextBox1" ServiceMethod="getauthors" ServicePath="http://localhost:1131/AutoCompleteTest/myservice.asmx" MinimumPrefixLength="1" runat="server"> </cc1:AutoCompleteExtender>
 
Posted by Sekhar Reddy on 3/11/2010 5:33:32 AM
Plz send some useful tips in asp.net while writing code and developed the application
 
Posted by harshal patil on 3/22/2010 6:46:35 AM
Can you send the code of Autocomplete TextBox using C#? I want texbox same like google search.
 
Posted by deepak on 3/23/2010 1:24:28 AM
cc1:AutoCompleteExtender how can i get the tag?
 
Posted by Prince on 3/23/2010 9:59:10 AM
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> n add reference in bin
 
Posted by Sudha on 3/30/2010 3:45:47 AM
Hi, This is my scenario, I have txtbox1 which has the autocomplete extender and uses the Ajax enabled webservice (.svc). I have another text area (txtbox2) which shd b populated with values depending on the text change in the txtbox1. Please tel me how to populate the corresponding values in the txtbox2 when we select a name in the txtbox1?
 
Posted by shiva on 5/6/2010 12:04:24 PM
i used same code but it's giving Cannot implicitly convert type 'string[]' to 'string'
 
Posted by Ajit Kumar Nayak on 5/11/2010 11:37:23 PM
Thank You For this help,that solved great problem.....
 
Posted by Ajit Kumar Nayak on 5/11/2010 11:39:44 PM
Can I allow scroll for the dropdown that is coming when i am typing the prefix of any name in the database,but it is taking whole page .so i need to limit this ,Is there any Way ?
 
Posted by xulfiqar on 5/14/2010 1:41:42 AM
sorry i cannot get this working properly
 
Posted by harsimran on 5/15/2010 12:40:47 AM
how can i retrieve many values in same textbox
 
Posted by vanchinathan on 5/17/2010 7:38:38 AM
hi pls tell me. i have three textboxes i need to add the autocomplete extender for these three textboxes. each textboxes values are from different column of different table. and each boxes having different methods. Thanks in advance.
 
Posted by ashwani on 5/18/2010 7:25:46 AM
hi , my service is not working.... same thing i do which u mention there ... help me
 
Posted by Nithya on 5/26/2010 6:54:02 AM
From the webservice it is returning the correct result,but while running the aplication auto complete extender is not working.request your help
 
Posted by Druckvorstufe on 5/28/2010 4:20:43 AM
Of course, what a great site and informative posts, I will add backlink - bookmark this site? Regards, Reader. http://www.digital-media-tech.com/DE/index_services.html
 
Posted by Subodh Singh on 5/29/2010 12:17:30 AM
GM Sir/Madam I want to fetch the company Name from Company Details db but the company name would be the specified city Name from citydetail db. City<Textbox1>Company Name<textbox2> company Name should be from specified city in autocomplete extender
 
Posted by Subodh Singh on 5/29/2010 12:19:19 AM
how can I manage the display of my web forms on every web browsers
 
Posted by Denny on 7/28/2010 5:34:02 AM
hey thanks for this code so simple saved a lot of time
 
Posted by kayan on 8/20/2010 8:30:08 AM
I did this same and it is working fine but I want to take the colums from different tables how can I write if condition in this code
 
Posted by varun on 10/11/2010 2:22:15 AM
How to use multiple autocomplete extendet to multiple textbox?can we use the sme webservice by defining different webmethods in it?
 
Posted by Ratheesh Kumar on 10/19/2010 9:18:10 AM
Hi I am Ratheesh, This is a great Explanation, but i am not getting any errors, still it is not fetching the values.
 
Posted by varun on 10/27/2010 5:56:05 AM
how to retrieve data from xml file instead of using sql db?
 
Posted by kamya on 11/2/2010 4:21:08 PM
How to reduce the height of the pop up panel? Based on the text i key in, sometimes the pop up panel is displayed at the top of my text box control. This results in a blank space below the text i want to select.
 
Posted by Carlos Pelaez on 11/17/2010 8:36:57 PM
Would be possible if someone can send me this same using VB.NET capelaez@yahoo.com I appreciate
 
Posted by Jayandra Patil on 12/9/2010 1:28:33 PM
Great article...
 
Posted by ASP.net Developer on 1/22/2011 1:27:17 AM
Thanks Alot it is very very nice and informative.. and you have explained it very clearly and detailed order
 
Posted by nishit shah on 2/13/2011 7:12:15 AM
hi dude, i want to use autocomplete control in my aspx page i used webservise for that. when i run my webservise its give me correct output but when i trying to run my aspx page its run but not give me the related words so i request u to help me for this problem its urgent thnx in advance.................
 
Posted by Hardik on 2/18/2011 2:23:15 AM
thanks its working
 
Posted by Sonali Patil on 2/19/2011 12:43:15 AM
Hello ,Actually i m using this autocomplete box for search n now i want a image in it as well as it should search on his name. both should be cuming 4m database.. can u plz help me in this .i m using MS SQL n VS 2008.dis functionality is same as facebook search. can we do it in ASP C# using autocomplete.
 
Posted by sahil on 2/22/2011 3:56:18 AM
the same code is not working for asp.net 2.0 c#... can u pls tell me..its urgent
 
Posted by SujiklKumar on 3/2/2011 1:35:47 AM
hai ,this is gud idea..i have one doubts that is..my query returns eg:Select Name,Code from table..ok ..Name Display the TargetTextBox and Code will be Stored in another textBox is it Possible ?
 
Posted by Noor Rahman on 3/8/2011 3:35:02 AM
Nice Code working fine
 
Posted by SNIGDHA DEV PAUL on 4/3/2011 12:29:17 AM
I m unble to populate auto complete. my code is : <WebService(Namespace:="http://tempuri.org/")> _ <WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _ <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ <System.Web.Script.Services.ScriptService()> _ Public Class WebService Inherits System.Web.Services.WebService <WebMethod()> _ Public Function GetUser(ByVal prefixText As String, ByVal count As Integer) As String()
 
Posted by SNIGDHA DEV PAUL on 4/3/2011 12:32:19 AM
remaining code: Dim ora_con As New OracleConnection("Data Source=INWDAK;Persist Security Info=True;User ID=INWDAK_WEB;Password=INWDAK_WEB;Unicode=True") If ora_con.State = ConnectionState.Open Then ora_con.Close() Dim ora_cmd As New OracleCommand ora_cmd.Connection = ora_con ora_cmd.CommandText = "Select USER_NAME From INWDAK_USERS Where USER_NAME LIKE '" & prefixText & " %'" Dim ora_dr As OracleDataReader = ora_cmd.E
 
Posted by SNIGDHA DEV PAUL on 4/3/2011 12:33:45 AM
remaining code:Dim ora_dr As OracleDataReader = ora_cmd.ExecuteReader Dim items As List(Of String) = New List(Of String)(count) If ora_dr.HasRows Then While ora_dr.Read Dim i As Integer items.Add(ora_dr(0)) i = i + 1 End While Else items.Add("No Name Found") End If Return items.ToArray()
 
Posted by hello on 5/4/2011 4:55:20 AM
Nice
 
Posted by Abhinay Kumar on 5/6/2011 9:47:37 AM
How to implement AutoCompleteExtender for single textbox for multiple attributes to retrieve the values? For example assume that I am having a student database with attributes RollNo,Name,Address,Marks. Now i want to implement AutoCompleteExtender for single textbox for the attributes i.e.RollNo,Name,Address,Marks.to retrieve the values? Is it possible.If so please suggest me how to approach. And also please explain me with an example. Sir Please try to give me solution to solve th
 
Posted by Pratyush Kumar on 5/13/2011 10:31:25 AM
I have a textbox in one of the user control. I am using AutoCompleteExtender and trying to fetch the values from the DB and populate the textbox. I am unable to do so. Whether AutoCompleteExtender works in an user control ??? If anyone has any idea please revert back with your suggestion.
 
Posted by jamcoder on 5/20/2011 7:18:06 PM
Thanks..works. If your webmethod works but you still get nothing in your project make sure that the foll line is in your webservice and uncommented: [System.Web.Script.Services.ScriptService] It allows the web service to be called by a script
 
Posted by Lisetsky Val on 5/24/2011 5:42:19 AM
Hello All, here is one more solution with very rich functionality that requires only ASP.NET AJAX and jQuery to work: Project: http://suggester.codeplex.com/ Demo: http://show-demos.net/suggester/
 
Posted by sunil on 9/3/2011 7:12:05 AM
what a fantastic code sir, its working perfectly ok...... Thank You Very..............Much God Bless You..............
 
Posted by Basima Omar on 10/23/2011 3:08:11 AM
Thanks a lot , it was done. with regards;
 
Posted by Anand kumar on 12/28/2011 6:37:20 AM
thank you very much was very useful for me thank u very much again
 
Posted by Av1nash on 1/12/2012 1:23:09 AM
Nice bro!!
 
Posted by Sushil kumar on 3/8/2012 9:17:59 AM
Thanks bro... It's really helpful. Before this I tried http://www.codeproject.com/Articles/201099/AutoComplete-With-DataBase-and-AjaxControlToolkit# for the same but it was really so complicated. This one is really too easy and good to understand. Thanks once again....
 
Posted by Jo on 5/25/2012 2:31:22 AM
Thx, for that nice Example, it helps me to understand the how to..., and works nice either normal page or master pages
 
Posted by RSVV Prasad Rao on 6/1/2012 10:45:09 AM
Sir, First of all i am very much thankful to u for the code. I have followed everything as what was given by code in the coding part but my auto complete was showing no results or suggetsions please help me out iam using ms access please
 
Posted by RSVV Prasad Rao on 6/1/2012 10:46:16 AM
Please its urgent for me i will be much greatful towards u if u respond as soon as possible
 
Posted by laine on 6/16/2012 9:11:16 AM
hi i the following error after converted it to vb: Format of the initialization string does not conform to specification starting at index 0. Can kindly assist me regarding this error.. thank you.
 
Posted by Subhankar Biswas on 6/24/2012 2:51:06 PM
Web services is ok but I don't Understand what is cc1.. and how to method Invoke and when we pass prefixText parameter..
 
Posted by Saurabh on 6/29/2012 5:37:22 AM
Great to see such functionality.. but still if query has thousands of records to fetch then no response and user would not wait for long.. any resolution..
 
Posted by Sunny Dhar on 6/30/2012 6:59:43 AM
Something Wrong in the code, it is not working
 
Posted by Rashmi on 8/22/2012 7:29:24 AM
I need use the event text_changed of mytextbox, the problem is when i click on the scroll bar, make a postback, how i can put the scroll and make to autoposback ??
 
Posted by Anton Pavlov on 10/4/2012 7:55:34 AM
Very good example, helped a lot. Could you send me the Code of Autocomplete TextBox? Here I also find VB code ozekisms.com/index.php?owpn=314
 
Posted by ABC on 10/17/2012 2:19:05 AM
thanks
 
Posted by Prateek on 10/30/2012 5:43:24 AM
thanks for the code its a genuine working in good manner
 
Posted by ramnand on 11/1/2012 4:10:04 AM
Nice Code working fine,thanks a lot
 
Posted by chandana on 12/13/2012 4:09:41 AM
really good. i was searching for code everywhere. but only your service worked well.
 
Posted by Amit Patil on 3/12/2013 2:04:17 AM
Hii... Its very good & very easy to implement ... Thanks
 
Posted by Palz on 5/22/2013 12:06:07 AM
Thanks a LOTTTTTTTTTTTTT ..I tried to run Autocomplete using WebService since last 5 hours.....Somehow my query was wrong..I copied your code and pasted in Webservice and just made some minor changes and it WORKED.... Yippee...Thanks it will help me to use in my entire application...
 
Posted by anil on 10/25/2013 1:40:52 AM
Dim adp As New OleDbDataAdapter(cmd) Dim dst As New DataSet() con.Constr.Open() *******adp.Fill(dst)****** con.Constr.Close() on fill method my form reload control can't move next after adp.fill(dst)
 
Posted by anil on 10/25/2013 1:40:53 AM
Dim adp As New OleDbDataAdapter(cmd) Dim dst As New DataSet() con.Constr.Open() *******adp.Fill(dst)****** con.Constr.Close() on fill method my form reload control can't move next after adp.fill(dst)
 
Posted by Shweta W on 11/15/2013 12:48:21 AM
I did a small modification in above code to work. Uncommented "[System.Web.Script.Services.ScriptService]" and removed static keyword from Method defination. And guess what.. it workeddd.... :)
 
Posted by sunil on 2/3/2014 7:00:26 AM
thanks a lots wonderful
 
 Rating & Comments
A word 'Excellent' means lot to the author of this article. You can give comments about this article but not the author.
Rate this Article:
Name:
Email Id:  
We never display your email id anywhere.
Comment/Question: Max. 500 letters
Twenty-Nine plus ThirtyThree Equals To
 
Sponsored by
When Good HTML Goes Bad: How You Can Protect Your Web Applications
Oracle Magazine
FierceDeveloper