How To change value in sql server Programaticlly in c#

Question

Hello Programmer Please Help Me I have field in Table is called Status=true or false (bit data type) when we insert new team save automatically True ( cmd.Parameters.Add(@Status SqlDbType.Bit).Value =True;) the rotation of this team is 30 days . after 30 days must be Status = False t help you in same field i have StartDate and RotationDate  i need to code in c# or in sql server change automatically Status to False after 30 days . Thanks

Nitin Sontakke · Answer

I think it is only at automatically after 30 days part you are stuck at. There are two ways to go about it. Either have a separate windows console application which will do this for you and have it scheduled for execution. Write a stored procedure to do this and that stored procedure will be executed by the console application. This approach is to GUARANTEE that it happens everyday. You can also have SQL Server Job for this. If it is okay with you to update the table with 1or 2 days delay you can execute stored procedure in you normal application itself.

Nitin Sontakke · Answer

You want to do this only once and you are putting it in master page? This is not a good decision. Please remember that just because you can do something doesn't mean you should do it. Can you even imagine how times your code will run? Just for an example it might run over 100 times but in fact will execute only once. Is it justified. Are you sing SQL Server? Which edition? You are better of wring a job than this. Just issue select @@version and paste the output here.

Nitin Sontakke · Answer

If it has TRUELY helped you please accept one of my replies as answer. Thanks!

Abdalla Elawad · Answer

Thank you Mr.Nitin to resolve the problem professionally .

Nitin Sontakke · Answer

I strongly recommend you to use Scheduled Job. It is very easy and a best solution given your scenario. Just google and you will find loads of resource on how to do it. For example: https://msdn.microsoft.com/en-us/library/ms191439(v=sql.105).aspx You will still need a stored procedure it will be executed as scheduled by you. Hope it helps!

Abdalla Elawad · Answer

Yes I use sql server but I just want to chose the correct way to execute code and i have stored Procedure to Insert Select Thanx

Abdalla Elawad · Answer

Hi Nitin Thank you for Support  i with you your solution is correct but i need to put upadate into MasterPage for application as whole .