Autocomplete extender in gridview

Question

Hi I am using autocomplete extender in one column of gridview. which is populated with database column value by the name id after entering a number id the corresponding series coming in the form of dropdown in autocomplete extender. Now what i need is after entering a id in textbox of autocomplete extender the corresponding data like nameaddress etc should display in other columns of gridview. I am not getting how to do this one can anybody help me regarding this. Thanks in advance.

Vishal Kale · Answer

Hi I want to implement the same functionality in one of my form I'm facing the same issue can you please help me out on this? I know it is older post but if you found any solution related to this please guide me. Thanks in advance. Vishal.

Ashwini · Answer

Hi kumar i have done this one already. what i wanted to do is i am having 3 columns in database i.e product id name and location. In my case i wanted to display 3 columns in gridview in that 3 columns for product id i should use autocomplete extender for textbox and for name and location textboxes inside the gridview. you assume around 5 rows are there in gridview here user will enters the productid in autocomplete extender textbox as soon as productid entered corresponding name and location should fetch from database and display in name and location column of gridview. iam not getting how to do it. please help me regarding this.

Hemant Kumar · Answer

Here are some sample codes about how to use asp:AutoCompleteExtender in the EditItemTemplate of a asp:GridView for your reference. '> '> '> '> '> '>  SelectCommand=SELECT [ApplicationName] [LoweredApplicationName] [ApplicationId] [Description] FROM [vw_aspnet_Applications]> Web Service Method: [WebMethod] public string[] GetCompletionList(string prefixText int count) { StringCollection list = (StringCollection)HttpContext.Current.Profile[SearchTerms]; List suggestions = new List (); foreach (string s in list) { if (s.StartsWith(prefixText)) { suggestions.Add(s); } } return suggestions.ToArray(); } You can also try to take a look at this blog for details about how to use asp:AutoCompleteextender with asp:GridView - http://weblogs.asp.net/scottgu/archive/2006/01/01/434314.aspx http://csharpdotnetfreak.blogspot.com/2009/09/ajax-autocompleteextender-textbox-width.html http://csharpdotnetfreak.blogspot.com/2009/01/ajax-autocomplete-textbox-gridview.html