Showing Current User's Data

Question

0.00/5 (No votes)

See more:

Hi,

I'm developing a Customer online ordering system using asp.net.

There are two set of users in my project, one is the Administrator and the other is the normal user.

I created two tables Users & Orders.

1. User table consists of the columns (UserId, Username, Password etc.)

2. Order Table COnsists of the columns (OrderId, Order name,UserId)

I link two tables the User Table and order Table by specifying UserId in the User table as Primary key and foreign key as UserId in Order table.

Once a normal User looged in to the system, he should be able to create his orders.

But how can I make to view only his orders submitted by him in asp.net?.

Please guide me on this.

Posted 4-Aug-12 0:34am

Member 9334466

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)

JammoD87 · Answer 1 · 2012-08-04T00:43:00

Hi,

I'm assuming you are using a SQL Database, with Stored Procedures/Query to display the data.

Within the Stored Procedure/Query you can pass a variable '@UserID' from ASP.Net to the SQL Stored Procedure/Query and within your query you add the following code: WHERE UserID = @UserID.

Thanks,

Santhosh Kumar Jayaraman · Answer 2 · 2012-08-04T00:47:00

Solution 2

Whenever user logs in retrieve only particular user orders.

Like.

In page_load event,

You will have current user id from login page. So Have a sqlCommand in page_load which take userid as parameter and retrive orders for particular user and fill it in datatable/gridview.

Page_load

C#

Guid theGuid =//ur userid;
SqlCommand cmd=new SqlCommand("select * from Orders where UserId=@UserId",con);
command.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = System.Data.SqlTypes.SqlGuid.Parse(theGuid.ToString());

//then execute and fill into datatable/dataset.

Also incase if you pass UserId as session variable as string, you have to change it

C#

string theGuid =//ur userid;
SqlCommand cmd=new SqlCommand("select * from Orders where UserId=@UserId",con);
command.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = System.Data.SqlTypes.SqlGuid.Parse(theGuid);

Regarding ur other question, whenever u are trying to save new order, you have to pass 3 parameters including USerId, so that it wont be null, You can use the above piece of code for adding GUID parameters during Order insert method

Posted 4-Aug-12 0:47am

Santhosh Kumar Jayaraman

Updated 4-Aug-12 1:12am

v2

Comments

Member 9334466 4-Aug-12 6:58am

Thank you Santhosh for your reply,

Currently I'm using "Unique Idientifier" as the data type. So, How would be the coding will be?

Also, in the Order table, the foreign key column of UserId is not updating with the primary key of column UserId in user Table. Once a user add an order, the value of UserId in Order table specified as "Null". How can i update this?

Santhosh Kumar Jayaraman 4-Aug-12 7:13am

Updated the solution.Please check

Member 9334466 5-Aug-12 7:38am

Hi Santhosh,

Can I know which command I need to enter in the area //ur userid; below?

Guid theGuid =//ur userid;

Santhosh Kumar Jayaraman 5-Aug-12 7:44am

You said User Id is Guid right? Whatever value applicable for the particular user, The GUID from login page should be passed here

Member 9334466 6-Aug-12 6:57am

Can you elaborate more on this command pls?

Guid theGuid =//ur userid;

As I'm using Visual Studio 2010. I have added the Login Name from the toolbox into the page. so, that once the user login to the system, his user name is visible on the page. DO I need to pass this on the above command? If yes, Pls indicate the command.

Santhosh Kumar Jayaraman 6-Aug-12 6:59am

For each login name you have user Id as GUID right in database? Get that user id for particular user from database and set it here or??you can change the code such that instead of userid pass login name to storedproc

Member 9334466 6-Aug-12 7:10am

Yes, for each user there is UserId in the database. but can you indicate me the command to get userid of each user from the database.

Santhosh Kumar Jayaraman 6-Aug-12 7:14am

I thought you would be getting whole record in UI. But u dont ve . U have only loginid, then if login id is unique, why cant u query using login? I dont understand why you are asking command again and again.

SqlCommand cmd=new SqlCommand("select * from Orders where loginid=@loginid",con);
command.Parameters.Add("@loginid", SqlDbType.varchar(100)).Value =loginid;
Also about "indicate the command to get userid". its just simple sql query "select userid from table where loginname ='test'" . I dont understand why you are asking me again and again

Member 9334466 6-Aug-12 9:01am

Hi Santhosh!

As I'm new to programming, I have a confusion with your coding.

Let me explain you the scenario clearly.

I'm using asp.net table to store data. In there, I have tables, User & Orders

I made relationship between both the tables using columns UserId. Primary key is in User table & Foreign Key is in Order table.

In the Order table I have columns. OrderId, Order Name, Order Description & UserId. But in the designer I have added only Order Name & Order Description. When ever the User enters data in the textboxes it will store data in Order Name & Order Description.

OrderId is incremented by default. I need when ever the logged in user creates an order his user Id should be automatically added to the column UserId of Order Table. So, that I can generate some reports.

Please guide me on this.

Santhosh Kumar Jayaraman 6-Aug-12 9:33am

Whenever user logins, get his user Id (through sql command)and store it in session variable. Now in order screen, when you are trying to add new order, in the insert stored proc, pass 3 parameters ordername, desc and uSer Id which is there in session variable.

its just so simple. I am not sure why you are so confused.

Member 9334466 7-Aug-12 8:02am

Ok, that is clear! Can I know the command for storing in session variable?

Santhosh Kumar Jayaraman 7-Aug-12 8:04am

sample Session :
string emp="Employee"
Session["Emp"]=emp;

Now if i see the value inside Session["Emp"] it would be "Employee"