SQL Query to fetch records whose date is 7 days greater than current date

You will need to write a query to get events that will happen after 1 week using the current date.

SELECT * FROM Events WHERE DATEDIFF(DAY, GETDATE(), EventDate) = 7

And in Page_Load event of the page you need to call this query