0

Hi dude i am facing a little problem.When i first time implemented auto complete suggestion it work properly but now after one month i use many other field to extend them as auto suggestion all of them are working but give suggestion in a single line.Please any one give me a solution.Thanks in advance.

<ajaxToolkit:ToolkitScriptManager ID="ScriptManager1" runat="server"></ajaxToolkit:ToolkitScriptManager>

 <ajaxToolkit:AutoCompleteExtender ID="autocomplete" runat="server" TargetControlID="txtsupgname"
                    ServicePath="autoComplete.asmx" ServiceMethod="GetCompletionList" MinimumPrefixLength="2" 
                    CompletionInterval="100" EnableCaching="true" CompletionSetCount="20"      
                    ShowOnlyCurrentWordInCompletionListItem="true" >
                    </ajaxToolkit:AutoCompleteExtender>


<asp:TextBox ID="txtsupgname"  runat="server" Width="185px" TabIndex="1" 
                            ForeColor="Black" MaxLength="40"></asp:TextBox>

public class autoComplete : System.Web.Services.WebService 
{

        [WebMethod]
    public string[] GetCompletionList(string prefixText, int count)
    {
        using (SqlConnection cn = ConnectionManager.GetConnection())
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM SupplierGroupSetup WHERE supg_name LIKE '%" + prefixText + "%'", cn))
            {
                cmd.CommandType = CommandType.Text;
                DataSet ds = new DataSet();
                DataTable dt = new DataTable();
                try
                {
                    cn.Open();
                    cmd.ExecuteNonQuery();
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    da.Fill(ds);

                }

                catch { }

                finally
                {
                    cn.Close();
                }
                dt = ds.Tables[0];
                List<string> txtItems = new List<string>();
                string dbValues;

                foreach (DataRow row in dt.Rows)
                {
                    dbValues = row["supg_name"].ToString();
                    dbValues = dbValues.ToLower();
                    txtItems.Add(dbValues);
                }
                return txtItems.ToArray();
            }
        }

    }
}

Edited by Dani: Formatting fixed

2
Contributors
1
Reply
2
Views
5 Years
Discussion Span
Last Post by stbuchok
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.