How to create Autocomplete textbox in Content page Asp.net

Question

1

Amit Mohanty · Answer

Hey try this .aspx Page "C#" AutoEventWireup= "true" CodeBehind= "AutoCompleteTextBox.aspx.cs" Inherits= "WebApp1.AutoCompleteTextBox" %> "http://www.w3.org/1999/xhtml" > "server" > "stylesheet" href= "http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" /> "http://code.jquery.com/jquery-1.9.1.js" > "http://code.jquery.com/ui/1.10.3/jquery-ui.js" > .ui-autocomplete { font-size: 11px; text-align: left; } "javascript" type= "text/javascript" > $(function () { $( '# ' ).autocomplete({ minLength: 1, source: function (request, response) { $.ajax({ url: "AutoCompleteTextBox.aspx/GetAutoComplete" , data: "{ 'pre':'" + request.term + "'}" , dataType: "json" , type: "POST" , contentType: "application/json; charset=utf-8" , success: function (data) { response($.map(data.d, function (item) { return { value: item } })) }, error: function (XMLHttpRequest, textStatus, errorThrown) { alert(textStatus); } }); } }); }); "form1" runat= "server" > Auto Complete Textbox Bank Name: class = "ui-widget" style= "text-align: left" > "txtAutoComplete" runat= "server" Width= "350px" CssClass= "textboxAuto" Font-Size= "12px" /> .cs Page using System; using System.Collections.Generic; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web.Script.Services; using System.Web.Services; using System.Web.UI.WebControls; namespace WebApp1 { public partial class AutoCompleteTextBox : System.Web.UI.Page { protected void Page_Load( object sender, EventArgs e) { } [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static List string > GetAutoComplete( string pre) { DataTable dtData = new DataTable(); string conString = ConfigurationManager.ConnectionStrings[ "dbConnection" ].ConnectionString; SqlConnection sqlCon = new SqlConnection(conString); sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand( "Select BankName From BankMaster Where BankName Like '" + pre + "%'" , sqlCon); // SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); sqlDa.Fill(dtData); sqlCon.Close(); return (from row in dtData.AsEnumerable() select row[ "BankName" ].ToString()).ToList(); } } }

Dipa Mehta · Answer

https://www.aspdotnet-suresh.com/2015/05/jquery-autocomplete-textbox-example-in-master-using-webservice-in-aspnet.html?m=1 Find your solution here. Might be it works. Good luck.

Aniket Rana · Answer

Refer These links https://www.c-sharpcorner.com/blogs/autocomplete-texbox-using-jquery-ajax-with-database-in-asp-net2 https://www.aspsnippets.com/Articles/Implement-jQuery-AutoComplete-inside-Master-Page-in-ASPNet.aspx https://www.aspdotnet-suresh.com/2015/05/jquery-autocomplete-textbox-example-in-master-using-webservice-in-aspnet.html

How to create Autocomplete textbox in Content page Asp.net

Answers (3)