ASP.net login page

Amol Sonavane

Hi Sir,

I have created one inventry application.In that i have created login form.But in login form i want to login locationwise that mumbai,pune,banglore etc....means mumbai person have diffent login ,pune person have different login....Please suggest code for this...It is on high priority....

ThanksDiv

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

madhuri Gamane11y ago
hii amol
first thing you need to add one more column in your Userlogin table..
that column will contain either location name or another way is add one more table which will hold all TblLocation and add its primary_key let say LocID in Userlogin table..
now you will get city as

1. select username,password,Location from Userlogin where Location='Pune'
2. select usernaem,password,Locationfrom Userlogin l inner join TblLocation c on l.CityId=c.CityID where Location='Pune'
or
select usernaem,password,Location from Userlogin l,TblLocation c where l.CityId=c.CityID
and Location='Pune'
all the best
accept answer if it helps
Amol Sonavane11y ago
Sorry Sir not got the correct answer
Amol Sonavane11y ago
Hi sir plz suggest as early as possible......and explian in brif plz
Amol Sonavane11y ago
sry sir i am fresher level developer...can u explain in detail plz
Pranay Rana11y ago
IF its location based login than you need to have database table which having mapping with the lcoation

Example :

USerLocation

UserID LocationID

1 1 -- user mapped to location having id 1
2 3 ---user mapped to location having id 3

than for this you can crate stored procedure for login user in that you can write query

select top 1 from user
join UserLocation on userid = locationID
where USerid = @userid--passed user id to procedure
and locationid = @locationid -- passed location id to procedure

I hope you will get my point