.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Autocomplete textbox with ajax and sql database

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net


    <form id="form1" runat="server">
        <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
                <asp:ServiceReference Path="~/WebService.asmx"/>
        <asp:TextBox ID="TextBox1" runat="server" autocomplete="off"></asp:TextBox>              

        <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" 
            ShowOnlyCurrentWordInCompletionListItem="true" >


i am using the same thing and till my webservice is concern, that is bringing up the value from table but when i am typing on the textbox so it not showiing suggestion like a google... i debug my web service that is fine working...

can anyone tell m where i am doing wrong???? plz he

View Complete Post

More Related Resource Links

ajax autocomplete with webserivce from database values



i want to make the autocomplete textbox with ajax and i have used web service for that bt when i am writing something in my textbox so nothing is happening... plz tell me where i am wrong. here is my code..

Can anyone plz send me the source code of .aspx page and webservice code demo...

plz help me..


watermark textbox using Ajax control

This is pretty simple compared to jquery. Since we need refer a dll only. we dont want any script for this. we just include that reference into our website.

Saving textbox data to MySql database in asp.net


Hi dear coders

though a very simple question to ask, but please tell me how to save and retrieve data in/from my textboxes to/from database (MYSQL) on submit button click.

i know its a very simple task but i cant make it done, so i request you to please send me some working example link or post any helpful code here in asp.net

i will be highly thankful for any kind help from you geniuses.



Autocomplete with multiple word suggestions, How can we do in Asp.Net with Ajax?


Hi All,

Could you please let me know the process to get multiple word suggesions for a text box in asp.net using Ajax.  

Actually I got a solution for that,


But it used Atlas. When I am running with this code in my application, it is conflicting with Script Manager that is already there in Masterpage.

How can I overcome that problem. Is there any built-in solution in latest versions of Ajax?


Thanks in Advance,

Sateesh Nagalla,



Ajax AutoComplete VB Code HELP!


hey guysim new to the site so bare with me. Im not sure if this has been asked before and sorry if it has.

ive been trying to figure out some code for autocomplete and everything I seem to do comes up blank.

my DataBase is called ReviewDB

the table I want to access is called Game

the Colum Name I want to retrevie is GameTitle

Dataset is call ReviewDataSet

ConnectionString is Called ReviewDBConnectionString

Webservice is called AutoComp.asmx

Im trying to get a search TextBox to Autocomplete a list of GameTitles From my DataBase. that onced send will postback to my viewGames.aspx page to display the information about that game.

Im not sure if this is even the best way todo it if you guys have better suggestions on how to search and retrive my games from the database then all ideas welcome.

thanks dave

probel in using ajax textbox watermark effect

Hi I have been trying to use ajax in my asp .net website developed in 3.5 sp1 2008! The problem is I can see tool kit controls in my tool box but i can not use the controls. like i was using the text box watermark effect but when i run the website the text-box does not show effect and there is no option in text box to add extender. there is only remove extender option. I have code:   <asp:ScriptManager ID="ScriptManager2" runat="server">                </asp:ScriptManager>        <asp:UpdatePanel ID="UpdatePanel1" runat="server">             <ContentTemplate>                                 First name:                 <asp:TextBox ID="TextBox1" CssClass="unwatermarked" Width="150" runat="server" />                 <ajaxToolkit:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1" runat="server&

textbox AutoComplete not work in XP and missing data

When I use the application in XP, auto complete mssing some data~ Here is some of data, IRC-3100 IRC-3200 IRC-5180 when I type "IRC" in the textbox, the fellow didn't show and when I type "IRC-", only IRC-3100 show this issues only occur in XP and window 7 is OK. I don't know why, please help here us the code I use to add autocomplete source~   AutoCompleteStringCollection collection = new AutoCompleteStringCollection();   PropertyInfo ppty = typeof(SOURCE).GetProperty(displayProperty);   foreach (SOURCE s in sources) {   collection.Add(value.ToString()); }   else { collection.Add( string.Empty); } } box.AutoCompleteCustomSource = collection; box.AutoCompleteSource = AutoCompleteSource.CustomSource; box.AutoCompleteMode = AutoCompleteMode.Suggest;        ClarkC

Autocomplete textbox in sharepoint

I want to develop usercontrol web part for auto complete textbox. As per the requirement, I can't use AJAX extender control. Suggest me , how I can do that.

how to implement user rating using ajax rating control from database?

Hi,I'm beginner to ajax. I've a database table having fields rating and item id.I've to display star rating using  ajax rating control for the corresponding item id.How can i do this?  

MVC + WCF + Ajax tool kit( autocomplete extender)

I need to implement the above combination and am totally lost . Any help , pointers, useful links will be appreciated

