
Signature
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com
I usually add another table user_details and join it with aspnet_Users on
UserId.

Signature
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
> Is there any way to specify a user's name using ASP.NET membership?
>
[quoted text clipped - 3 lines]
>
> Thanks for any suggestions.
Kevin Spencer - 04 Dec 2007 11:19 GMT
If you implement your own Membership Provider derived class and database,
you can add any columns and/or tables you want to, as well as any methods
you wish to add to the base class.

Signature
HTH,
Kevin Spencer
Chicken Salad Surgeon
Microsoft MVP
>I usually add another table user_details and join it with aspnet_Users on
> UserId.
[quoted text clipped - 7 lines]
>>
>> Thanks for any suggestions.
Jonathan Wood - 04 Dec 2007 23:06 GMT
Yeah, I'm doing something similar, although I wasn't sure the best way. By
join, do you mean you'll create a relationship between the two tables?
Originally, I thought maybe the user's name would already be part of the
existing membership logic.
Thanks.

Signature
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com
>I usually add another table user_details and join it with aspnet_Users on
> UserId.
[quoted text clipped - 7 lines]
>>
>> Thanks for any suggestions.
Eliyahu Goldin - 05 Dec 2007 08:44 GMT
No, I mean just joining tables in the from clause like
select u1.LastName, u1.FirstName, a1.UserName
from aspnet_Users a1 inner join user_Details u1
on a1.UserId=u1.UserId

Signature
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
> Yeah, I'm doing something similar, although I wasn't sure the best way. By
> join, do you mean you'll create a relationship between the two tables?
[quoted text clipped - 15 lines]
>>>
>>> Thanks for any suggestions.
Jonathan Wood - 05 Dec 2007 16:28 GMT
Okay, so you just mean to create the join when querying the database so that
the data is all together.
Great. Thanks for the clarification. This is probably what I'll be doing.

Signature
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com
> No, I mean just joining tables in the from clause like
>
[quoted text clipped - 22 lines]
>>>>
>>>> Thanks for any suggestions.
If you are already using the Membership Provider, consider using also the
Profile Provider, and store the user's full name or firstname / lastname and
any additional items there.

Signature
--Peter
"Inside every large program, there is a small program trying to get out."
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com
> Is there any way to specify a user's name using ASP.NET membership?
>
[quoted text clipped - 3 lines]
>
> Thanks for any suggestions.
Eliyahu Goldin - 04 Dec 2007 12:50 GMT
But then the user names etc go out of the schema and become cumbersome to
get in a single query.

Signature
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
> If you are already using the Membership Provider, consider using also the
> Profile Provider, and store the user's full name or firstname / lastname
[quoted text clipped - 9 lines]
>>
>> Thanks for any suggestions.
Jonathan Wood - 04 Dec 2007 23:07 GMT
I've looked at that, but am not sure it's my best route.
Thanks.

Signature
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com
> If you are already using the Membership Provider, consider using also the
> Profile Provider, and store the user's full name or firstname / lastname
[quoted text clipped - 9 lines]
>>
>> Thanks for any suggestions.