How to use autocompleteextender Ajax Control example with textbox in asp.net
// For Sql Server 2008 ……………………………..
create database test
use test
create table StateName(SrNo int identity(1,1),StateCode nvarchar(50) primary key,StateName nvarchar(50) unique)
insert into StateName values('Mahar11','Maharashtra')
insert into StateName values('Madhy11','Madhya Pradesh')
insert into StateName values('Manip11','Manipur')
insert into StateName values('Megha11','Meghalaya')
select * from
StateName
// Create
connectionstring in web.config file……………………………
<connectionStrings>
<add name="kush" connectionString="Data
Source=KUSH-PC\KUSH;Initial Catalog=test;Integrated Security=True"/>
</connectionStrings>
// How
to apply AutoCompleteExtender
on textbox.........................
<%@ Register assembly="AjaxControlToolkit"
namespace="AjaxControlToolkit"
tagprefix="asp"
%>
<!DOCTYPE html PUBLIC
"-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table width="500px" border="5px">
<tr><td colspan="2">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1"
runat="server">
</asp:ToolkitScriptManager></td>
</tr>
<tr><td>
<asp:Label ID="Label1" runat="server" Text="StateName"></asp:Label>
</td><td>
<asp:TextBox ID="txtstatename" runat="server"></asp:TextBox>
// after add AutoCompleteExtender write
this code …………………..
<asp:AutoCompleteExtender ID="txtstatename_AutoCompleteExtender" runat="server"
MinimumPrefixLength="1"
EnableCaching="true"
CompletionSetCount="1"
CompletionInterval="1000"
ServiceMethod="GetStateNames"
TargetControlID="txtstatename">
</asp:AutoCompleteExtender>
</td></tr>
</table>
</div>
</form>
</body>
</body>
</html>
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.Configuration;
using System.Data;
public partial class AutoExtenderExample
: System.Web.UI.Page
{
protected void Page_Load(object
sender, EventArgs e)
{
}
[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string>
GetStateNames(string prefixText)
{
SqlConnection
con = new SqlConnection(ConfigurationManager.ConnectionStrings["kush"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("select
* from StateName where StateName like @State+'%'", con);
cmd.Parameters.AddWithValue("@State", prefixText);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
List<string>
StateNames = new List<string>();
for (int i = 0; i
< dt.Rows.Count; i++)
{
StateNames.Add(dt.Rows[i][2].ToString());
}
return StateNames;
}
}
0 comments:
Post a Comment