ASP.NET AJAX Control Toolkit

Re: Problem with Autocomplete extender CompletionSetCount

YairNevet — Sat, 30 Aug 2008 15:40:04 GMT

Hi,

Your sql query should look like this example(notice to the TOP clause):

string selectString = "SELECT DISTINCT TOP " + count.ToString() + " Country from Countries WHERE Country LIKE '" + prefixText + "%'";

Yair Nevet

Re: Problem with Autocomplete extender CompletionSetCount

kirtid — Thu, 28 Jun 2007 05:44:16 GMT

You need to change it to return the number of results equal to count.

Re: Problem with Autocomplete extender CompletionSetCount

ravindran.vasudevan — Thu, 28 Jun 2007 05:05:57 GMT

Kindly can you let me know how to trim my results to that count.The web method does not seem to respect the count value and i need to resolve this.

Thanks,

Ravi

Re: Problem with Autocomplete extender CompletionSetCount

kirtid — Wed, 27 Jun 2007 19:18:21 GMT

The CompletionSetCount is a parameter passed the webservice method or pagemethod and it needs to respect that. You should trim your number of results to be equal to count and then return them.

Problem with Autocomplete extender CompletionSetCount

ravindran.vasudevan — Wed, 27 Jun 2007 06:50:13 GMT

Hi All,

Am trying to use the autocomplete extender to suggest the users when they type data.Basically the data gets fetched from database through a web service.

This is my autocompleteextender properties

<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtasset" ServicePath="MM_AutoCompleteWebService.asmx" ServiceMethod="GetAssetData" MinimumPrefixLength="1" CompletionSetCount="10" EnableCaching="false"></cc1:AutoCompleteExtender>

and this is my web method

[WebMethod]

public string[] GetData(string prefixText, int count)

{

List<string> mylist=new List<string>();

SqlDataReader dreader = mycomm.ExecuteReader(); while (dreader.Read())

{

string strtemp = Convert.ToString(dreader["szuserfirstname"]);

mylist.Add(strtemp);

}

return mylist.ToArray();

}

Now i have specified my CompletionSetCount to be 10 but still when the results are getting displayed its very much more than 10.The number of records in my table is huge and i just want to restrict the number of entries getting displayed in the UI.Kinldy let me know how to do this.

Also can anyone tell me how to improve performance with this.Since the data is huge when i start typing it takes little time to get me the results.I basically use a stored procedure to get the results.

Thanks,

Ravi