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