Programmatically Access user's ASPNETDB E-Mail?

SeanKilleen · July 19th, 2007, 12:42 PM

Hey all,

I've recently set up membership and profiles using the ASPNETDB structure, which I've ported over to a remote SQL 2005 DB.

I have a form where I need to access the current User's E-Mail and display that in a text box.

Is there a way to grab this value from the DB without having to set up an entire connection to it? I'm referring it to accessing it in a way similar to getting their first name by using my Profile.FirstName variable. If so, how does one do this?

Thanks in advance for any help you can give!

chroniclemaster1 · July 19th, 2007, 01:19 PM

what's the code for your profile tags (in the web.config) look like?

I don't think FirstName is magical. I think Profile sends the application to the web.config, and FirstName has to be one of the items if finds there. That sends it to the database (it sets up the connection automatically from your web.config settings, but it's still hitting the DB) So if you have a profile item Email, then you can just call it the same way, Profile.Email

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

SeanKilleen · July 19th, 2007, 01:22 PM

I'm not actually talking about the profile here; I'm referring more to retrieving the user's e-mail that is stored when the user is created through the built-in membership functionality, so it's not part of the profile.

But, in case you were asking for a different reason, the code is below:

Code:

    <profile defaultProvider="MyProfileProvider">
      <providers>
        <add name="MyProfileProvider"
         connectionStringName="LocalSqlServer"
         applicationName="/"
         type="System.Web.Profile.SqlProfileProvider" />
      </providers>
      <properties>
        <add name="FirstName" defaultValue="Unknown"/>
        <add name="LastName" defaultValue="Unknown"/>
        <add name="PhoneNumber" defaultValue="Unknown"/>
      </properties>

    </profile>

--
Sean Killeen

gbianchi · July 19th, 2007, 01:24 PM

hi there...

did you try this???

Code:

membership.GetUser("username").Email

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

SeanKilleen · July 19th, 2007, 01:39 PM

Worked Perfectly! One more similar question: What about the UserID that's stored in the DB? is it done by username or is there a numerical userID stored too?

--
Sean Killeen

gbianchi · July 19th, 2007, 02:00 PM

that i don't know... but there should be a userid (or something similar)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========