How to change Status field automatically from Active to Deactivate without crawler or sql agent

By Deepak Sihag in asp.net, SQL 0 Comment
How-to-change-Status-field-automatically-from-Active-to-Deactivate-without-crawler-or-sql-agent

First, let me thanks to my colleague Rajnish for this post.

When a user registers in the database, there is one field status and we manually set it Active(By Default).
When the user reaches his ExpiryDate, we have to set Status field from Active to Deactive by Admin Panel.

We can achieve this in an easy way by simply using Computed Column.

What is Computed Column ?
Continue reading