Is is possible for Gridview to display data of particular logged in user in multiuser application

Question

0.00/5 (No votes)

See more:

For a multi-user application , like suppose a web based item list stored by many users

Is it possible for Gridview to display data related to particular Logged in user.

Also when the user Logs in , he gets redirected to a page with Gridview control that

fetches and shows data related to that particular logged in user from database and displays him his data only.

Like suppose for these tables -

Login Table>>>

Userid | Password
------ | --------
------ | --------
------ | --------
------ | --------
------ | --------
(where userid is Primary key)

and

Product Table>>>

ProductID | Productname | category | Userid
----------|-------------|----------|-------
----------|-------------|----------|-------
----------|-------------|----------|-------
----------|-------------|----------|-------
----------|-------------|----------|-------
----------|-------------|----------|-------
----------|-------------|----------|-------
----------|-------------|----------|-------
(where ProductId is primary key and Userid is Foreign key)

Here i want Gridview to fetch data as per logged in User(Userid) from the Product table and display his or her
Products only.

What concept i'll be needing for this to make happen. Will i need Sessions also in this ?

If someone can Help and make an article on it please it will be very helpful.

Posted 18-Jan-14 2:44am

koningx

Updated 18-Jan-14 2:47am

v2

Add a Solution

2 solutions

Add a Solution

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)

Sanjeev236 · Accepted Answer · 2014-01-18T03:12:00

Solution 1

Steps:

1. Store userid in a session.
2. while datafetch from db for gridview,use query as "select Columns from table whjere user_id=(user_id in session).
3. Bind data to Gridview and done.

Posted 18-Jan-14 3:12am

Sanjeev236

Updated 18-Jan-14 3:30am

v2

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-01-18T03:14:00

You just need to query to Product Table and pass logged in User Id as a parameter to the query.

The following query is something what you need.

SQL

SELECT ProductID, Productname, category
FROM
    ProductTable
WHERE
    UserId = @LoggedInUserId

You need to use ADO.NET objects and use SQLCommand Class and initialize that using this query.
You specify parameter and pass the Logged in User Id as a parameter.

Refer - Adding Parameters to Commands[^]

For User Id, you can use Session to store and retrieve.