471,582 Members | 1,451 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,582 software developers and data experts.

Adding details to user profile

JJ
Whats the best way to do this?:

Users from different companies need to log into a web site. I want to add
the users company name, address etc to their profile. However I want the
company details to be stored separately (i.e. in a separate table in the
database) as more than one person could be from the same company.

I though that if I set up the company table and add the companyID to the
user profile that might do the job?

JJ
Jan 30 '07 #1
3 1347
You can have the user pick a company when they sign up for an account. That
would work rather nicely. Store the companies in a table and then link it to
the user. You can create a separate user table rather than store all in
profile, but you can also use the key of the company table in the profile
table, to link them.

If you are trying to brand it, use an HTTP handler with the brand as the
first dot, like microsoft.mycompany.com. You can then have the handler set
the application and use different applications in the aspnet_application
table. You can then skin the site with their look and feel. If HTTP handler
is too much of a pain, you can create the entire functionality of the site
in libraries, GAC them and add different branded sites (same site, different
skin). It serves the same purpose.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"JJ" <ab*@xyz.comwrote in message
news:uK**************@TK2MSFTNGP05.phx.gbl...
Whats the best way to do this?:

Users from different companies need to log into a web site. I want to add
the users company name, address etc to their profile. However I want the
company details to be stored separately (i.e. in a separate table in the
database) as more than one person could be from the same company.

I though that if I set up the company table and add the companyID to the
user profile that might do the job?

JJ
Jan 30 '07 #2
JJ
Hi Gregory.
Thanks for you reply.

I don't actually want the user to see the other companies. as they shouldn't
see who else is a 'client'. This is a bit of a pain as it means the admin
has to set the users company later (unless theres another way of doing
this - I wish there was but I cannot think of one).

Its not a case of branding, useful though your information is - just a case
of only allowing a company to see their own projects.
JJ

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:EB**********************************@microsof t.com...
You can have the user pick a company when they sign up for an account.
That would work rather nicely. Store the companies in a table and then
link it to the user. You can create a separate user table rather than
store all in profile, but you can also use the key of the company table in
the profile table, to link them.

If you are trying to brand it, use an HTTP handler with the brand as the
first dot, like microsoft.mycompany.com. You can then have the handler set
the application and use different applications in the aspnet_application
table. You can then skin the site with their look and feel. If HTTP
handler is too much of a pain, you can create the entire functionality of
the site in libraries, GAC them and add different branded sites (same
site, different skin). It serves the same purpose.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"JJ" <ab*@xyz.comwrote in message
news:uK**************@TK2MSFTNGP05.phx.gbl...
>Whats the best way to do this?:

Users from different companies need to log into a web site. I want to add
the users company name, address etc to their profile. However I want the
company details to be stored separately (i.e. in a separate table in the
database) as more than one person could be from the same company.

I though that if I set up the company table and add the companyID to the
user profile that might do the job?

JJ

Jan 30 '07 #3
JJ
I think I'll do as you say and link the company table to the user profile.
Thanks,
JJ
"JJ" <ab*@xyz.comwrote in message
news:e5**************@TK2MSFTNGP04.phx.gbl...
Hi Gregory.
Thanks for you reply.

I don't actually want the user to see the other companies. as they
shouldn't see who else is a 'client'. This is a bit of a pain as it means
the admin has to set the users company later (unless theres another way of
doing this - I wish there was but I cannot think of one).

Its not a case of branding, useful though your information is - just a
case of only allowing a company to see their own projects.
JJ

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:EB**********************************@microsof t.com...
>You can have the user pick a company when they sign up for an account.
That would work rather nicely. Store the companies in a table and then
link it to the user. You can create a separate user table rather than
store all in profile, but you can also use the key of the company table
in the profile table, to link them.

If you are trying to brand it, use an HTTP handler with the brand as the
first dot, like microsoft.mycompany.com. You can then have the handler
set the application and use different applications in the
aspnet_application table. You can then skin the site with their look and
feel. If HTTP handler is too much of a pain, you can create the entire
functionality of the site in libraries, GAC them and add different
branded sites (same site, different skin). It serves the same purpose.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"JJ" <ab*@xyz.comwrote in message
news:uK**************@TK2MSFTNGP05.phx.gbl...
>>Whats the best way to do this?:

Users from different companies need to log into a web site. I want to
add the users company name, address etc to their profile. However I want
the company details to be stored separately (i.e. in a separate table in
the database) as more than one person could be from the same company.

I though that if I set up the company table and add the companyID to the
user profile that might do the job?

JJ


Jan 30 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Bart Van Hemelen | last post: by
9 posts views Thread by =?Utf-8?B?Sm9obiBBdXN0aW4=?= | last post: by
2 posts views Thread by =?Utf-8?B?RGFtaWVu?= | last post: by
4 posts views Thread by Scott M. | last post: by
reply views Thread by Seb | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.