| Author: Vadivel Mohanakrishnan 22 Apr 2007 | Member Level: Diamond | Rating:  Points: 2 |
1. If 'Password' is common no need to alert. Two person's can have same password also within a single site.
2. Yes 'User name' needs to be unique. That validation you need to do it in your stored procedure. Once a user tries to registering into your site with a 'username' and 'password' take that information to your stored procedure. And with a select statement check whether that username already exists in that table. If it exists return an error message from the stored procedure.
3. If not, you can pass an integer value for failure from the stored procedure. In your front end code, on seeing this integer value display an error message on a lable control.
|
| Author: Anoop George 22 Apr 2007 | Member Level: Gold | Rating: Points: 2 |
Thank You Vadivel...It was greattttttt
|
| Author: Vadivel Mohanakrishnan 22 Apr 2007 | Member Level: Diamond | Rating: Points: 2 |
Most Welcome anup. Glad that it helped :)
|