I get new GUID every time!

Question

1.00/5 (1 vote)

See more:

Hi all,
I'm in the middle of building a small online shop using ASP.NET and VB.Net.
I have 3 pages: Home, Product Details and Shopping Cart.
The Home Page displays all products in a Grid View. When a user clicks on a product, he/she gets redirected to the Product Details page. In this page, if the user clicks on the Buy button, two things happen here: 1. an insert statement takes the Product ID and the GUID to the database 2. the user gets redirected to the Shopping Cart page to view his/her items.

The problem is that when I go check the Basket table for the current session, the GUID is different in each row. I suppose to see something like this in the Basket table:

ProductID.......GUID
1 ................... 6719c79a-2952-4615-8441-ecc06d7ecc77
2 ................... 6719c79a-2952-4615-8441-ecc06d7ecc77
3 ................... 6719c79a-2952-4615-8441-ecc06d7ecc77

The code behind might explain more, here is what I have written in the Product Details page:

Page Load Event:

VB

Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
      If Not IsPostBack Then
          Session("guid") = Guid.NewGuid().ToString()
      End If
End Sub

Button Click Event

VB

Protected Sub Button3_Click(sender As Object, e As System.EventArgs)
        Dim insert As New DataSet1TableAdapters.BasketTableAdapter
        insert.InsertQuery(Me.Request.QueryString("ProductID"), Me.Session("guid"))
        Response.Redirect("MyShoppingCart.aspx")
End Sub

My question is: how can I retain the same GUID for a user until he/she checkout or leave the website?

Please help me sorting this issue.
Finally, sorry for the weak language.

Posted 27-Mar-13 13:54pm

fam666ous

Add a Solution

Comments

AspDotNetDev 27-Mar-13 20:57pm

FYI, I deleted the answer you posted, as it should have been posted as a comment. Also, glad I could be of assistance :-)

2 solutions

Solution 3

As everything is in just one site and there are no independent partied creating IDs, you don't need GUID at all. It could be just something like UInt32 or UInt64 ID. Your server is a central point issuing the IDs, so you can guarantee perfect uniqueness. Using GUID is totally pointless.

—SA

Posted 27-Mar-13 16:48pm

Sergey Alexandrovich Kryukov

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)

AspDotNetDev · Accepted Answer · 2013-03-27T14:19:00

Solution 1

I'm still not too clear on how the pieces fit together, but try this:

VB

If Session("guid") Is Nothing Then
    Session("guid") = Guid.NewGuid().ToString()
End If

That way, the GUID will only be placed in session if it doesn't already exist.

Posted 27-Mar-13 14:19pm

AspDotNetDev

Updated 27-Mar-13 14:56pm

v2