show only login user data in datagridview

Question

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

Hassan Uddin Mughal · Answer

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

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

Firstly you need to manage logedin user in db and get by service.