aspnet membership database

Question

we are using aspnet membership database, in aspnet_prifile table, there is a field called property name and propertyvalues binary.

we are storing all of the user attributes like name, email, phone, etc in the column propertyvalues binary.

the propertyname colimn has a column values  somehing like this Item:B:0:530:

i want to be able read the user attributes through the propertvaluesbinary column(it has all the attribute values for a given user).

please somene give me suggetions on how to get the user attributes.

 

thanks for any response.

nik

Answer 1

I believe you have to use the Profile class.

ProfileCommon p = Profile.GetProfile("xxx");

txtName.Text = p.FirstName + " " + p.LastName;

txtEmail.Text = p.Email;

...

Answer 2

without using asp, i want to be able to retrieve from sql server.

 

any way to do that using CLR or something

 

thnks

 

nik

Answer 3

I haven't tried it, but can you try SELECT sys.fn_sqlvarbasetostr(<column>) FROM <table>

That should return the binary as a string and then you can work from that.

Answer 4

the propertyname colimn has a column values  somehing like this Item:B:0:530:

The fnSplitStringListXML function will return the delimited values in table format at the following link:

http://www.sqlusa.com/bestpractices/training/scripts/userdefinedfunction/

Let us know if helpful.

---

Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Answer 5

thnks sqlusa,

in our database, the property name column has  something like this Item:B:0:911 and property vales binary has hexadecimal data something like

0x0001000000FFFFFFFF01000000000000000C02000

the above hexadecimal data when converted to char gives very unorganized format as shown below:

ÿÿÿÿ
OIAMembership, Version=1.0.0.0, Culture=neutral, PublicKeyToken=5236e35bb97009ed
IAMembership.IAProfileItemm_propm_name
System.Collections.Hashtable		testuser5System.Collections.Hashtable
LoadFactorVersionComparerHashCodeProviderHashSizeKeysValuesSystem.Collections.IComparer$System.Collections.IHashCodeProvider�Q8?¢

		ldapOrgUnitldapCountryHRIS	cn
ldapSegment
accountStatussn
officePhoneslbAliasldapBillableEntity	givenNamepasswordldapRefreshDate	pendingQCldapBizArea+00035631-DXIT000-Photon Infotec ConsultantsIN		Corporate
1slb5+1 303 486 (switchboard)AEphremSTHS-Schlumberger Info Solutio	testuser5********
@lω°�̈ 
0!D000-OFS ITSA Contractor

how to get the columns out of the above data?

 

Answer 6

thnks sqlusa,

in our database, the property name column has  something like this Item:B:0:911 and property vales binary has hexadecimal data something like

0x0001000000FFFFFFFF01000000000000000C02000

the above hexadecimal data when converted to char gives very unorganized format as shown below:

ÿÿÿÿ
OIAMembership, Version=1.0.0.0, Culture=neutral, PublicKeyToken=5236e35bb97009ed
IAMembership.IAProfileItemm_propm_name
System.Collections.Hashtable		testuser5System.Collections.Hashtable
LoadFactorVersionComparerHashCodeProviderHashSizeKeysValuesSystem.Collections.IComparer$System.Collections.IHashCodeProvider�Q8?¢

		ldapOrgUnitldapCountryHRIS	cn
ldapSegment
accountStatussn
officePhoneslbAliasldapBillableEntity	givenNamepasswordldapRefreshDate	pendingQCldapBizArea+00035631-DXIT000-Photon Infotec ConsultantsIN		Corporate
1slb5+1 303 486 (switchboard)AEphremSTHS-Schlumberger Info Solutio	testuser5********
@lω°�̈ 
0!D000-OFS ITSA Contractor

how to get the columns out of the above data?

 

Answer 7

thnks sqlusa,

in our database, the property name column has  something like this Item:B:0:911 and property vales binary has hexadecimal data something like

0x0001000000FFFFFFFF01000000000000000C02000

the above hexadecimal data when converted to char gives very unorganized format as shown below:

 

hoLoadFactorVersionComparerHashCodeProviderHashSizeKeysValues System.Collections.IComparer$System.Collections.IHashCodeProvider�Q8?¢

   ldapOrgUnitldapCountryHRIS cn
ldapSegment
accountStatus sn
officePhoneslbAliasldapBillableEntity givenNamepasswordldapRefreshDate

how to even parse ot the columns from the unorganized data above??

 

Answer 8

Just curious if you figured this out or not and what is your SQL Server database version.

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog