By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,841 Members | 840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,841 IT Pros & Developers. It's quick & easy.

Adding details to user profile

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.