Hi,
I am new in asp.net c#. Now I have a simple project, I have a Default.aspx page, on that page I insert records in sql server by button click, on the buttom part of page I have add a datalist to display inserted records. Now, when I upade records form datalist, there is a dropdownlist with some option with name End Task, When I choose End Task option from dorpdown and click on update button, then after five minutes that record should be delete from the buttom part of datalist, or It should be hide forever after 5 minutes,
among all of you, Could someone please help me?? Thanks in advance !!
Aman GuptaPosted Sep 5, 2022, 4:00 PM
Create a stored procedure something like this:
CREATE PROCEDURE dbo.DeleteOnSchedule AS BEGINDELETE [dbo].[Table]WHERE [DateTimeToDelete] <= CURRENT_TIMESTAMP; END
Then run that procedure on a scheduled basis.