Autocomplete textbox Nothing Happen

Hi everyone,

This my Code when i run it Nothing Happen

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div id="page-wrapper" >
<div class="col-md-12">
<div class="panel panel-info">
<div class="panel-heading">
<h3 style="text-shadow: 2px 2px #79aed8;">PRODUCT ENTRYh3>
div>
<div class="panel-body">
<table>
<tr>
<td>
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="True">asp:ScriptManager>
<asp:Label ID="lblEmployee" Text="Employee Search" runat="server">asp:Label>
td>
<td>
<asp:TextBox ID="txtPcode" runat="server" Width="200" placeholder="Employee Name">asp:TextBox>
<ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtPcode" ServiceMethod="getname" EnableCaching="True" MinimumPrefixLength="1" CompletionInterval="10" CompletionSetCount="1"> ajaxToolkit:AutoCompleteExtender>
td>
tr>
table>
div>
div>
div>
div>
asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Script.Services;
using System.Web.Services;
namespace Product
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[ScriptMethod()]
[WebMethod]
public static List<string> getname(string name)
{
SqlConnection con;
SqlCommand cmd;
con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcon1"].ConnectionString);
cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
string query = "select * from Product where subhead like '%'+ @searchname +'%'";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@searchname", name);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
List<string> names = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
names.Add(dt.Rows[i][i].ToString());
}
return names;
}
}
}

Please help me to how to implement auto complete textbox

Thanks ....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ashutosh Gupta6y ago
check c sharp corner artcile, this may help
https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/jquery-auto-complete-text-box-in-Asp-Net-C-Sharp/
Rajanikant Hawaldar6y ago
https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/jquery-auto-complete-text-box-in-Asp-Net-C-Sharp/ https://www.c-sharpcorner.com/UploadFile/da55bf/Asp-Net-autocomplete-textbox-using-jquery-json-and-ajax/