Click here to Skip to main content
15,905,229 members
Please Sign up or sign in to vote.
2.50/5 (2 votes)
See more:

I want to create two types of profile in 3.5 with sql server:

1) Free user( only access one month)
2) paid user(according to Paln)

Plan: for 1yr, 2yr and lifetime.

so plz, help me....
Shahriar Iqbal Chowdhury/Galib 29-May-12 4:03am    
Have you tried anything?

1 solution

1. Set the expiry date for the profile when a new user is registering. Also update the expiry date accordingly when the user purchases any plan.

2. Every time the user tried to log into your site, check the expiry date and log him only if his expiry date is greater than the current date

As simple as that
Share this answer
Ambeshchandra 29-May-12 4:26am    
thankx, please give me example....
bbirajdar 29-May-12 4:28am    
For example, a matrimonial site uses the same technique for their users...
Ambeshchandra 29-May-12 5:19am    
have you any code....regarding this query
bbirajdar 29-May-12 7:00am    
SELECT * FROM Users WHERE UserName=@UserName AND Password=@Password AND ExpiryDate > GETDATE()
bbirajdar 29-May-12 9:50am    
Down voted a accepted solution without specifying any reason..?????

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900