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)
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.
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)
Posts
3 comments:
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
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...