|
 |
aspx thread: Storing temp data
Message #1 by "Simon Robinson" <srobinson@g...> on Thu, 29 Aug 2002 16:19:46
|
|
Hi All,
I have created a site where the user selects a car by model, category and
style. The DB is queried and a list of the models is displayed.
At this stage I want the user to be able to add the cars to a shopping
basket by clicking on 'add to basket' This will be a temporary store of
the cars before they move on to order completion.
Does anybody know what the best way to do this is? Each shopping basket
must have a unique ID. I have considered temporary tables in SQL Server
however I do not know how to create a unique name for each shopping basket
table.
Does anybody have any ideas on this or otherwise.
Many thanks,
Simon.
Message #2 by "Wim Verdeyen" <Wim.Verdeyen@e...> on Thu, 29 Aug 2002 17:13:02 +0200
|
|
Maybe you can store the carid's in a cookie ?
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: donderdag 29 augustus 2002 18:20
To: ASP+
Subject: [aspx] Storing temp data
Hi All,
I have created a site where the user selects a car by model, category
and
style. The DB is queried and a list of the models is displayed.
At this stage I want the user to be able to add the cars to a shopping
basket by clicking on 'add to basket' This will be a temporary store of
the cars before they move on to order completion.
Does anybody know what the best way to do this is? Each shopping basket
must have a unique ID. I have considered temporary tables in SQL Server
however I do not know how to create a unique name for each shopping
basket
table.
Does anybody have any ideas on this or otherwise.
Many thanks,
Simon.
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #3 by "Mark Phillips" <webmaster@d...> on Thu, 29 Aug 2002 16:18:40 +0100
|
|
Hi,
Two options spring to mind:
1. Use an autonumber field (Identity field) in the basket Table. When adding
something to the basket, examine Session("BasketID"), if it's blank, insert
a new row into Basket, get back the ID and put that in the Session. The
Basket table would have 2 columns - BasketID and LastUpdated.
You'd need a second table BasketProducts consisting of e.g. BasketID,
ProductID (both these together are the primary key), Price, Quantity
2. Use the ASP Session ID as the BasketID (does this still work the same as
old ASP?) This is only unique until the web server gets a reboot, so either
way on a daily basis go thru the basket table and delete all the baskets
where LastUpdated is say > 1 day ago.
Mark
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: 29 August 2002 16:20
To: ASP+
Subject: [aspx] Storing temp data
Hi All,
I have created a site where the user selects a car by model, category and
style. The DB is queried and a list of the models is displayed.
At this stage I want the user to be able to add the cars to a shopping
basket by clicking on 'add to basket' This will be a temporary store of
the cars before they move on to order completion.
Does anybody know what the best way to do this is? Each shopping basket
must have a unique ID. I have considered temporary tables in SQL Server
however I do not know how to create a unique name for each shopping basket
table.
Does anybody have any ideas on this or otherwise.
Many thanks,
Simon.
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #4 by John Pirkey <mailjohnny101@y...> on Thu, 29 Aug 2002 11:14:42 -0700 (PDT)
|
|
i once saw an application that created tables using the SessionID as the table name
- that should be unique - and easy to determine which table to select from.
of course, if this is a multiple IIS server environment, this will not work, as the
session ID's are not 100% guaranteed unique (although not likely to encounter the
same one).
just a thought.
john
--- Wim Verdeyen <Wim.Verdeyen@e...> wrote:
> Maybe you can store the carid's in a cookie ?
>
> -----Original Message-----
> From: Simon Robinson [mailto:srobinson@g...]
> Sent: donderdag 29 augustus 2002 18:20
> To: ASP+
> Subject: [aspx] Storing temp data
>
>
> Hi All,
>
> I have created a site where the user selects a car by model, category
> and
> style. The DB is queried and a list of the models is displayed.
>
> At this stage I want the user to be able to add the cars to a shopping
> basket by clicking on 'add to basket' This will be a temporary store of
> the cars before they move on to order completion.
>
> Does anybody know what the best way to do this is? Each shopping basket
> must have a unique ID. I have considered temporary tables in SQL Server
> however I do not know how to create a unique name for each shopping
> basket
> table.
>
> Does anybody have any ideas on this or otherwise.
>
> Many thanks,
>
> Simon.
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
>
>
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
=====
----------------------------
John Pirkey
MCSD
http://www.stlvbug.org
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
Message #5 by "Mike Amundsen" <mike@a...> on Thu, 29 Aug 2002 20:29:42 -0400
|
|
You might want to check the source code and database for the IBuySpy
store app. That app allowed folks to add items to a shopping cart
*before* they logged in as a user to close their order.
http://www.ibuyspy.com
MCA
Mike Amundsen
mca@E...
host your .NET Apps @ EraServer.NET
-----Original Message-----
From: John Pirkey [mailto:mailjohnny101@y...]
Sent: Thursday, August 29, 2002 2:15 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
i once saw an application that created tables using the SessionID as the
table name
- that should be unique - and easy to determine which table to select
from.
of course, if this is a multiple IIS server environment, this will not
work, as the
session ID's are not 100% guaranteed unique (although not likely to
encounter the
same one).
just a thought.
john
--- Wim Verdeyen <Wim.Verdeyen@e...> wrote:
> Maybe you can store the carid's in a cookie ?
>
> -----Original Message-----
> From: Simon Robinson [mailto:srobinson@g...]
> Sent: donderdag 29 augustus 2002 18:20
> To: ASP+
> Subject: [aspx] Storing temp data
>
>
> Hi All,
>
> I have created a site where the user selects a car by model, category
> and
> style. The DB is queried and a list of the models is displayed.
>
> At this stage I want the user to be able to add the cars to a shopping
> basket by clicking on 'add to basket' This will be a temporary store
of
> the cars before they move on to order completion.
>
> Does anybody know what the best way to do this is? Each shopping
basket
> must have a unique ID. I have considered temporary tables in SQL
Server
> however I do not know how to create a unique name for each shopping
> basket
> table.
>
> Does anybody have any ideas on this or otherwise.
>
> Many thanks,
>
> Simon.
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
>
>
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
=====
----------------------------
John Pirkey
MCSD
http://www.stlvbug.org
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #6 by "Graham Dobson" <grahamdo@a...> on Thu, 29 Aug 2002 23:47:25 -0400
|
|
You might want to check out the IBuySpy app at www.asp.net. They use the
Guid class from the MSCore library
to generate a temporary id, then store the id in a cookie. Like so:
Guid tempCartID = Guid.NewGuid();
context.Response.Cookies["CartID"].Value = tempCartID.ToString();
return tempCartID.ToString();
They also use a db table to store shopping cart info and have some nifty
techniques for emptying the cart once the order is made
Graham
-----Original Message-----
From: Wim Verdeyen [mailto:Wim.Verdeyen@e...]
Sent: Thursday, August 29, 2002 11:13 AM
To: ASP+
Subject: [aspx] RE: Storing temp data
Maybe you can store the carid's in a cookie ?
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: donderdag 29 augustus 2002 18:20
To: ASP+
Subject: [aspx] Storing temp data
Hi All,
I have created a site where the user selects a car by model, category
and
style. The DB is queried and a list of the models is displayed.
At this stage I want the user to be able to add the cars to a shopping
basket by clicking on 'add to basket' This will be a temporary store of
the cars before they move on to order completion.
Does anybody know what the best way to do this is? Each shopping basket
must have a unique ID. I have considered temporary tables in SQL Server
however I do not know how to create a unique name for each shopping
basket
table.
Does anybody have any ideas on this or otherwise.
Many thanks,
Simon.
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #7 by "Sampath, Ramanujam (Cognizant)" <SRamanuj@c...> on Fri, 30 Aug 2002 14:06:00 +0530
|
|
well simon...I have an easy answer for u....
Have a dataset...... Then each time when the user selects something add it
to the dataset and show it as a cart. Then when he wants to update it then
add it to the database....
So simple and this is where .Net has improved a lot....
U wont need a temp table nor a session.... because.. when the user keeps
adding more and more values to the session.. the trafic is blocked... try
using less of sessions....
keep me posted if u still have issues...
==============================
S.Ramanujam
Programmer Analyst
Cognizant technology Solutions (p) Ltd. - CTS
38 & 39 Whites Road,
WCB - Whites Road Circular Building
Royapettah, Chennai - 600014
Ph : +xx xx xxx xxxx Extn 5113 [Off]
: +xx xx xxx xxxx [Res]
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: Thursday, August 29, 2002 9:50 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
Hi All,
I have created a site where the user selects a car by model, category and
style. The DB is queried and a list of the models is displayed.
At this stage I want the user to be able to add the cars to a shopping
basket by clicking on 'add to basket' This will be a temporary store of
the cars before they move on to order completion.
Does anybody know what the best way to do this is? Each shopping basket
must have a unique ID. I have considered temporary tables in SQL Server
however I do not know how to create a unique name for each shopping basket
table.
Does anybody have any ideas on this or otherwise.
Many thanks,
Simon.
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #8 by "Sampath, Ramanujam (Cognizant)" <SRamanuj@c...> on Fri, 30 Aug 2002 14:07:59 +0530
|
|
Well to add some more to my previous mail.....
In case u need a unique ID for each shopping basket.... have an identity
field in the table where u gonna update ontp the DB
keep me posted...
==============================
S.Ramanujam
Programmer Analyst
Cognizant technology Solutions (p) Ltd. - CTS
38 & 39 Whites Road,
WCB - Whites Road Circular Building
Royapettah, Chennai - 600014
Ph : +xx xx xxx xxxx Extn 5113 [Off]
: +xx xx xxx xxxx [Res]
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: Thursday, August 29, 2002 9:50 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
Hi All,
I have created a site where the user selects a car by model, category and
style. The DB is queried and a list of the models is displayed.
At this stage I want the user to be able to add the cars to a shopping
basket by clicking on 'add to basket' This will be a temporary store of
the cars before they move on to order completion.
Does anybody know what the best way to do this is? Each shopping basket
must have a unique ID. I have considered temporary tables in SQL Server
however I do not know how to create a unique name for each shopping basket
table.
Does anybody have any ideas on this or otherwise.
Many thanks,
Simon.
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #9 by "Simon Robinson" <srobinson@g...> on Fri, 30 Aug 2002 10:01:42 -0700
|
|
Mike, Sampath,
I have got to say that there are some really great people on this forum
and you are definitely two of them!
I am eternally grateful for all of your help!
Keep the faith.
Simon.
-----Original Message-----
From: Mike Amundsen [mailto:mike@a...]
Sent: 29 August 2002 17:30
To: ASP+
Subject: [aspx] RE: Storing temp data
You might want to check the source code and database for the IBuySpy
store app. That app allowed folks to add items to a shopping cart
*before* they logged in as a user to close their order.
http://www.ibuyspy.com
MCA
Mike Amundsen
mca@E...
host your .NET Apps @ EraServer.NET
-----Original Message-----
From: John Pirkey [mailto:mailjohnny101@y...]
Sent: Thursday, August 29, 2002 2:15 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
i once saw an application that created tables using the SessionID as the
table name
- that should be unique - and easy to determine which table to select
from.
of course, if this is a multiple IIS server environment, this will not
work, as the
session ID's are not 100% guaranteed unique (although not likely to
encounter the
same one).
just a thought.
john
--- Wim Verdeyen <Wim.Verdeyen@e...> wrote:
> Maybe you can store the carid's in a cookie ?
>
> -----Original Message-----
> From: Simon Robinson [mailto:srobinson@g...]
> Sent: donderdag 29 augustus 2002 18:20
> To: ASP+
> Subject: [aspx] Storing temp data
>
>
> Hi All,
>
> I have created a site where the user selects a car by model, category
> and
> style. The DB is queried and a list of the models is displayed.
>
> At this stage I want the user to be able to add the cars to a shopping
> basket by clicking on 'add to basket' This will be a temporary store
of
> the cars before they move on to order completion.
>
> Does anybody know what the best way to do this is? Each shopping
basket
> must have a unique ID. I have considered temporary tables in SQL
Server
> however I do not know how to create a unique name for each shopping
> basket
> table.
>
> Does anybody have any ideas on this or otherwise.
>
> Many thanks,
>
> Simon.
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
>
>
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
=====
----------------------------
John Pirkey
MCSD
http://www.stlvbug.org
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #10 by "Mike Amundsen" <mike@a...> on Fri, 30 Aug 2002 08:21:22 -0400
|
|
Hey, that's what the NGs are all about, eh?
Happy to be of service.
MCA
Mike Amundsen
mca@E...
host your .NET Apps @ EraServer.NET
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: Friday, August 30, 2002 1:02 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
Mike, Sampath,
I have got to say that there are some really great people on this forum
and you are definitely two of them!
I am eternally grateful for all of your help!
Keep the faith.
Simon.
-----Original Message-----
From: Mike Amundsen [mailto:mike@a...]
Sent: 29 August 2002 17:30
To: ASP+
Subject: [aspx] RE: Storing temp data
You might want to check the source code and database for the IBuySpy
store app. That app allowed folks to add items to a shopping cart
*before* they logged in as a user to close their order.
http://www.ibuyspy.com
MCA
Mike Amundsen
mca@E...
host your .NET Apps @ EraServer.NET
-----Original Message-----
From: John Pirkey [mailto:mailjohnny101@y...]
Sent: Thursday, August 29, 2002 2:15 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
i once saw an application that created tables using the SessionID as the
table name
- that should be unique - and easy to determine which table to select
from.
of course, if this is a multiple IIS server environment, this will not
work, as the
session ID's are not 100% guaranteed unique (although not likely to
encounter the
same one).
just a thought.
john
--- Wim Verdeyen <Wim.Verdeyen@e...> wrote:
> Maybe you can store the carid's in a cookie ?
>
> -----Original Message-----
> From: Simon Robinson [mailto:srobinson@g...]
> Sent: donderdag 29 augustus 2002 18:20
> To: ASP+
> Subject: [aspx] Storing temp data
>
>
> Hi All,
>
> I have created a site where the user selects a car by model, category
> and
> style. The DB is queried and a list of the models is displayed.
>
> At this stage I want the user to be able to add the cars to a shopping
> basket by clicking on 'add to basket' This will be a temporary store
of
> the cars before they move on to order completion.
>
> Does anybody know what the best way to do this is? Each shopping
basket
> must have a unique ID. I have considered temporary tables in SQL
Server
> however I do not know how to create a unique name for each shopping
> basket
> table.
>
> Does anybody have any ideas on this or otherwise.
>
> Many thanks,
>
> Simon.
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
>
>
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
=====
----------------------------
John Pirkey
MCSD
http://www.stlvbug.org
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #11 by "Sampath, Ramanujam (Cognizant)" <SRamanuj@c...> on Fri, 30 Aug 2002 18:52:32 +0530
|
|
Thanx simon....
keep me posted if u still have any more issues....
I'll be happy to solve them..... cause ".Net makes IT Happen"
==============================
S.Ramanujam
Programmer Analyst
Cognizant technology Solutions (p) Ltd. - CTS
38 & 39 Whites Road,
WCB - Whites Road Circular Building
Royapettah, Chennai - 600014
Ph : +xx xx xxx xxxx Extn 5113 [Off]
: +xx xx xxx xxxx [Res]
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: Friday, August 30, 2002 10:32 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
Mike, Sampath,
I have got to say that there are some really great people on this forum
and you are definitely two of them!
I am eternally grateful for all of your help!
Keep the faith.
Simon.
-----Original Message-----
From: Mike Amundsen [mailto:mike@a...]
Sent: 29 August 2002 17:30
To: ASP+
Subject: [aspx] RE: Storing temp data
You might want to check the source code and database for the IBuySpy
store app. That app allowed folks to add items to a shopping cart
*before* they logged in as a user to close their order.
http://www.ibuyspy.com
MCA
Mike Amundsen
mca@E...
host your .NET Apps @ EraServer.NET
-----Original Message-----
From: John Pirkey [mailto:mailjohnny101@y...]
Sent: Thursday, August 29, 2002 2:15 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
i once saw an application that created tables using the SessionID as the
table name
- that should be unique - and easy to determine which table to select
from.
of course, if this is a multiple IIS server environment, this will not
work, as the
session ID's are not 100% guaranteed unique (although not likely to
encounter the
same one).
just a thought.
john
--- Wim Verdeyen <Wim.Verdeyen@e...> wrote:
> Maybe you can store the carid's in a cookie ?
>
> -----Original Message-----
> From: Simon Robinson [mailto:srobinson@g...]
> Sent: donderdag 29 augustus 2002 18:20
> To: ASP+
> Subject: [aspx] Storing temp data
>
>
> Hi All,
>
> I have created a site where the user selects a car by model, category
> and
> style. The DB is queried and a list of the models is displayed.
>
> At this stage I want the user to be able to add the cars to a shopping
> basket by clicking on 'add to basket' This will be a temporary store
of
> the cars before they move on to order completion.
>
> Does anybody know what the best way to do this is? Each shopping
basket
> must have a unique ID. I have considered temporary tables in SQL
Server
> however I do not know how to create a unique name for each shopping
> basket
> table.
>
> Does anybody have any ideas on this or otherwise.
>
> Many thanks,
>
> Simon.
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
>
>
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
=====
----------------------------
John Pirkey
MCSD
http://www.stlvbug.org
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
Message #12 by "Simon Robinson" <srobinson@g...> on Fri, 30 Aug 2002 15:09:33 -0700
|
|
Hi Sampath,
Yeah I'm starting to have problems...
I am am getting the following error:-
Compilation Error
Description: An error occurred during the compilation of a resource
required to service this request. Please review the following specific
error details and modify your source code appropriately.
Compiler Error Message: CS0118: 'System.Web.HttpRequest.QueryString'
denotes a 'property' where a 'method' was expected
Source Error:
Line 17: string VehicleID;
Line 18:
Line 19: VehicleID = Request.QueryString("VehicleID");
Line 20:
Line 21: table= new DataTable("Lightbox");
-------------------------------------------------------
Here is the code:-
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>Retrieving Data from a Database</title>
<script language="C#" runat="server">
void Page_Load()
{
DataTable table;
DataColumn col;
DataRow row;
int i;
string VehicleID;
VehicleID = Request.QueryString("VehicleID");
table= new DataTable("Lightbox");
table.MinimumCapacity=1;
table.CaseSensitive=false;
col.AutoIncrement=true;
col.AllowDBNull=false;
col
table.Columns.Add("VehicleID",System.Type.GetType("System.String"));
col.AllowDBNull=false;
row = table.NewRow();
row["VehicleID"]= Vehicle;
table.Rows.Add(row);
DataSet ds = new DataSet(table);
dataGridControl.DataSource = table;
dataGridControl.DataSource = ds.Tables[0].DefaultView;
dataGridControl.DataSource = ds.Tables["VehicleID"];
dataGridControl.DataBind();
Response.Write(ds.Tables["VehicleID"].Rows.Count);
//Response.Write(" ");
Response.Write(ds.Tables["VehicleID"].Columns.Count);
}
</script>
</head>
<body>
<asp:DataGrid id="dataGridControl" runat="server" />
</body>
</html>
Thanx simon....
keep me posted if u still have any more issues....
I'll be happy to solve them..... cause ".Net makes IT Happen"
============================== S.Ramanujam Programmer Analyst Cognizant
technology Solutions (p) Ltd. - CTS 38 & 39 Whites Road, WCB - Whites
Road Circular Building Royapettah, Chennai - 600014 Ph : +xx xx xxx xxxx
Extn 5113 [Off]
: +xx xx xxx xxxx [Res]
-----Original Message-----
From: Simon Robinson [mailto:srobinson@g...]
Sent: Friday, August 30, 2002 10:32 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
Mike, Sampath,
I have got to say that there are some really great people on this forum
and you are definitely two of them!
I am eternally grateful for all of your help!
Keep the faith.
Simon.
-----Original Message-----
From: Mike Amundsen [mailto:mike@a...]
Sent: 29 August 2002 17:30
To: ASP+
Subject: [aspx] RE: Storing temp data
You might want to check the source code and database for the IBuySpy
store app. That app allowed folks to add items to a shopping cart
*before* they logged in as a user to close their order.
http://www.ibuyspy.com
MCA
Mike Amundsen
mca@E...
host your .NET Apps @ EraServer.NET
-----Original Message-----
From: John Pirkey [mailto:mailjohnny101@y...]
Sent: Thursday, August 29, 2002 2:15 PM
To: ASP+
Subject: [aspx] RE: Storing temp data
i once saw an application that created tables using the SessionID as the
table name
- that should be unique - and easy to determine which table to select
from.
of course, if this is a multiple IIS server environment, this will not
work, as the session ID's are not 100% guaranteed unique (although not
likely to encounter the same one).
just a thought.
john
--- Wim Verdeyen <Wim.Verdeyen@e...> wrote:
> Maybe you can store the carid's in a cookie ?
>
> -----Original Message-----
> From: Simon Robinson [mailto:srobinson@g...]
> Sent: donderdag 29 augustus 2002 18:20
> To: ASP+
> Subject: [aspx] Storing temp data
>
>
> Hi All,
>
> I have created a site where the user selects a car by model, category
> and style. The DB is queried and a list of the models is displayed.
>
> At this stage I want the user to be able to add the cars to a shopping
> basket by clicking on 'add to basket' This will be a temporary store
of
> the cars before they move on to order completion.
>
> Does anybody know what the best way to do this is? Each shopping
basket
> must have a unique ID. I have considered temporary tables in SQL
Server
> however I do not know how to create a unique name for each shopping
> basket table.
>
> Does anybody have any ideas on this or otherwise.
>
> Many thanks,
>
> Simon.
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
>
>
> ---
>
> ASP.NET 1.0 Namespace Reference with C#
> http://www.wrox.com/acon11.asp?ISBN=1861007442
>
> ASP.NET 1.0 Namespace Reference with VB.NET
> http://www.wrox.com/acon11.asp?ISBN=1861007450
>
> These books are a complete reference to the ASP.NET namespaces
> for developers who are already familiar with using ASP.NET.
> There is no trivial introductory material or useless .NET
> hype and the presentation of the namespaces, in an easy-to use
> alphabetical order ensures a user-friendly reference format.
> We provide in-depth coverage of all the major ASP.NET classes,
> giving you those real-world tips that the documentation doesn't
> offer, and demonstrating complex techniques with simple
> examples.
>
> ---
=====
----------------------------
John Pirkey
MCSD
http://www.stlvbug.org
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
---
ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442
ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450
These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.
---
|
|
|
View Cart
