How to create a Unique UserName

Question

0.00/5 (No votes)

See more:

Dear Experts !! am working on Asp.net,c#,sqlserver 2005

In my project, i have a Registration Form. and also i have Registration Table in database.
So i need to create a Usernames as Unique.

Suppose if the User Registered with one name and the other users should not create with this name.

So , i need a Message like Already Exists with this Name, Try another name.

Please Suggest me, and help me, How to do this ?

Thanks.

Posted 25-May-12 19:30pm

Ranjith Reddy CSE

Add a Solution

Comments

Rahul Rajat Singh 29-May-12 0:22am

The answer that you have marked as solution seems to be perfect. but I would like to suggest that you do it on client side using XMLHttpRequest or MS Ajax stuff so that the web page you are making will be more responsive.

6 solutions

Solution 2

hey

you can do this in your stored procedure simply

try this

SQL

as
begin
if exists(select user_Name from Tbl_name where UserName= @userName )
begin
select 0
end
else
begin
-- Here write your insert query ---
end 
begin
select 1
end

after writing this take a lable near your text box and show your message.
Hope this will help you.

Posted 25-May-12 19:50pm

abhinavashubajpai

Updated 25-May-12 21:11pm

v2

Solution 3

In my opinion the best way to handle this is to define the user name as unique in the database. This way the database would generate and error (which you can then catch as an exception) if the username already exists.

See: SQL UNIQUE Constraint[^] and UNIQUE Constraints[^]

Posted 25-May-12 21:13pm

Wendelius

Solution 5

Check this

http://encosia.com/aspnet-username-availability-checking-via-ajax/[^]

http://stackoverflow.com/questions/8900162/instant-check-username-availability-in-asp-net-using-ajax[^]

Posted 28-May-12 3:19am

bbirajdar

Solution 4

Understanding ASP.NET Roles and Membership - A Beginner's Tutorial[^]

Posted 28-May-12 3:09am

dharan1990

Solution 6

C#

string duplicate = "select uname from table name where uname = '"+txtuname.text+"'";
SqlDataAdapter da = new SqlDataAdapter(pass,con);
DataSet ds = new DataSet();
da.fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
          //***Already Exits**//
          response.write("<script>alert('Already Exits')</script>");
          txtuname.focus();
}
else
{
          //*****new user code***//
          //insert qurey here
}

if you have any query fill free to contact
Thank You

Posted 28-May-12 4:26am

Yatin_Chauhan

Updated 28-May-12 18:20pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Mits Machhi · Accepted Answer · 2012-05-25T19:42:00

You can use TexboxChanged Event and make textbox property Autopostback True.

now in Textbox changed Event :

C#

 string pass="select username from tablename where username='"+txt_username.Text+"'";
SqlDataAdapter ad = new SqlDataAdapter(pass,connection object);
DataSet ds = new DataSet();
ad.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
            //Means Already Exits....
         txt_username.Focus();
//Display Message like Already Exits...
}
else
{
           // Means New USer
}

Enjoyyyy
Mitesh