AJAXToolKit AutoComplete Extender

AJAXToolKit AutoExtender Example 1
Example 2
Example 3
Example 4
Example 5
Example 6
Example 7
Example 8
Embedding images in mails properly


Example 9

Resource

ASPX


<1--function id="collegeteamextender" runat="server" servicepath="ncaa.asmx" servicemethod="getTeamList" minimumprefixlength="1" completionsetcount="10" targetcontrolid="collegeteam">-->


ASMX

namespace AutoComplete
{
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class ncaa : System.Web.Services.WebService
{
[WebMethod]
public string[] getTeamList(string prefixText, int count)
{
DataSet teams = new DataSet();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
string sql = "SELECT TOP " + count + " team_name FROM team WHERE team_name LIKE '" + prefixText + "%'";
SqlCommand sqlCmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataAdapter sqlAdpt = new SqlDataAdapter();
sqlAdpt.SelectCommand = sqlCmd;
sqlAdpt.Fill(teams);
string[] teamName = new String[teams.Tables[0].Rows.Count];
int i = 0;
try
{
foreach (DataRow row in teams.Tables[0].Rows)
{
teamName.SetValue(row["team_name"].ToString(), i);
i++;
}
}
catch { }
finally
{
conn.Close();
}
return teamName;
}
}
}



-----------------------

[WebMethod]
 public string[] GetCompletionList(string prefixText, int count)
 {
     if (count == 0)
     {
         count = 10;
     }

     if (prefixText.Equals("xyz"))
     {
         return new string[0];
     }

     Random random = new Random();
     List<string> items = new List<string>(count);

     for (int i = 0; i < class="kwrd">char c1 = (char)random.Next(65, 90);
         char c2 = (char)random.Next(97, 122);
         char c3 = (char)random.Next(97, 122);
         items.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(prefixText + c1 + c2 + c3, i.ToString()));
     }
     return items.ToArray();
 }