retrieving 1 row from the database based upon date

[taffer23]

i was writing a c# program where i have certain data in the database.i want my program to retrieve 1 row from the database depending upon the date, and as soon as the date changes it should retrieve the second row.any ideas

[kenobewan]

Each row should have a unique id and the date change needs to trigger an event calling the function to run the next query. HTH.

[taffer23]

how can i do the datechange event tigger because i am fairly new to c# ,i was trying to make a facebook app

[taffer23]

Each row should have a unique id and the date change needs to trigger an event calling the function to run the next query. HTH.

how can i do the datechange event tigger because i am fairly new to c# ,i was trying to make a facebook app