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);
}