username already exists or not

Question

HI how Check UserName Availability from database using asp.net and sqlserver with example please

Satyapriya Nayak · Answer

Untitled Page BackColor="#FF99FF" Font-Bold="True" Width="329px" onclick="btn_check_Click" /> Width="197px" ForeColor="#FF3300"> ControlToValidate="txtUserName" ErrorMessage="*Name Required"> ForeColor="Black"> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Check_Data_dosenot_exist_database { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str; protected void btn_check_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select count(*)from employee where ename='" + txtUserName.Text + "'"; com = new SqlCommand(str, con); int count = Convert.ToInt32(com.ExecuteScalar()); if (count > 0) { lblMessage.Text = "username exist"; } else { lblMessage.Text = "username doesnot exist"; } } } }

Chandradev · Answer

Hi You can do this task using this approach without any post on clientside http://chandradev819.wordpress.com/2013/03/15/how-to-check-emailid-availability-on-clientside-using-wcf-and-ajax/

KRayudu V · Answer

thx u NAYAK

username already exists or not

how Check UserName Availability from database

Answers (3)