Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / December 2007

Tip: Looking for answers? Try searching our database.

Anyway to Specify the User's Name with Membership?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jonathan Wood - 04 Dec 2007 03:03 GMT
Is there any way to specify a user's name using ASP.NET membership?

I know there is a UserName property but that's a unique login name, and not
ideal for the user's actual name. (Also, I'm going to use emails for the
username.)

Thanks for any suggestions.

Signature

Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

Eliyahu Goldin - 04 Dec 2007 07:16 GMT
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.
Peter Bromberg [C# MVP] - 04 Dec 2007 12:36 GMT
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.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.