Pagination in datagridview in C# windows application

Question

1.00/5 (1 vote)

See more:

I want to achieve 2 functionalities as shown in the following pic:
Want to achieve this

At the top, there is a dropdown box and which contains values like 5, 10, 20, 50 and on changing it, it should display number of records in datagridview as number selected from drop down.
Like if I selected 20, then it should display 20 records in datagridview.
I want to display pagination also as shown in the right hand side bottom.
It should be dynamic and it should be relevant to drop down also.

Note: I am using MYSQL server as backend and fetching data from database using stored procedure.

What I have tried:

I have tried nothing. Just searching for a better solution as per my requirement.

Posted 31-Oct-23 3:09am

Devendra Sarang

Updated 1-Nov-23 10:09am

Deeksha Shenoy

v2

Add a Solution

1 solution

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)

M Imran Ansari · Answer 1 · 2023-10-31T20:48:00

Implementing pagination in a DataGridView in a C# Windows Forms application involves managing the data source and updating the DataGridView's content accordingly. To implement the additional features you've mentioned, you'll need to modify the existing code and add event handlers for the drop-down and pagination functionality. Further, you can take an insight from the example:
A Simple Way for Paging in DataGridView in WinForm Applications[^]