show only login user data in datagridview

girish parganiha

9y2.1k.NET

Hi,

How to show login user data only after successful login in web app in datagridview.

Thanks..

3 Replies

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

Hassan Uddin Mughal9y ago
You trying to get the data of users who are currently logged in?
Make a table and name it LoginStatus
LoginStatusID LoginStatus
=========== =========
1 Active
2 Inactive
In your UserInformation table make LoginstatusID foreign key and by set it to 2 (inactive).
In Login click event update LoginStatusID of User to 1 (active).
and again update it on logout to 2 (inactive).
Once a user is successfully login in your app, his/her login status will be active and when a user logout from your app his/her login status will be inactive.
So make a sql select query and hunt for users who are currently online
select * from UserInformation where LoginStatusID = 1
Amit Kumar9y ago
Hi Dear,
In your database every user has unique id and any record save in datatable with user id.
Now when you login then you will get userid easily then get data from using this unique id then u can get same user data which user is loign and bind it in gridview.
Bikesh Srivastava9y ago
Firstly you need to manage logedin user in db and get by service.