organizing big tables in a multi-page format

Question

0.00/5 (No votes)

See more:

How to organize contents of a table to be displayed in multiple pages? Consider you have a table with 100 rows and you want to view 10 rows at a time (Like the way that several Email messages are organized in pages). Do we have a special data structure for this? And how can I add filters to manage it better?

Posted 3-Jan-13 7:14am

cs101000

Updated 3-Jan-13 7:21am

v2

Add a Solution

2 solutions

Solution 1

It looks like what you really need is proper layout CSS styles and, no wonder… proper paging.

There is a number of CodeProject article on this topic which can help you. Please see:
Paging of Large Resultsets in ASP.NET[^],
ASP.NET Pagination[^].

Actually, there a a lot more to look at: http://www.codeproject.com/search.aspx?doctypeid=1&q=%22ASP.NET%22+table+%28paging+OR+pagination%29[^].

Assuming you don't have too many columns, CSS styles can ensure you use all available page width and effectively arrange columns, while paging will be responsible for vertical dimension and control navigation by ranges of rows.

Good luck,

—SA

Posted 3-Jan-13 7:24am

Sergey Alexandrovich Kryukov

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gianmaria Gregori · Accepted Answer · 2013-01-03T12:33:00

The most used way to display data in tabular format from a database in WebMatrix is the WebGrid helper.
It offers a wide variety of options for sorting and paging the rows displayed and supports asynchronously updating the grid content using AJAX.
For a complete class reference look at WebGrid Class[^].
Maybe, the best place for in-depth WebGrid tutorials is the Mike Brind's site[^].
Start with Looking At The WebMatrix WebGrid[^] and then search for more advanced articles.