[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()] public static string[] Getdata(string prefixText, int count, string contextKey) { strSQL = "SELECT SID,Student_Name FROM Student_Master WHERE Student_Name Like '" + prefixText + "%'"; DataTable dataTablePatient_Master = null; dataTablePatient_Master = objSqlDbComm.ExecuteDatasetQuery(strSQL).Tables[0]; List<String> list = new List<String>(); foreach(DataRow dr in dataTablePatient_Master.Rows) { list.Add(dr["Student_Name"].ToString()); } return list.ToArray(); }
<asp:TextBox ID="txtStudentName" AutoCompleteType="Disabled" CssClass="csstextbox" runat="server"></asp:TextBox> <asp:AutoCompleteExtender ID="txtStudentName_AutoCompleteExtender" runat="server" ServiceMethod="Getdata" OnClientItemSelected="OnItemSelected" CompletionListCssClass="cssautocompletetextbox" MinimumPrefixLength="1" CompletionInterval="1000" EnableCaching="true" CompletionSetCount="1" TargetControlID="txtStudentName" UseContextKey="True"> </asp:AutoCompleteExtender>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)