private MembershipUser GetUser(SqlStatement sql) { object providerUserKey = sql["UserID"]; string username = Convert.ToString(sql["UserName"]); string email = Convert.ToString(sql["Email"]); string passwordQuestion = Convert.ToString(sql["PasswordQuestion"]); string comment = Convert.ToString(sql["Comments"]); bool isApproved = Convert.ToBoolean(sql["IsApproved"]); bool isLockedOut = Convert.ToBoolean(sql["IsLockedOut"]); DateTime creationDate = Convert.ToDateTime(sql["CreationDate"]); DateTime lastLoginDate = Convert.ToDateTime(sql["LastLoginDate"]); DateTime lastActivityDate = Convert.ToDateTime(sql["LastActivityDate"]); DateTime lastPasswordChangedDate = Convert.ToDateTime(sql["LastPasswordChangedDate"]); DateTime lastLockedOutDate = Convert.ToDateTime(sql["LastLockedOutDate"]); return new MembershipUser(this.Name, username, providerUserKey, email, passwordQuestion, comment, isApproved, isLockedOut, creationDate, lastLoginDate, lastActivityDate, lastPasswordChangedDate, lastLockedOutDate); }