How to check username availability using asp.net (c#)-Like Ajax | Coding Cluster - using asp.net, c#, mvc 4, iphone, php, ios, javascript, in asp.net mvc 3 & more
 

How to check username availability using asp.net (c#)-Like Ajax

Tuesday

Check username availability using ajax style in ASP.NET:
                                                Here I'm checking the username availability  with SQL Server 2005. Here you can download  a sample project that explained to check username availability.In this sample I'm checking username using sql server at the onClick event. And also i'm used three images to represent the status of the user name (In-Progress, UserName Already Exists and UserName Available) see the below images. A please wait progress bar running after click the Check Availability button

                               

If the given user name(vasanth) already exists in the database I've displayed the "UserName Already Exists" image.

                                   

The given user name(vasanth) already exists in the database, so we have check with some other username (here codingcluster). If the given user name( codingcluster ) not exists in the database I've displayed the "UserName Available" image.


 You can download full code for check username availability using asp.net (c#) here. Just download and create  a virtual directory.(Before, you have create a database by using UserAvailability_SQL.txt)

3 comments:

rajkumar_k88 said...

nice Article.....it was useful for my project

I want to check Two columns like Username And Email Id
plz Give me complete source code
Send my mailID:mandla.anilbabu@gmail.com
plz help me

Coding Cluster said...

Dear Anil Babu,
To check two columns availability, you could change the following line from

//SqlDataAdapter for thw query execution.
SqlDataAdapter adp = new SqlDataAdapter("select * from user_details where UserName=@name", con);
adp.SelectCommand.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = txtUserName.Text;

to like...

//SqlDataAdapter for thw query execution.
SqlDataAdapter adp = new SqlDataAdapter("select * from user_details where UserName=@name AND EmailID= @email", con);
adp.SelectCommand.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = txtUserName.Text;
adp.SelectCommand.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = txtEmailID.Text;

(I've sent a mail to you)

Post a Comment

Share your thoughts here...

 
 
 

RECENT POSTS

Boost

 
Blogger Widgets