.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

ajax autocomplete with webserivce from database values

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


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..


View Complete Post

More Related Resource Links

Autocomplete textbox with ajax and sql database



    <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

jquery autocomplete multiple values


i got some samples and i did autocomplete using jquery , its working well for single input values

but i need to pass multiples values after one by one in the textbox. Is it possible to pass multiple

values in the textbox for autocomplete in jquery in asp.net?


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,



accessing values from a database with datalist?


I have a datalist and I am filling it using a dataadapter, dataset. So in my .ascx page, I have

<asp:datalist runat="server" id="dlProducts" repeatcolumns="2" repeatdirection="horizontal">


<table border="0">

<tr><td><%# Eval("Item_Name") %></td></tr>

<tr><td>I have to add a picture here</td><td><%# Eval("First_Name") %></td></tr>




In the area where I have put a statement like "I have to add a picture here", I have write a big case statement.  Like:

Case: 6 // show a picture from file1

case: 7 // show a picture from file2

Case 8: //show a picture from file3


So How do I do this here?  Because I dont know how to access the datalist values from code behind.


Here is my code behind:

SQLString = "SELECT First_Name, Picture, item_name, item_id from table1 where item_id = " + request.querystring["iid"];

dataadapter daItems = new dataadapter(SQLString, "connection_name");

dataset dsItems = new dataset();



Help with updating database with values from Repeater control using c#


Hello, I'm new to ASP.NET 3.5 with C#. I really need some help.

I used a Repeater control to create a simple (editable) list where, when a user logs in, they can edit their list of expenses.  The ASP page works fine.

 My issue is with the code-behind.  I am really confused with how to extract the values from the repeater control. The FindControl method does not seem to be working.  Also, the code I am using resets my 'Amount' values back to 0.00. (0.00 is the amount the user sees when they first encounter the page).

 Here's a portion of the code on the ASP page:

<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1"





<td><asp:Label ID="lblExpId" runat="server"  Text='<%# Bind("ExpId") %>'></asp:Label> </td>

 <td><asp:Textbox ID="lblExpense" runat="server" Width= "190px" Text='<%# Bind("ExpenseName") %>'></asp:Textbox> </td>

 <td><asp:Textbox ID="txtAmount" runat="server" Width= "100px"

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

How to stored values 10.57 into database



I have the variable value 10.57
10.57 If I write, it stores data: 1057.00

 I need 10.57 into database


Writing values back to a database

Hi All, I'm trying to write values back to an access database from an open source mathematical programming language (called glpk) using ODBC. I succeeded in doing so in most variables except one. The problem is described below: The following code gets an error when writing the data: \begin code:   table x3_iii {j in TF, k in C, p in P, t in T: x3[j,k,p,t]>0} OUT 'ODBC'   'FileDSN=.\d2.dsn'   'UPDATE ((Channels a INNER JOIN ChannelPeriodProducts b' 'ON a.ChannelID = b.ChannelID)' 'INNER JOIN TransformerTypes d' 'on a.OriginFacilityID = d.FacilityID' 'SET b.Quantity = ?'   'WHERE d.TransformerTypeID = ?'   'AND a.OriginFacilityID =?'   '    AND b.ProductID = ?'   '    AND b.PeriodID = ?':   x3[j, k, p, t], j, k, p, t; \end code Note that the sql is on multiple lines, because of a maximum strings limit in the glpk (but the way I used in the code is fine and worked without problems for writing other variables). Now, let me describe what I am basically trying to do: I'm trying to write the values for the variable x3[j,k,p,t] in its field "Quantity" in the table 'ChannelPeriodProducts'. The indices for that variable are j,k,p,t. The 'ChannelPeriodProducts' table has a "ChannelID", "PeriodID", "ProductID" and "Quantity" field

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

Save temporary values in gridview to database

Hi.I have a code here,where it will store temporary data in a gridview from textbox where when the data is stored temporarily in gridview.Alternately,it will be linked to search the word in google.Now i want to save the values in the gridview to database.I m new to asp.net,seeking ideas from all.Any ideas guys?Here is my .aspx code: <body> <div> <table > <tr> <td class="style1"> <asp:Label ID="Label1" runat="server" Text="Caller Info :"></asp:Label> </td> <td style="width: 100px"> <asp:TextBox ID="TxtName" runat="server" class="cls" onekeypress="" ToolTip="Press Enter key for new input"></asp:TextBox> </td> </tr> </table> <asp:Button ID="BtnAddToTable" runat="server" align="right" class="cls" Text="Add" OnClick="BtnAddToTable_Click" /> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" > <Columns> <asp:TemplateField HeaderText="Caller Information"> <ItemTemplate> <a onclick='document.getElementById("<%=iframe1.ClientID%>").src = this.href; return false

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    

Ajax AutoComplete is not working when Cookieless is true


Hi All,

I have a web page that using AutoComplete Asp.net Ajax Control.

It was working find when the Cookieless is not "True".

I have no idea my it is not working when I set cookieless to "true".



Get list of Correlation Key Values from Database


I want to know from the the Sql database (workflow persisted) how I can get a list of the unique ids I have correlating to the workflows started.  I have no problem getting the system generated Workflow Instance Id GUIDs, however I want to display our OrderId instead.

My Info

-Using Workflow 4.0

-Workflows are getting persisted to database

-correlation handle is set to my unique Id (OrderId) in the ReceiveActivity

Assigning values from a Database to a Label



I want to select all the values from a table in my database and then put each value in order into labels that are on the asp page.

I can Select all the values from that database fine but I am rather stuck as how to put the values into the individual labels? Here is the code I have connecting to my database.

  Dim cmd As New SqlCommand
            Dim myConnection As New SqlConnection("Data Source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Alerts.mdf;User Instance=true")

            cmd.Connection = myConnection
            cmd.CommandText = "SELECT DateTime, Description FROM EmailTemplateLoad"


        Catch ex As Exception

        End Try

How can I put the DateTime value into Label1 and the Decription into Label2??

I have had a nose about but can't seem to find the information I need.

Any pointers greatly appreciated.

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