Automatically update database Table at specific time using C# and VB.Net in ASP.Net

Question

In my code while inserting i am entering statusNEW Then i want to update this statusPENDING after 1 day24 hours automatically Can anybody suggest proper query and where this query to be place in the form

dharmendr · Accepted Answer

Hi sambathYou need to create Windows Service The Windows Service will run on every hour Interval and will automatically trigger a method to fetch records from database and check the status column if the value is new then update it to pendingRefer below articlesSimple Windows Service that runs periodically and once a day at specific time using C and VBNetAutomatically send emails daily at specific time using Windows Service in C and VBNet

Automatically update database Table at specific time using C# and VB.Net in ASP.Net

Simple Windows Service that runs periodically and once a day at specific time using C# and VB.Net

Automatically send emails daily at specific time using Windows Service in C# and VB.Net

Company

Explore

Follow us

Contact Us