Go through my Code given bellow;
Add This in .aspx page
<asp:textbox id="txtSearchUserName" runat="server" width="400px" xmlns:asp="#unknown">
<asp:AutoCompleteExtender ServiceMethod="GetProductList"
MinimumPrefixLength="1"
CompletionInterval="0" EnableCaching="false" CompletionSetCount="10"
TargetControlID="txtSearchUserName"
ID="autoCompleteExtender1" runat="server" FirstRowSelected ="true">
</asp:AutoCompleteExtender>
<asp:button id="btnSearchUserName" runat="server" xmlns:asp="#unknown">
OnClick="btnSearchUserName_Click" Text="Search" />
Put the code in .cs Page as given bellow,
[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static string[] GetProductList(string prefixText, int count)
{
using (var context = new YourDataBaseConnection())
{
var UserwebinarList = context.TableName.Where(c=>c.UserName!=null && c.IsActive==true) ;
List<String> userList = new List<String>();
foreach (var item in UserwebinarList)
{
userList.Add(item.UserName);
}
var list = from p in userList
where p.StartsWith(prefixText) || p.Contains(prefixText)
select p;
string[] prefixTextArray = list.ToArray<String>();
return prefixTextArray;
}
}