Is there any way where I can load gridview data according to who is logged in?

Question

0.00/5 (No votes)

See more:

I have a log in page and a gridview page , where when the user login in , they would be able to see what they have booked and they should not be able to see rooms that are booked by other people.

What I have tried:

i tried using session key but it doesnt seems to work.
Latest... although still not working... im still trying to figure out why..

if (!IsPostBack)
           {
               string sql = "Select * from Meeting where staff_id={0}";
               GvBooking.DataSource = DBUtl.GetTable(sql,Session["staff_id"]);
               GvBooking.DataBind();
           }

But it doesnt work..

Posted 21-Jan-18 0:19am

dibdab

Updated 21-Jan-18 20:50pm

v3

Add a Solution

Comments

an0ther1 21-Jan-18 18:09pm

Short answer is yes, but how depends on many factors.
The easiest way is dependent on what your data looks like & how you authenticate the user - their login details should be available to your code behind but via what is dependent on authentication method.
Improve your question - add detail regarding the data & how the user is authenticated

Kind Regards

Dotnet_Dotnet 22-Jan-18 1:49am

sir l think the varchar field
may not be taken within single code

dibdab 22-Jan-18 2:51am

Hi, I recently updated my code.. although it still doesnt work, i am still trying to figure out why.

F-ES Sitecore 22-Jan-18 4:17am

Does Session["staff_id"] contain the correct id as you would expect?

dibdab 22-Jan-18 4:44am

yup.. it is an id from the database , as well as the id where the user logs in with

F-ES Sitecore 22-Jan-18 5:07am

Next check the actual SQL that is being generated and executed by GetTable to ensure the correct WHERE clause is being properly added with the id.

dibdab 22-Jan-18 8:55am

I have solved the problem already , it turns out the login page Session was not well done! Thanks for your help! But i still have other problems in other pages.. Sigh

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)