<ajax:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" /> <asp:TextBox ID="txtAutoComplete" ClientIDMode="Static" runat="server" /> <ajax:AutoCompleteExtender ID="AutoCompleteExtender1" Enabled="true" runat="server" DelimiterCharacters="" ServicePath="Autocomplete.asmx" ServiceMethod="GetAutoCompleteData" TargetControlID="txtAutoComplete" MinimumPrefixLength="1" CompletionInterval="10" EnableCaching="true" CompletionSetCount="12"> </ajax:AutoCompleteExtender>
public List<string> GetAutoCompleteData(string Word) { List<string> result = new List<string>(); string connection = ConfigurationManager.ConnectionStrings["alayoosainews"].ConnectionString; SqlConnection con = new SqlConnection(connection); con.Open(); //SqlCommand cmd = new SqlCommand("select distinct moviename,year from moviedetails where moviename LIKE '%'+@SearchText+'%'", con); // SqlCommand cmd = new SqlCommand("select moviename,year,charname from moviedetails,character where moviename like '%'+@SearchText+'%' and charid in( select item from fnSplit(listofcharacters,',') )", con); SqlCommand cmd = new SqlCommand("GetSearchNews", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@lang", "ta"); cmd.Parameters.AddWithValue("@word", Word); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { // result.Add("<a href=NewsDetails.aspx?newsid=" + dr[0].ToString() + ">" + dr[1].ToString() + "</a>"); result.Add(dr[1].ToString()); // result.Equals(dr["moviename"].ToString()); /// result.Add(dr["year"].ToString()); } return result; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)