How to do AutoComplete textbox in asp.net

Question

0.00/5 (No votes)

See more:

Hi EveryBody,

In My Application i want to bind City data to textbox using auto complete Using AJAX toolkit. I am added below source code in my page

XML

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                <ajax:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1"
                MinimumPrefixLength="1"
                EnableCaching="true"
                CompletionInterval="100"
                ServiceMethod="GetSuggessions"
                CompletionSetCount="20"
                ContextKey="strOtherPram">
                </ajax:AutoCompleteExtender>

below is my code where i am retrive city and store in list which is store in Master Class

XML

public static List<tblCity> GetCities(long StateId)
      {

          List<tblCity> result = null;
          using (var context = new HealthEntities())
          {
              result = context.tblCities
                  .Where(c => c.StateId == StateId)
                  .ToList<tblCity>();

          }

          return result;
      }

I am not able to bind data to textbox

Posted 18-Mar-13 23:34pm

Manohar Khillare

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vaibhav10Dec1987 · Answer 1 · 2013-03-19T02:35:00

Solution 1

Refer following site,

http://www.asp.net/ajaxlibrary/act_AutoComplete_Simple.ashx[^]

Posted 19-Mar-13 2:35am

vaibhav10Dec1987

rk_2010 · Answer 2 · 2013-03-19T02:39:00

Hi,
You can call a method thro a service. Add ServicePath in your html. Create a service and call your method. In my code, the method gets data via Stored Proc, which you can eliminate.

XML

<cc1:AutoCompleteExtender ID="AutoCompleteExtender2" runat="server" CompletionInterval="1000"
                       CompletionSetCount="12" EnableCaching="true" MinimumPrefixLength="1" ServiceMethod="FindFileNumberMT"
                       Enabled="true" ServicePath="../AutoFileNew.asmx" TargetControlID="txtFileNumber">
                   </cc1:AutoCompleteExtender>

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Data.Common;

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService()]
public class AutoFileNew : System.Web.Services.WebService
{

	[WebMethod()]
	public string[] FindFileNumberMT(string prefixText, int count)
	{

		List<string> titleArList = new List<string>();
		SqlDataReader dr = null;

		SqlCommand oCmd = new SqlCommand("sp_GetAutoFileNumbersNew",Myapplication.mConn);
		oCmd.CommandType = CommandType.StoredProcedure;
		oCmd.Parameters.Add("@filenumber", SqlDbType.VarChar, 50).Value = prefixText;

		try {
			dr = oCmd.ExecuteReader();
			while (dr.Read()) {
				titleArList.Add(dr["file_number"].ToString());
			}
			return titleArList.ToArray();

		} catch (Exception ex) {
		} finally {
			Myapplication.mConn.Close();
		}
	}

}