We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Alert User to change password.

rajputamitd
rajputamitd asked
on
Medium Priority
618 Views
Last Modified: 2013-12-17
Hi,

I am using SQL2005 n .Net 3.5

I have a field in my table as Updatedate which contain last update date of the password.

Now I want to force user to change his password after 60 days.Before this,I want to remind him for the password change from 54th day.

6 days left.
55th day 5 days left
..........
.........
60 th day.0 days left and now you have to change the password.

How to do this?
Comment
Watch Question

Commented:
create a stored procedure to control the password expiration and prepare your massages. In your application do always call this procedure while user login in as the first job. And take the required steps that neede to do...

Author

Commented:
Can you guide me or show an example how to write such store procedure.
 
Thank u.
Commented:
Either try this in code behind.
Just take the date value from updatedate field. Take days from the Date. Subtract it from Current date.

Then check it the number of days is greater than 53.
if(dt >53)
{
     int days = 60 - dt;
     label1.text = days + "days left";
}

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks 4 ur reply.I'll try it later n let you know.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.