ASP.NET

[WebService(Namespace = "http://tempuri.org/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
[System.Web.Script.Services.ScriptService] 

<asp:ScriptManager id="ScriptManager1" runat="server"><br />
    </asp:ScriptManager><br />
    <cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtTo"<br />
     ServicePath="WebService.asmx" Enabled="true" MinimumPrefixLength="1" ServiceMethod="MethodNameFromWebService"><br />
    </cc1:AutoCompleteExtender>

.netman wrote:

" WHERE description like '" + prefixText + "' ";

<%@ WebService Language="C#" Class="WebService" %><br />
<br />
using System;<br />
using System.Web;<br />
using System.Web.Services;<br />
using System.Web.Services.Protocols;<br />
<br />
[WebService(Namespace = "http://tempuri.org/")]<br />
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]<br />
[System.Web.Script.Services.ScriptService] <br />
<br />
public class WebService  : System.Web.Services.WebService {<br />
<br />
    [WebMethod]<br />
    public string[] GetUserName(string prefixText)<br />
    {<br />
<br />
        System.Data.DataSet dtst = new System.Data.DataSet();<br />
<br />
        System.Data.SqlClient.SqlConnection sqlCon = new System.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=BussinesTube;Integrated Security=True");<br />
<br />
        string strSql = "SELECT name+' ' +lastname +' ; < '+ username + ' > 'as [name] from users WHERE [name] LIKE '%" + prefixText + "%' ";<br />
<br />
        System.Data.SqlClient.SqlCommand sqlComd = new System.Data.SqlClient.SqlCommand(strSql, sqlCon);<br />
<br />
        sqlCon.Open();<br />
<br />
        System.Data.SqlClient.SqlDataAdapter sqlAdpt = new System.Data.SqlClient.SqlDataAdapter();<br />
<br />
        sqlAdpt.SelectCommand = sqlComd;<br />
<br />
        sqlAdpt.Fill(dtst);<br />
<br />
        string[] cntName = new string[dtst.Tables[0].Rows.Count];<br />
<br />
        int i = 0;<br />
<br />
        try<br />
        {<br />
<br />
            foreach (System.Data.DataRow rdr in dtst.Tables[0].Rows)<br />
            {<br />
<br />
                cntName.SetValue(rdr["Name"].ToString(), i);<br />
<br />
                i++;<br />
<br />
            }<br />
<br />
        }<br />
<br />
        catch { }<br />
<br />
        finally<br />
        {<br />
<br />
            sqlCon.Close();<br />
<br />
        }<br />
<br />
        return cntName;<br />
<br />
    }<br />
<br />
<br />
    <br />
}