ASP.NET Discussion Boards

Hi,

I'm developing a multiple-city Visitor's system. I want to create a Login page with following details:

Username, Password, City & Gate_Name.

I need to know how should I proceed with creation of tables and then the code.

The City & Gate_Name should be nested. When a city is selected, then only the appropriate gate-name must be displayed in drop-down box below.

Initially, Username & Password must be checked.
If they do not match, an error message must be generated.
If they match, then the associated city & gate-name must be checked.
If they do not match, an error message must be generated.
If all the details match, then a Session by UserID must be created and the user must be redirected to the Home Page.
A user allotted a particular gate cannot Login from any other city or any other gate.

Please help me with this Login Issue.
Thanks.

You have all the requirements and workflow with you. What exactly is troubling/stopping you from implementing it?

For table structure:

MstUser
UserID UserName Password CityID GateID

MstCity
CityID CityName

MstGate
GateID GateName CityID

Now, start the implementation that is pretty straight forward.

Sandeep Mewara
Microsoft ASP.NET MVP 2012 & 2013

[My Blog]: Sandeep Mewara's Tech Journal!
[My Latest Article]: HTML5 Quick Start Web Application

This article shows how to use the login and membership APIs with custom user information.

Understanding and Implementing ASP.NET Custom Forms Authentication[^]

Although you will have to add fields for City & Gate_Name and custom logic to check it. But the overall philosophy and working will remain the same as it is in this article.

Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.