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