nest,previous,first,last button click display data on page

Jigar Patel

hi,

i create windows c# application. in which i put button like first,next, last,previous.

now i want to display record fetch from database , and show in page.

when i click first button then on load time data display first. when i click last then data display last record, when i click previous then data dispaly previous, and when i click next then display data next in c# windows application.

pls help me...

3 Replies

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

Vinay Singh10y ago
Hi

First check the link

https://www.mindstick.com/Articles/131/inserting-data-and-fetching-records-from-database-in-c-sharp-dot-net

OR

You can use the different sql query for fatching data as per you need
First:

SELECT TOP 1 * FROM MyTable WHERE Id > lastRow ORDER BY ID ASC

If you get any rows, load lastRow with the ID value.

For "Next" it's the same query.

For previous :

SELECT TOP 1 * FROM MyTable WHERE Id < lastRow ORDER BY ID DESC

First:

SELECT TOP 1 * FROM MyTable ORDER BY ID ASC

Last:

SELECT TOP 1 * FROM MyTable ORDER BY ID DESC
Jigar Patel10y ago
i am not use gridview.
i just save record in database , and display in form.
Vinay Singh10y ago
Hi
Check the below link
Paging in DataGridview Using C#.Net In Windows Application