ASP.net login page

Question

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

Pranay Rana · Answer

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

madhuri Gamane · Answer

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 Sonavane · Answer

Sorry Sir not got the correct answer

Amol Sonavane · Answer

Hi sir plz suggest as early as possible......and explian in brif plz

Amol Sonavane · Answer

sry sir i am fresher level developer...can u explain in detail plz