I'm current using Visual Studio 2010 to work on my application. I have encountered a problem regarding calculating the date difference in days using the current date and eventdate column in my database.
This is what I'm going to show the user.
If the text in dropboxlist = recent, events 7 days from current date will be shown in gridview.
I do not know the correct SELECT Statement to use.
Thanks in advance