469,326 Members | 1,538 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Membership Control Advice Wanted

I am creating a web app to be shared amongst companies. Each user's
credentials will be in the common ASP.NET membership database. Each company
will have their own data base.

I need to be able to correlate each user to their company so I know what
connection string (which I want to store in the membership database as well)
to use to get their data. Please note that my users will not be able to
create their own profiles over the web.

I was thinking about modifying the login control to allow a field for the
company name and see if I could store that information with the login
credentials. The other thought I had was using the CreateUserWizard control
for an internal app and capture the company name there and still have it
stored in the membership database.

My question is what is the best way to do this and still have the data
stored in the ASP.NET membership database?

Pointers to any articles or links would be of great assistance. Thank you.
Apr 23 '07 #1
1 1028
The Membership API stores the application the person is using. This is your
key to what application they are going to use and you do not need to store
this information, again, in profile. You then add another table that has
connection string, place the strings by app name or GUID in config, or
extend the aspnet_applications table.

You can have as many applications in a single database as you desire.

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

*********************************************
Think outside the box!
*********************************************
"Rusty Hill" <Ru********@hotmail.comwrote in message
news:uP**************@TK2MSFTNGP05.phx.gbl...
>I am creating a web app to be shared amongst companies. Each user's
credentials will be in the common ASP.NET membership database. Each
company will have their own data base.

I need to be able to correlate each user to their company so I know what
connection string (which I want to store in the membership database as
well) to use to get their data. Please note that my users will not be
able to create their own profiles over the web.

I was thinking about modifying the login control to allow a field for the
company name and see if I could store that information with the login
credentials. The other thought I had was using the CreateUserWizard
control for an internal app and capture the company name there and still
have it stored in the membership database.

My question is what is the best way to do this and still have the data
stored in the ASP.NET membership database?

Pointers to any articles or links would be of great assistance. Thank
you.

Apr 23 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by lanem | last post: by
5 posts views Thread by Vishal Gupta | last post: by
6 posts views Thread by Tem | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.