AJAX :: Filling Complete Form With Autocomplete Extender ?
Nov 16, 2010
In a form I have autocomplete extender which fills a textbox. Requirement is to fill all fields of form using that extender. Like user should select company name from textbox with extender and based on that all fields should be filled.
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 have created one user control in which i have to show ajaax autocomplete extender. i write all the code for this in my other it works fine.... but in this code this is not working. for this i have teaken coutry list.xml from net.
when the textbox of the autocomplete extender looses focas the auto complete xtender stops the returning any results or even firing events(onpopulating, onpupulated).
and I there any way to know when the extender fires the request(provide code example if you can).
I have decided to use the Ajax Auto complete extender with a database, i found some cool articles on google to do this, but i cannot get it to work, I am trying a simple example where i have 1 textbox and i am trying to obtain products from the products table in the northwind database, heres my code (its not working)
I am using ASP.net 2.0 and AJAX 2.0. I implemented successfully auto-complete extender for my text box and it is working very good. But the problem is for Drop down list position. When the page first load and at that time if we use auto complete drop down will come properly but if the scroll bar position change then drop down will overlap the text box and it will change the position. For more info I will put screen of it.
I'm pretty new to ASP.Net and I came across a problem using Ajax AutocompleteExtender. Currently I'm trying to update the database table through ListView. More precisely - I'm trying to update foreign key (PARTNER_ID). Basically I need the DropDown functionality out of a Autocomplete Extender because I have a very long list of partners. I managed to get key/value pairs back to Autocomplete Extender but I can't insert the value into a hidden filed that I use to update the table. This is as far as I got - the error I get from compiler is:
Compiler Error Message: CS0103: The name 'ACEValueEdit' does not exist in the current context
I did the tutorial on this site for the auto completer control. It can be found here[URL] to see the code.
It uses a page method that has the words in a string array for the auto-completer. It works but it's really slow. There is a delay of a half second or so before it appears. Even when I have cache enabled it's really slow. The array only has 5 or 6 words in it. I can't imagine how slow it would be with a much larger list. Which is how this would really be useful.
Is there a way to speed this up? I know I've seen these on the web that worked better. It seems like if this were done using a service that it would be way too slow.
I have to use auto complete extender in .master page The problem i am facing is, the copy of ServiceMethod should exists in each and every page then only the autocomplete extender is working.
Is it possible to have the code only in .master page, if so how it is. I tried with webservices also but not working.
I have this weird problem with the auto complete extender not firing in firefox, but it gets a little more complex let me try to explain.In IE it works fine (always).In firefox it works only if i directly browse to the page /newmember.aspx,I'll elaborate on this.
In my index.aspx i have a menu,when you click on a menu item that page gets loaded into the content div (using jquery's load command).
So basically it looks like this: $('#Content').load("/newmember.aspx"); While newmember is embedded is in index.aspx, the auto complete extender won't work in firefox (works fine in IE).
[Code]...
Using firebug i see that no requests get sent,Starting to lose my marbles.Auto complete extenderD
I am coming across one problem with auto complete extender in my application, problem seems to simple but i can't find any satisfactory solution. In one form, i have set auto complete extender on one text box, i have set one web service, in which one function is there, which fetches existing records from db, on first load, if i write releavent words with that of db, i can't see the extender, but if once either i minimize the page or give tab despite AutoPostBack property of text box is false, then after writing something in text box shows me the extender.
Here are the properties of both text box and extender
I'm using ajax autocomplete extender(from database). Its working fine in content page. But its not working in Master Page. I'm using VS2008. I'm using webservice...
Iam getting an array of list from database to client side(javascript array).Now my aim to place those values in a div one by one and that div should attach to the textbox similar to Autocomplete extender.
I implemented autocomplete extender,functionality is working great but my issue is with CSS.It works as expected in Firefox(it applys all stylesheets perect) but in IE it is not behaving as expected it is showing the list about 10 pixels left to the text box.
googled couple of things but none of them were working for me.
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