Auto Complete in ASP.NET using Ajax

Raj Kumar

AJAX AutocompleteASP.NET autocomplete dropdownautocomplete ASP.NETAuto complete in ASP.NET

15 Comments

Join the conversation! Your thoughts help the community grow.

Amit Rai15y ago
this is a very nice article C#.net3.5 autocomplete within gridview but wait... i have a table (named- ItemInformation and fields id(PK),ItemCode , Name , Color,Price,Quantity). Now on .aspx page within the gridview(which is empty on form load) i have some textboxes for ItemID,ITemCode,color, Name,Price,Quantity etc.with a button to add a new row. Now i want to apply autocomplete on ITemCode textbox and after selecting from that autocomplete http://www.c-sharpcorner.com/AdRedirector.aspx?BannerId=532&target=http://www.discountasp.net/tfs/go/go.aspx?i=14951values, the other textbox fields such as(name,id ,color,price )are automatically filled regarding to that selected value. plz help me.
Rajai Bhavesh15y ago
Hello...Sir this code garnet in vb.net
black black man16y ago
Thanks
Ahmad Hussain16y ago
Hello, Your sample rocks! despite I need to retrieve selected users id(for ID entry purpose) i.e. I need to display name but I will insert id of select employee. Can you assisst me on this!!! secondly I need to display employee name and employee id respectively but once you select it will only display employee name..is there any way??? Thanks in advance plz reply on [email protected]
Pushpendra Kumar Tripathi16y ago
when we enter any letter how come the data is retrieving
- Raj Kumar16y ago
  data is coming from database according to typed character. download sample application and change connection string, you will understand how it works.
Shivam MAini16y ago
I want to know that can we use Ajax without downloading any additional tool or compiler in .net 3.5. If so then How????? Plz do help me i really need it for submission of my project.
- Raj Kumar16y ago
  if you want to use ajax then u have to download ajax extensions. there are no other way i guess.
Nisse16y ago
The site is "c-sharpcorner" and your eample is in VB???
- Raj Kumar16y ago
  yes u r right. by mistake.
travis17y ago
where does it read from? a database
- Raj Kumar16y ago
  yes web service is reading from database.
bhrugesh thakkar17y ago
gv me same code in c#
- Raj Kumar17y ago
  using System; using System.Collections.Generic; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Data.SqlClient; using System.Data; using System.Data.Common; using AtlasTextBoxAutoComplete.DL; using System.Collections; public class WebService : System.Web.Services.WebService { public string[] FindName(string prefixText, int count) { //return all records whose Title starts with the prefix input string List<string> titleArList = new List<string>(); SqlDataReader drProducts = sqlProductProvider.GetNameList(prefixText); while (drProducts.Read()) { string strTemp = Convert.ToString(drProducts("Name")); titleArList.Add(strTemp); } return titleArList.ToArray(); } }
- Raj Kumar17y ago
  you can use this code converter. http://www.developerfusion.com/tools/convert/vb-to-csharp/

Introduction:

AutoComplete is an ASP.NET AJAX extender that can be attached to any TextBox control, and will associate that control with a popup DropDown like list of words that begin with the prefix typed into the textbox.

Create a new website using ASP.NET Ajax-Enabled Web Site:

Now drag and drop three controls on page. ScriptManager, Textbox, AutoCompleteExtender.

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<div>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<cc1:AutoCompleteExtender ID="AutoCompleteExtender1"

runat="server"

ServicePath="WebService.asmx"

ServiceMethod="FindName"

MinimumPrefixLength="1"

TargetControlID="TextBox1">

</cc1:AutoCompleteExtender>

</div>

</form>

Now add a new WebService class:

Here is web service code.

Imports System

Imports System.Collections.Generic

Imports System.Web

Imports System.Web.Services

Imports System.Web.Services.Protocols

Imports System.Data.SqlClient

Imports System.Data

Imports System.Data.Common

Imports AtlasTextBoxAutoComplete.DL

Imports System.Collections

<WebService(Namespace:="http://tempuri.org/")> _

<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _

<System.Web.Script.Services.ScriptService()> _

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _

Public Class WebService

Inherits System.Web.Services.WebService

<WebMethod()> _

<System.Web.Script.Services.ScriptMethod()> _

Public Function FindName(ByVal prefixText As String, ByVal count As Integer) As String()

'return all records whose Title starts with the prefix input string

Dim titleArList As New List(Of String)()

Dim drProducts As SqlDataReader = sqlProductProvider.GetNameList(prefixText)

While drProducts.Read()

Dim strTemp As String = Convert.ToString(drProducts("Name"))

titleArList.Add(strTemp)

End While

Return titleArList.ToArray()

End Function

End Class

Result will look like this:

I am adding two classes in App_Code folder for database connectivity. You shoudl change your web.config key for database connection string. I am attaching my database in App_Code folder.