Autocompleteextender

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;
    }