AJAX :: .net Autocomplete + Web Service Not Working ?
Nov 25, 2010
I've set up a textbox with autocomplete, it works fine when i run is in visual studio, but when I deploy it to iis, the list items just do not appear.I think it has something to do with the fact that I'm using clean routes (with asp.net 4 routing).
I'm going on my 3rd day trying to get my Ajax AutoComplete textbox to call my web method. Based on my google searches, I'm not alone. I suspect the problem has something to do with the ServicePath property on the extender, although I'm not sure. My web service is at the same level, on the same server as my test web page. I'm not sure exactly what should go into the ServicePath property, although I think I've tried every possibility. Below is my web service followed by my script.
using System; using System.Collections.Generic; using System.Linq; using System.Configuration; using System.Web; using System.Web.Services; using System.Data; using System.Data.SqlClient; using System.Data.Common; using AjaxControlToolkit; using System.Text; using System.Xml; using System.Xml.XPath; using System.IO; using System.Collections.Specialized; using System.Web.Services.Protocols; [WebService(Namespace = [URL])] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [System.ComponentModel.ToolboxItem(false)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. [System.Web.Script.Services.ScriptService]
public class Service : System.Web.Services.WebService { public Service() { } [System.Web.Services.WebMethod] [System.Web.Script.Services.ScriptMethod] public string[] AutoCompleteNames(string prefixText, int count) { System.Data.SqlClient.SqlConnection cxn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["HumanResourcesConnectionString"].ConnectionString); cxn.Open();.....................
In theory, my textbox should have an autocomplete dropdown containing 3 instances of the word "test". In practice, I can type anything I want into the textbox and nothing happens.
i have written some code to for a project im working on but the Ajax tool doesnt want to function.... I know the web method works course it gives me my results when i run it but when i run the appliaction the AJAX doesnt fire this is my web service code
[WebMethod] public string[] GetCompletionList(string text) { List<string> al = new List<string>(10); [code]...
i have installed AjaxControlToolkit for framework 3.5 . my application is in virtual folder on the server which has Autocomplete Extender control, when i browse, control is not returning any list nor any error message. it is working fine in the localhost, is it because of the subfolder or any other reason i dont understand
I'm yet another programmer who find out that AJAX autocomplete extender doesn't work although I've searched several pages and saw where the biggest problems occur.I'm using ASP.NET 2.0 and AJAX for the same version. Few months ago I've included modalPopupExtender in to the same project and it's working fine.However with AutoCompleteExtender have no luck..ASPX page:
[Code]....
and web service:
[Code]....
I was using this site for reference:ttp://dotnetslackers.com/Community/blogs/kaushalparik/archive/2008/06/06/autocomplete-textbox-using-ajax-autocompleteextender-from-database.aspxBut when I type something in textbox nothing happenes. However in IE8 I got message that there is script error.
web service method(getMainHeads) with parameter is not calling with auto complete text box extender(same method with out parameter is calling fine). My Service is
[System.Web.Script.Services. ScriptService] public class InvService : System.Web.Services.WebService { ItemMainHeadMsts objItemMainHeadMsts; DatabaseHelper objDataHelper; [WebMethod] public string[] GetMainHeads(string value) { List<string> oList = new List<string >(); objItemMainHeadMsts = new ItemMainHeadMsts (); objDataHelper = new DatabaseHelper (); objItemMainHeadMsts = ItemMainHeadMstBase.SelectByFieldAuto("IMHDesc" , value); foreach (ItemMainHeadMst mainHead in objItemMainHeadMsts) { oList.Add(mainHead.IMHDesc); } return oList.ToArray();..........................
I am using VB 2008 and the ajax tool kit trying to get the autocomplete working. I have been looking at the asp.net video tutorials, but for the life of me - its not. Here is the code:
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. MASTER PAGE.
I can't get AJAX CT Autocomplete to work. The problem is when I start writing in textbox nothing happens. The frist problem I had experienced was when I tried to Add AutoComplete page method I got an error: "Cannot create page method "GetCompletionList"...". Then I tried creating it manually, but still nothing happens.
I am having issues with the autocomplete extender from the toolkit. I am using it to extend a textbox. I added a web service to the project that returns some values as a string().It works if I run it locally on either my development server or my production server, but when I try to run it from another machine the autocomplete box does not popup. I have other ajax extenders running on the page and they are working properly. Is there a security setting I need to set to get the autocomplete extender to work for the IUSR?
I have spent the last 6 hours trying to solve this problem, my Autocomplete textbox isn't working for a reason I am not aware of. I have tried using relative paths, I have tried using dummy data (as in the code below) and I have accessed and invoked the webservice directly from the browser with no issues. However, the typing in the textbox just won't trigger the webservice.
In winserver-2008, IIS 7 and .net 3.5 (i have installed AjaxControlToolkit for framework 3.5 )when i create a virtual folder for this application on the server then Autocomplete Extender control is not returning any list nor any error message also.i dont understand how to debug because it is working fine in the localhost
"Microsoft JScript runtime error: Sys.InvalidOperationException: Two components with the same id 'autoCompleteExtenderPopupBehavior' can't be added to the application."
I am not sure about writing the method in the web service. I'm trying to select the client names from sql server, then storing them into an arraylist. Finally, returning the array of names. This is my code:
public class WebService : System.Web.Services.WebService { MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlCommand(); MySql.Data.MySqlClient.MySqlConnection con = new MySqlConnection(); //MySqlDataAdapter da = new MySqlDataAdapter(); MySqlDataReader dr; public WebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string[] GetCountryInfo(string prefixText) { int count = 10; string sql = "Select * from tbl_patientmaster Where P_NAME like '" + @prefixText + "%'"; con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["HMSDBConnectionString"].ToString(); con.Open(); MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter(sql, con); da.SelectCommand.Parameters.Add("@prefixText", MySql.Data.MySqlClient.MySqlDbType.VarChar, 50).Value = prefixText + "%"; System.Data.DataTable dt = new System.Data.DataTable(); da.Fill(dt); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (System.Data.DataRow dr in dt.Rows) { items.SetValue(dr["P_NAME"].ToString(), i); i++; } return items; }
I somehow managed to get the AjaxControlToolkit working from my network drive. I've since tried to add a textbox with auto-complete functionality as per the quick and easy tutorial below. The code works in Firefox and Google Chrome but not in IE8 (Not tried any others yet)
[URL]
I dont get an error or anything just the textbox appears and works as an ordinary textbox instead of one with auto-complete functionality.
Back in the "old days" one would use the <asp:ScriptManager></asp:ScriptManager> and <asp:ServiceReferenc /> to allow for WCF Service integration into javascript on web forms. Example:
I tried your code for Autocomplete without Webservice and didn't work on my page. When I tried it on a new project it works fine but on my project it does not. I have other controls on the page but that shouldn't stop it from working right?