Page 2 SQL to update a user profile item

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

Home

Development and...

SQL and SQL Ser...

SQL to update a user profile item

6/26/2010 9:16 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: SQL to update a user profile item

FYI: there are additional user data stored in aspnet_* tables

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/26/2010 10:19 AM

Chris Wolverton

Joined: 1/12/2008

Posts: 27

Re: SQL to update a user profile item

Sebastian,

Thanks for the additional information.
Okay, let's say I add the new ProfileProperty throught the "Manage Profile Properties" page.
Then I use a series of SQL statement to check if the newly added PropertyDefinitionID exist, in dbo.UserProfiles, for a specified UserID.
If not I add the necessary fields else I update the value to the desired value.
Do you think I have to worry about the aspnet_ * tables at any point here?

Thanks again

6/26/2010 10:54 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: SQL to update a user profile item

Chris, aspnet_profile table is no longer used, only membership and users, i.e. any modifications to profile properties in DNN UI affect ProfilePropertyDefinitions and UserProfiles tables only. If you are creating custom modules, you should access profile data using DNN business objects instead of accessing database yourself. If you are trying to access it from another application, you have to access database or use web services you create in your DNN (see iweb.adefwebserver.com). Accessing the database directly is not suggested, as the structure may change in the future and data you change may not be effective in DNN immediately due to caching.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

6/26/2010 10:55 AM

Mark Breen

www.margin.ie
Joined: 11/19/2008

Posts: 142

Re: SQL to update a user profile item

Hello Chris,

I think that Sebastian was pointing out that those tables exist and may at some point in the future be interesting. For your profile work, you will not need to worry about them, other than for night time reading when you have an iPad.

I live in hope,

Mark

Mark Breen Ireland 1987 BMW R80 g/s

6/26/2010 5:11 PM

Chris Wolverton

Joined: 1/12/2008

Posts: 27

Re: SQL to update a user profile item

Once again I thank you both for the information; however, I am left with only one question. What to heck is an iPad and why would anyone want one?:)

Page 2 of 3

SQL to update a user profile item

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)