What table holds user info like address? - Modules

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

What table holds user info like address?

4/9/2013 10:18 PM

Mark Eckeard

Joined: 1/19/2004

Posts: 924

What table holds user info like address?

All,

What table(s) hold address and other account information for users? I have a userID and now need to look up their address and a few other custom fields that I added to the registration process but I can't find all the data I need.

Thanks,
Mark

4/10/2013 3:24 AM

Richard Howells

www.dynamisys.co.uk
Joined: 3/26/2006

Posts: 2001

Re: What table holds user info like address?

I think the correct approach here is NOT to look directly in the tables.

I don't know the details here, but I would expect there to be somthing like a 'properties controller' class that will retrieve them for you. If you use the tables directly then you risk your code being broken by some future upgrade.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk

4/10/2013 4:17 AM

Sunil Kumar

Joined: 10/18/2012

Posts: 410

Re: What table holds user info like address?

Hi

There are 2 tables ProfilePropertyDefinition and UserProfile. By joining the 2 you can get the account information for users and Yes,direct use of tables will be a risk.

Thanks,
Sunil Kumar [ DNN Developer, Mindfire Solutions,India ]

4/10/2013 6:52 AM

Mark Eckeard

Joined: 1/19/2004

Posts: 924

Re: What table holds user info like address?

I'm OK with using an available DNN API if that's available. If so, would anyone have some code samples or general direction?

Thanks,
Mark

4/10/2013 7:13 AM

Richard Howells

www.dynamisys.co.uk
Joined: 3/26/2006

Posts: 2001

Re: What table holds user info like address?

Google?

http://www.dotnetnuke.com/Resources/F...

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk

Page 1 of 2

1

What table holds user info like address?

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)