Master Page, web service and Ajax autocomplete extender problem.

 I will appreciate very much any help about this issue.  I have been dealing with it for the last week and I couldn't detail and complete examples about this issue. The problem: I have a text box and ajax autocomplete control extender in my Master Page that it is not working at all.  When I type some characters on the text box it doesn't trigger the autocomplete. I have a web service that contains the function code. I est my code on a single Web Page (No Master Page) and it works perfectly.  Also, it works fine if I include the text box and the extender on the Content Page instead of on the Master Page.  It is important to keep the text box in the Master Page for me. I am using Visual Studio 2008 and ASP 3.5.   tHANK YOU VERY MUCH. here is my code:   MASTER PAGE. <%@ Master Language="VB" AutoEventWireup="true" CodeFile="MasterPage.master.vb" Inherits="MasterPage" %> <%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="ajax" %> <%@ Import Namespace = "System.Data" %> <%@ Import Namespace = "System.Data.SQLClient" %> <%@ Import Namespace = "System.Web.Script.Services" %> <%@ Import Namespace="System.Web" %> <%@ Import Namespace="System.Web.Services&

Ajax Slideshow, webservice and database

Hey I would like to know if someone can please help meI would like to use the ajax slideshow extender and  getting the Image Url stored in a databaseso far my webserivice look like this..but I think im making a mistake somewhere..its not working<WebMethod()> _    Public Function GetSlides() As AjaxControlToolkit.Slide()        Dim Connection As SqlConnection        Dim DBCommand As SqlCommand        Dim newdt As New DataTable()        Dim SQLString As String        Dim TheCompanyID As String = "1242"        Dim myConn As String = (ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)        Connection = New SqlConnection(myConn)        Connection.Open()        SQLString = "select CImageUrl, CImageDescription, CImageTitle  from Company_ImageGallery where CompanyID = @CompanyID"        DBCommand = New SqlCommand(SQLString, Connection)        DBCommand.Parameters.Add("@CompanyID", SqlDbType.Int).Value = TheCo

Weird behaviour of Gridview with textbox with autopostback OnTextChanged and AJAX CalendarExtender

I ran in to some strange behaviour of Gridview with textbox with autopostback OnTextChanged and AJAX CalendarExtender. This gridview is in an updatepanel with scriptmanager. When my gridview is filled with data, it keeps running my OnTextChanged  function and therefor makes my application terribly slow. I need to have the autopostback and ontextchanged function to recalculate stuff in my gridview. Does anybody know of this problem and if so does anybody found a workarround ?

Ajax enabled website and MSAcess Database

Hi i have problem while connecting to my MSAccess  Database in App_Data Folder in Ajax enabled website. How to bind Gridview with MsAcess Databse in Ajax enabled website???? Can u please help me , i m new to Ajax and Asp.net.   Thanks in Advance    

Report Parameter type for a list of Employees to prompt like AJAX Textbox intellisence when the user


Hi All,

I have around 300 employees report to run for a specific employee, I cannot have a Dropdown as it would be too long for the report user to choose from. Is it possible in SSRS 2008 to have a text box that would provide intellisence like AJAX textbox and provides user with Employee name to choose from database or is there any other better way to select the right mployee name to run this kind of report. being a newbie to SSRS I am unable to go furthur on this. All help is great help. Thanks in advance for responding.

Can't access dynamicly created textbox in AJAX postback.


I have a script which creates a dynamic textbox (and more) in an AJAX async post back. But when I try to acess the textbox I am told "Object reference not set to an  instance of an object". I have been strugleing with this for a long time and can not get it to work so please help me. This is written in C# .Net 4. The line causing the problem is the very last one where I have tbGameName.Text.Trim()

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class GameInformation_AddUpcomingRelease : System.Web.UI.Page
    protected override void OnInit(EventArgs e)
        string v = this.Request.Params.Get(this.ddlAmountToAdd.UniqueID);

        string[] Regions = { "USA", "Japan", "Europe", "Other" }; //Create a string array of regions.
        string[] Platforms = { "PlayStation 3", "X-Box 360", "Wii", "Computer", "PSP", "Other" }; //Create a string array of platforms

        CreateControlSet(1, Regions, Platforms); //Generate the first Control Set

        if (!string.IsNullOrEmpty(v))
            for (byte i = 2; i <= Convert.ToByte(v); i++)
                //Add a

autocomplete combobox/textbox binding to dataset


Hi All.

I found sample http://www.codeproject.com/KB/WPF/WPFAutoCompleteTextbox.aspxAutoComplete ComboBox where data is hardcoded in the code. I would like to use AutoComplete ComboBox binded to dataset. I don't have a problem binding data to ComboBox but I have problem if need that combobox autocomplete and filtered listbox. That is bit of code which I found

  Public Sub New()

    textBox1.AddItem(New AutoCompleteEntry("Toyota Camry", "Toyota Camry", "camry", "car", "sedan"))
    textBox1.AddItem(New AutoCompleteEntry("Toyota Corolla", "Toyota Corolla", 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend