nestpreviousfirstlast button click display data on page

Question

hi i create windows c# application. in which i put button like firstnext lastprevious. 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...

Vinay Singh · Answer

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 First: SELECT TOP 1 * FROM MyTable ORDER BY ID ASC Last: SELECT TOP 1 * FROM MyTable ORDER BY ID DESC

Jigar Patel · Answer

i am not use gridview. i just save record in database  and display in form.

Vinay Singh · Answer

Hi Check the below link Paging in DataGridview Using C#.Net In Windows Application

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