SqlCommand cmd = new SqlCommand("USP_Web_Member_Add", conn)
                        {
                            CommandType = CommandType.StoredProcedure
                        };

                        // 3. add parameter to command, which will be passed to the stored procedure

                        cmd.Parameters.AddRange(new[]
                        {
                         new SqlParameter("@sUserId", UserID),
                         new SqlParameter("@sPassword", encryptedPass),
                         new SqlParameter("@sNickName", Nickname),
                         new SqlParameter("@sEMail", Email),
                         new SqlParameter("@nMailling", Mailing),
                         new SqlParameter("@nUserType", UserType),
                         new SqlParameter("@nJoinType", JoinType),
                         new SqlParameter("@nGender", Gender),
                         new SqlParameter("@sUserIP", UserIP),
                         new SqlParameter("@sUserBirthday", UserBirthday),
                         new SqlParameter("@nUserNumber", UserNumber),
                         new SqlParameter("@sActiveCode", ActiveCode),
                     });
                        //cmd.Parameters.Add("@retValue", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;

                        //int retval = (int)cmd.Parameters["@retValue"].Value;
                        //open connection
                        conn.Open();

                        //execute the SQLCommand
                        SqlDataReader dr = cmd.ExecuteReader();

                        //Console.WriteLine(retval);
                        //check if there are records

                        dr.Close();