jQuery tutorial for beginners - Load data on page scroll using jquery

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 page scroll load data jquery load data while scrolling page down with jquery load content while scrolling with jquery jquery auto load on scroll 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/load-data-on-page-scroll-using-jquery.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 load more data on page scroll using jQuery AJAX. This is similar to Facebook. As you scroll down on the page more data will be loaded. When the page is initially loaded we want to retrieve and display the first 50 rows from the database table tblEmployee. As we scroll down and when we hit the bottom of the page we want to load the next set of 50 rows. Stored procedure Create procedure spGetEmployees @PageNumber int, @PageSize int as Begin Declare @StartRow int Declare @EndRow int Set @StartRow = ((@PageNumber - 1) * @PageSize) + 1 Set @EndRow = @PageNumber * @PageSize; WITH RESULT AS ( SELECT Id, Name, Gender, Salary, ROW_NUMBER() OVER (ORDER BY ID ASC) AS ROWNUMBER From tblEmployee ) SELECT * FROM RESULT WHERE ROWNUMBER BETWEEN @StartRow AND @EndRow End HTML page <!DOCTYPE html> <html> <head> <script src="jquery-1.11.2.js"></script> <script type="text/javascript"> $(document).ready(function () { var currentPage = 1; loadPageData(currentPage); $(window).scroll(function () { if ($(window).scrollTop() == $(document).height() - $(window).height()) { currentPage += 1; loadPageData(currentPage); } }); function loadPageData(currentPageNumber) { $.ajax({ url: 'EmployeeService.asmx/GetEmployees', method: 'post', dataType: "json", data: { pageNumber: currentPageNumber, pageSize: 50 }, success: function (data) { var employeeTable = $('#tblEmployee tbody'); $(data).each(function (index, emp) { employeeTable.append('<tr><td>' + emp.ID + '</td><td>' + emp.Name + '</td><td>' + emp.Gender + '</td><td>' + emp.Salary + '</td></tr>'); }); }, error: function (err) { alert(err); } }); } }); </script> </head> <body style="font-family:Arial"> <h1>The data will be loaded on demand as you scroll down the page</h1> <table id="tblEmployee" border="1" style="border-collapse:collapse; font-size:xx-large"> <thead> <tr> <th>ID</th> <th>Name</th> <th>Gender</th> <th>Salary</th> </tr> </thead> <tbody></tbody> </table> </body> </html>