jQuery tutorial for beginners - Autocomplete textbox using jquery in asp net

5.0 (2)

25 learners

What you'll learn

This course includes

22.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

jquery ajax tutorial jquery ajax tutorial for beginners jquery autocomplete in asp.net jquery autocomplete database jquery autocomplete asp.net textbox jquery autocomplete textbox dropdown jquery autocomplete c# asp net autocomplete textbox in asp net with database using jquery jquery tutorial jquery tutorial for beginners

Full Transcript

Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/06/autocomplete-textbox-using-jquery-in.html Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 In this video we will discuss, how to implement autocomplete textbox using jquery and asp.net. The suggestions should come from the database table. Stored procedure to retrieve employee name suggestions Create proc spGetStudentNames @term nvarchar(50) as Begin Select Name from tblStudents where Name like @term + '%' End StudentHandler.ashx code using System.Collections.Generic; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Web; using System.Web.Script.Serialization; namespace Demo { public class StudentHandler : IHttpHandler { public void ProcessRequest(HttpContext context) { string term = context.Request["term"] ?? ""; List<string> listStudentNames = new List<string>(); string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetStudentNames", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parameter = new SqlParameter() { ParameterName = "@term", Value = term }; cmd.Parameters.Add(parameter); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { listStudentNames.Add(rdr["Name"].ToString()); } } JavaScriptSerializer js = new JavaScriptSerializer(); context.Response.Write(js.Serialize(listStudentNames)); } public bool IsReusable { get { return false; } } } } Download jQuery UI from jqueryui.com. Copy and paste the following files in your project. a) jquery-ui.js b) jquery-ui.css c) images Add a WebForm to the ASP.NET project. Copy and paste the following HTML and jQuery code. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Demo.WebForm1" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script src="jquery-1.11.2.js"></script> <script src="jquery-ui.js"></script> <link href="jquery-ui.css" rel="stylesheet" /> <script type="text/javascript"> $(document).ready(function () { $('#txtName').autocomplete({ source: 'StudentHandler.ashx' }); }); </script> </head> <body style="font-family: Arial"> <form id="form1" runat="server"> Student Name : <asp:TextBox ID="txtName" runat="server"> </asp:TextBox> </form> </body> </html>