User-588203678 posted
Hi,
I have autocomplete textbox in asp.net. it is not working
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeBehind="Default.aspx.cs" Inherits="Sample._Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<!DOCTYPE html>
<head id="Head1">
<title>jQuery AutoComplete with Highlight Search Term using Asp.net</title>
<script src="Scripts/jquery-1.4.1.js" type="text/javascript"></script>
<link href="Scripts/jquery-ui.css" rel="stylesheet" type="text/css" />
<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#txtAutoComplete").autocomplete({
source: function (request, response) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/GetCategory",
data: "{'term':'" + $("#txtAutoComplete").val() + "'}",
dataType: "json",
success: function (data) {
response(data.d);
},
error: function (result) {
alert("Error");
}
});
}
});
});
</script>
</head>
<div>
<input type="text" id="txtAutoComplete" />
</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.SqlClient;
using System.Web.Services;
namespace Sample
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static string[] GetCategory(string term)
{
List<string> retCategory = new List<string>();
string ConnectionString = @"Data Source=DESKTOP-MF5OCIT\GUHANANTH;Initial Catalog=ReportServer$GUHANANTH;Integrated Security=True";
using (SqlConnection con = new SqlConnection(ConnectionString))
{
string query = string.Format("select FName from Employee where FName Like '%{0}%'", term);
using (SqlCommand cmd = new SqlCommand(query, con))
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
retCategory.Add(reader.GetString(0));
}
}
con.Close();
}
return retCategory.ToArray();
}
}
}
It says error
JavaScript runtime error: Object doesn't support property or method 'autocomplete'
