CODEWITHSUNDEEP
vb.netpostgresqldatagridviewpagination
nightfire001
nightfire001

Reputation: 779

Displaying data in grid view page by page

I have more than 30,000 rows in a table. It takes a lot of time to load all the data in the gridview. So I want to display 100 rows at a time. When I click next page button, another 100 rows should be displayed. When I click previous page button, previous 100 rows should be displayed. If I type page 5 in a text box, then I want to jump over to the 5th lot of rows.

I also want to display how many pages there will be. Can we implement this concept in vb.net [winform] gridview. I am using database PostgreSQL.

Can anybody give me a hint or some concept?

Upvotes: 0

Views: 1318

Answers (1)

Erwin Brandstetter
Erwin Brandstetter

Reputation: 659227

Look at OFFSET and LIMIT in PostgreSQL.
Your query for the 5th page could look like this:

SELECT * 
FROM   tbl
ORDER  BY id
OFFSET 400
LIMIT  100;

id is the primary key in my example, therefore an index is in place automatically. If you access the table a lot in this fashion, performance may profit from using CLUSTER.

Total number of pages:

SELECT ceil(1235::real / 100)::int
FROM   tbl;

If you wanted the number rounded down, just simplify to:

SELECT 1235  / 100
FROM   tbl;

With both numbers being integer the result will be an integer type and fractional digits truncated automatically. But I think you need to round up here.

Upvotes: 1

Related Questions