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