Navigate Records in WinForm C#

Question

Hello Members,

I am working on a WinApp and trying to nevigate records with Next and Previous buttons. I have searched on net and there are too many solutions but none if them working for me or I might not able to understand.

I have also tried... https://www.c-sharpcorner.com/UploadFile/syedshakeer/how-to-display-records-as-first-next-previous-last-in-a-textboxes-using-windows-application/

but not succeded.

In my form I want records in TextBoxes one by one when click on next or previous button.

while clicking the previous button I can see the last record (as I have written the query as DESC order as there are no First or Last button because when a user clicks on previous button, the latest record will display first and then older records.) but afterwards no records updating in the form.

I have attached my code and the data table (screen shot)

Please check and guide me how to do this.

 

Thanks

 

Mayank Jani