Hi,
I'm using this code for autocomplete
here it is not firing the service method
Admin/PatientAuto1.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="PatientAuto1.aspx.cs" Inherits="Admin_PatientAuto1" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp"%>
<!DOCTYPE html>
<title>
<asp:scriptmanager id="ScriptManager1" runat="server" enablepagemethods="true">
<asp:autocompleteextender enabled="true" servicemethod="GetSearch" minimumprefixlength="4" completioninterval="10"
="" enablecaching="true" completionsetcount="10" targetcontrolid="TextBox1" id="AutoCompleteExtender1" runat="server" firstrowselected="false">
<asp:label id="Label1" runat="server" text="Search Name">
<asp:textbox id="TextBox1" runat="server">
Admin/PatientAuto1.aspx.cs
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.Data.SqlClient;
using System.Configuration;
using System.Web.Services;
public partial class Admin_PatientAuto1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List<string> GetSearch(string term)
{
List<string> listPatientNames = new List<string>();
string cs = ConfigurationManager.ConnectionStrings["CredenceDBConn"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("[dbo].[spGetPatientNames_Vamsi]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@term",
Value = term
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
listPatientNames.Add(rdr["PatientName"].ToString());
}
}
return listPatientNames;
}
}