How to display all ASP.Net ProfileProvider User Profiles ??

[-mk-]

Hi,

I am working with a website that using the AspNetSqlMembershipProvider to store the user profiles data.

I have discover that the User Profiles data are stored in the database named ASPNETDB.MDF, in the table aspnet_profile.

The profile data are in : column PropertyNames and PropertyValuesString. It has the Data I want, but it is joint together with other profile data.

for example :

In PropertyNames :

LastName:S:164:11:UserType:S:175:4:Language

In PropertyValuesString :

JohnsonUserEnglish

Johnson is the value for LastName

User is the value for Usertype

English is the value for Language.

In my webconfig, I have something like this under the profile tag:

<profile enabled="true">
            <properties>
                <add name="MemberId" defaultValue="0" type="System.Int32"/>

            <add name="UserType" type="System.String"/>

            <group name="Core"/>

            </properties>
        </profile>

I need to you display all the User Data in a page based on their profile data. And need to separate them according to their UserType values.

Like this :

Admin Users

Username Email UserType
1) xxxx xxx Admin
2) yyyy yyyy Admin

....

Normal Users

Username Email UserType
1) xxxx xxx User
2) yyyy yyyy User

....

Thanks and Regards.