Sandeep

Sandeep

  • NA
  • 26
  • 5.2k

CHECK USERNAME EXIST IN DATABASE

Nov 19 2010 4:44 AM
string name = txtname.Text.ToString().Trim();
        string gender = ddlgen.SelectedValue.ToString().Trim();
        string dob = txtdob.Text.ToString().Trim();
        string deslog = txtlog.Text.ToString().Trim();
        SqlConnection regcon = new SqlConnection(ConfigurationManager.AppSettings["regis"].ToString().Trim());
        SqlCommand cmd = new SqlCommand("logreg", regcon);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = txtname.Text.ToString().Trim();
        cmd.Parameters.Add("@gender", SqlDbType.Char).Value = ddlgen.SelectedValue.ToString().Trim();
        cmd.Parameters.Add("@dob", SqlDbType.NVarChar).Value = txtdob.Text.ToString().Trim();
        cmd.Parameters.Add("@deslog", SqlDbType.NVarChar).Value = txtlog.Text.ToString().Trim();
        regcon.Open();
        cmd.ExecuteNonQuery();
        regcon.Close();

        
         ALREADY I HAVE INSERTED THE FORM VALUE IN THE DATABASE AND I WANT TO SHOW THAT IT CHECK THE EMAIL ID EXIST THEN ----USERINVALID
OTHERWISE SAVED IN DATABASE


Answers (1)