Display list of first matched values from database in textbo

Question

I want to display a list of matched letter into textbox in search of any text letter in asp.net.I have values in database, how I code to display related values in search. help me. Thanks in advance.

Amit Mohanty · Answer

Hey try this. .aspx "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" /> .aspx.cs 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(); } } }

Ramesh Palanivel · Answer

Hi Priyanka, Please check the below link and it can help you to implement the autocomplete functionality https://www.c-sharpcorner.com/blogs/auto-complete-textbox-using-asp-net-jquery-ajax-call https://www.aspsnippets.com/Articles/Implement-jQuery-AutoComplete-TextBox-from-database-using-AJAX-PageMethods-in-ASPNet.aspx http://www.dotnetawesome.com/2013/12/autocomplete-textbox-without-webservice.html

Neha Trivedi · Answer

Hello Priyanka, You can use like clause in database query. for eg. select * from table where ColName Like '[input]%'