I have an sql Database table in MySQL which have lots of rows with varied date time values. For example:

2012-08-21 10:10:00   <-- with these date there are around 12 rows
2012-08-21 15:31:00   <-- with these date there are around 5  rows
2012-08-22 11:40:00   <-- with these date there are around 10 rows
2012-08-22 12:17:00   <-- with these date there are around 9  rows
2012-08-22 12:18:00   <-- with these date there are around 7  rows
2012-08-25 07:21:00   <-- with these date there are around 6  rows

If the user clicks on the SpinButton1_SpinUp() or SpinButton1_SpinDown() button then it should do the following:

The SpinButton1_SpinUp() button should filter out those data from an sql table which is the next after what we are currently on now. Example: We have currently selected: 2012-08-21 15:31:00. The user hits the SpinUp button then the program selects those date from the database, which is the next higher value like this one: 2012-08-22 11:40:00. So the user hits the SpinUp button the data which is selected in the database will change from those with date: 2012-08-21 15:31:00 to those with date: 2012-08-22 11:40:00

The SpinButton1_SpinDown() will do exactly the reverse of the SpinUp button. When the user hits the SpinDown button the data which is selected in the database will change from those with date: 2012-08-21 15:31:00 to those with date 2012-08-21 10:10:00

So I think the date which we are currently on, should be stored in a variable. But on button hit not every bigger or lower data should be selected in the database, only those which are the closest bigger or the closest lower date.

How can I do this?

I hope I described my problem understandable. My native language is not english, so misunderstandings can occur! Please ask if you don't understand something! Thank you for reading!