Previous and Next buttons SQL and/or ASP.NET c#
Posted on 2009-07-02
I need a little help with soemthing that i'm trying to do, I am a junior to SQL and .NET. I need a sql statement and if possible a asp.net (C#) code aswell that will allow me to switch between dynamic articles from the database.
I have two buttons, Previous and Next. If I am on article ID 12, by clicking Previous it should take me to articleID 11 and If I click next it should take me to article ID 13. So basically whatever article a user is on it should enable them to go back and forward reading the ID from the database/URL.
I need an SQL statement and ASP.NET (C#) code, so that I can get it to work in my project. I have tried to have a go, but can't seem to get it right.
I hope you understand. Any help please ?