Best way to get login information to query database? ASP.net 2.0+, C# or VB.net - using the standard login/roles control from ASP.net.
Posted on 2011-03-17
What I'm really trying to do is have a customer login and take that information to query the database.
I have a database with customer numbers. When they login, I would like to have them use their customer number as their login. I would prefer to use the password field if I can. Then I can do a select based on their cutomer number to only show information that is relevant to them.
It's important they not see other customer's information so I want to use a numeric value that is already in the database as their login.
I plan to use the standard login control in ASP.net so am wondering if there is a way to do this?