Richard Edwards posted on March 09, 2005 20:41
The aspnet_Profile table contains the following fields: UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary, and LastUpdatedDate. The PropertyNames field contains a string delimited with colons (:) that identify which profile fields are stored, what their datatype is and their offset and length. For instance, in the following example it shows us that the Region field is a string field (S) starting at postion 32 and is 7 characters long.
Website:S:0:23:TimeZone:S:23:4:PreferredLocale:S:27:5:Region:S:32:7:
FirstName:S:39:7:PostalCode:S:46:7:Street:S:53:12:LastName:S:65:7:
Unit:S:72:0:Telephone:S:72:12:Country:S:84:6:IM:S:90:6:Fax:S:96:6:
City:S:102:10:Cell:S:112:12:
Now that we know how the Region field is stored, we can look in another field named PropertyValuesString to find the data. Based on the previous example, we know if we start at position 32 and read for 7 characters we'll get the Region information which in this case is Ontario.
http://www.dnnstuff.com-480en-USOntarioRichardK8N 5W58 Woodley Ct
Edwards613 969-5259CanadaIM1234NO FAXBelleville613 827-5259
For the sake of this article, I'll only be talking about the string fields. The profile does have the ability to store data in a binary format as well, so in that case you would look in the PropertyValuesBinary field for the appropriate data.