ASP.NET 2.0: Administering Users

[Knoxy]

Hope someone can help with this as I've been pulling my hair out. I'm
using the built in membership with sql server and trying to admin
users.

On my website, I have an admin section to administer users. It's nice
and easy if all I need to do is look at the data stored in the
aspnet_membership table.

But, I need to bring back extra information stored on the user accounts
like full name, company etc and display this in the datagrid. I'm sure
I can't be the only one needing to do this but I can't seem to find a
lot on it! I just wanted really one call to the database bringing all
this info back. I 'could' get around it by filling up a user list and
looping through it and pulling back profile data for each user... but
thats just nuts

I have a feeling I'm just going to have to write up my own GetAllUsers
method and stored procedure as I also want to avoid storing the extra
user account data in the aspnet_profiles table too.

Anyone else running into this problem? I'd just like to know the best
approch for what I'm trying to achieve.

Thanks in advance,
Knoxy

 

[Remy]

complete solution for this problem:

http://peterkellner.net/?p=31

 

[Knoxy]

Cheers Peter, I'll have a look at that!

I was actually on your site this afternoon but I missed that piece