expire the use of application after that date

Question

hi, i am using window application in C# using Sql server 2005 management studio.i want to set the particular date after that application stopped working.Is there anyway in sql server.So that nobody can run it again.

Ankit Gupta · Answer

Gautam Parmar There is no Login page i have database only. the front end i have exe only thats why i wana restrict it on backend.

Gautam Parmar · Answer

Just add expire date in Login of user it will automatically cover all criteria.

Ankit Gupta · Answer

hi, i want to restrict at backend not frontend. i want to restrict it from database.

Kanimozhi Shivakumar · Answer

Yes Jaish you are correct.. I just mentioned the logic to restrict the application when date is expired.. I didn't mean that what ever I mentioned he have to follow that.. I just given example thats it.. Dates he should decide how it should work. May be expiry date can be hard coded or he can take it from DB...DateTime.now ---> I mentioned for only logic.. He can take server date also... I just given example of what logic he is looking.

Jaish Mathews · Answer

Frankly speaking if someone changed their machine calendar to an old date than current date before running application, then you still able to crack this approach :) . So ideally your logic should be on top of both static values i.e. Date it activated and the expiry date at the time of activation... That's why most enterprises have their own servers&services to keep licensing information so that license check won't happen locally inside user machine, but inside product servers.

Jenith Thakkar · Answer

Yes Jaish is Right you can do this using Kanimozhi Logic but just one thing you need to do Store One Date in Database then Fetch that date and write DateTime dtExpiryDate=Get Date from Database in place of DateTime dtExpiryDate = DateTime.Now.AddDays(-1); and Other things private void frmMdiForm_Load(object sender, EventArgs e) { if (DateTime.Compare(dtExpiryDate, DateTime.Now) { MessageBox.Show("License expired..Please Contact Admin Department....."); this.Close(); } else { // Code for initialize MDI parent form } }

Jaish Mathews · Answer

@Kanimozhi M Below line DateTime dtExpiryDate = DateTime.Now.AddDays(-1); Normally thick client applications won't run full day, but close it end of day and open again next day. So each day if application open, dtExpiryDate will reset each time. So ideally expirydate should only set during very 1st run and need to store that value somewhere. then take that stored expiry value during each further run.

Kanimozhi Shivakumar · Answer

Hi , please try this below code. DateTime dtExpiryDate = DateTime.Now.AddDays(-1); private void frmMdiForm_Load( object sender, EventArgs e) { if (DateTime.Compare(dtExpiryDate, DateTime.Now) { MessageBox.Show( "License expired..Please Contact Admin Department....." ); this .Close(); } else { // Code for initialize MDI parent form } }