Nowadays, a web page contains continuous pagination to deal with retrieving lot of data.
This continuous pagination means data views per page doesnt requires to reload a whole page to get next / previous page. It partially reload and attached next data on same page.
So it makes seemingly endless scroll.
This blog post will give you an example on how to do this continuos paging using Asp .Net Ajax capabilities.
Database & Query
I use SQL Server 2008 Northwind Database as sample. Spesifically use Orders, OrderDetails, Products, Employees and Customers tables.
I will make a list of sales transaction along with purchased products, customers and salesman or employees. Total value also being presented.
Below are list of design of tables I used. These list converted into create table statement.
Posted in ASP .Net
Tagged Ajax, ASP .Net, Endless Scroll, row_number, ScriptManager, Sql Server 2008, Table Control, UpdatePanel, UpdateProgress, Web Pagination, web paging
Any table like objects like array and recordset have same structure. They have rows and columns.
Usually column is a key and row is a value.
A recordset that comes from database ‘select’ operation usually stored in array or OOP object variable on MVC concept or any kind of business logic and view layer.
A web page access this variable to show its data. View layer only include database and datatable class files. So web page users doesn’t access database operational directly.
With this concept, I have build a simple DataTable class to store those kind of objects.
This DataTable has functions to add columns and rows and get their values so that we can extract information from DataTable with easy and use same methods repeatedly.
Also we can get DataTable object value on another page with SESSION functionality.
Posted in PHP
Tagged DataTable, DB2, db2_close, db2_connect, db2_fetch_array, OOP, PHP, PHP Example, PHPExcel, session, web paging