How To change value in sql server Programaticlly in c#

Abdalla Elawad

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted 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 Sontakke9y ago
If it has TRUELY helped you, please accept one of my replies as answer. Thanks!
Abdalla Elawad9y ago
Thank you Mr.Nitin to resolve the problem professionally .
Nitin Sontakke9y ago
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 Elawad9y ago
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
Nitin Sontakke9y ago
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.
Abdalla Elawad9y ago
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 .