Autocompleteextender

Assuntos Gerais
#1

Olá,

Estou a tentar implementar o Autocompleteextender, mas não estou a conseguir. Quando carrego para preencher a textbox, não faz nada.
Precisava de ajuda.

webservice
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public string[] GetProducts(string prefixText)
{
String SERVIDOR = “”;
String BANCO = “”;
String USUARIO = “”;
String SENHA = “”;

        MySqlConnection con = new MySqlConnection("Database=" + BANCO + ";Data Source=" + SERVIDOR + ";User Id=" + USUARIO + ";Password=" + SENHA + "; pooling=false"))

        string sql = "select * from fichadel where user like '" + prefixText + "%' order by user";
        MySqlDataAdapter da = new MySqlDataAdapter(sql, con);
        //da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText + "%";
        DataTable dt = new DataTable();
        da.Fill(dt);
        string[] items = new string[dt.Rows.Count];
        int i = 0;
        foreach (DataRow dr in dt.Rows)
        {
            items.SetValue(dr["user"].ToString(), i);
            i++;
        }
        return items;
    }

html
<asp:TextBox ID=“TextBox1” runat=“server” Width=“785px”></asp:TextBox>
<asp:AutoCompleteExtender ID=“AutoCompleteExtender1” runat=“server” MinimumPrefixLength=“1” ServiceMethod=“GetProducts” ServicePath="~/WebService/AutoCompleteWebService.asmx" TargetControlID=“TextBox1”>
</asp:AutoCompleteExtender>

#2