void DetectUserName() { SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString); try { SqlCommand commandz = new SqlCommand("SELECT * FROM RegisteredUsers WHERE username = '******'", conn); conn.Open(); SqlDataReader drz = commandz.ExecuteReader(); if (drz.HasRows) { while (drz.Read()) { //lnktagcategory.Text = drz[0].ToString(); lbldetectusername.Visible = true; } } else { lbldetectusername.Visible = false; ClassDataManager addusers = new ClassDataManager(); addusers.Addusers(txtlastname.Text, txtfirstname.Text, txtmiddlename.Text, txtemailaddress.Text, txtuser.Text, txtpassword.Text); lnkLoginPage.Visible = true; } } catch (Exception) { } finally { conn.Close(); } }