Click here to Skip to main content
14,870,735 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I uses database mysql database
I have data publication date time and expiry date time.

I want to do if expiry date come data delete automatically in my database

how to do in asp.net web application.
Posted

You need to create a SQL server job

http://msdn.microsoft.com/en-us/library/ms187910.aspx[^]
   
Comments
Rahul Rajat Singh 29-May-12 0:25am
   
good suggestion. my 5
bbirajdar 29-May-12 2:40am
   
Thank you Rahul :)
If you want to perform the delete operation from your application by checking rules & integrity of the data, then you can create a job scheduler in your application and set appropriate time to run it.

There are many ways of creating job schedulers in C#, you can try Quartz.Net or
you can try the article below:

C# Scheduler[^]
   
Create Events Scheduler..
Click [^] to know more...
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900