Paging in DataGridView using windowsforms?

Kanaparthi Sureshma Reddy

Hi,
I have One DataGridView with 2 buttons Prev and Next.Here in my DataGridView I am using Paging Concept.I have 3 labels to show window no.(1,2..),records count(each page has 5 records only)and showing from to to.In the 1st page I am getting from to to(1-5) value when I click next page the result should as 6-10 and the 3rd page should show as 11-15.I didn't get the 2nd page result as shown above.
(Here my Database consists of 15 records in the Table)
Thanks in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rahul Prajapat11y ago
Accepted answer
hello @sureshma try this :

label2.Text = ds.Tables[0].Rows.Count.ToString();
label3.Text = ((WindowNumber - 1) * RecordCount + 1).ToString() + " to " + (((WindowNumber - 1) * RecordCount ) + ds.Tables[0].Rows.Count).ToString();
Kanaparthi Sureshma Reddy11y ago
It is working fine but if my table consists of 18 records,it shows as 15 to 20 records.But I want to display 15-18 records only..
Rahul Prajapat11y ago
hello @sureshma you can bind the desired data on next or prev button click.
Try this

int WindowNumber = 1;
int RecordCount = 5;
private void loadGridView()
{
string str = "select * from Table1 where id >" + ((WindowNumber - 1) * RecordCount) + " and id <=" + (WindowNumber * RecordCount);
da = new SqlDataAdapter(str, con);
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
label1.Text = WindowNumber.ToString();
label2.Text = RecordCount.ToString();
label3.Text = ((WindowNumber - 1) * RecordCount + 1).ToString() + " to " + (WindowNumber * RecordCount).ToString();
}
private void Form2_Load(object sender, EventArgs e)
{
loadGridView();
}
private void btnNext_Click(object sender, EventArgs e)
{
if (WindowNumber < 3)
{
WindowNumber++;
loadGridView();
}
}
private void btnPrev_Click(object sender, EventArgs e)
{
if (WindowNumber > 1)
{
WindowNumber--;
loadGridView();
}
}