Is it possible to create a shopping cart facility that stores data in a 

dataset and continually adds to it as the user shops through a site.  The 

data will come from selections made on a form.  Once the user is finished 

I want to modify the contents of the dataset before doing an insert to the 

database.



I want to hit the database only once, when the user has confirmed data in 

the dataset.



So far, when I bind a datagrid to the dataset to view it, I only have the 

last item that I have added (using newrow, then add method of the 

dataTable.



I thought my approached would build a dataset from empty to full of my 

selections made throughout my shopping site.



I am using VB, and only one aspx page.  All content is designed as various 

user controls, which are added and removed from my main aspx page.



Can you help?



Cheers

Are you placing the DataSet in the Session, or Cache, or ViewState?



I prefer a Database first, then Session, then Cache.

 

tc



-----Original Message-----

From: yvonne [mailto:yvonne.dickson@p...] 

Sent: Wednesday, March 06, 2002 4:32 AM

To: ASP+

Subject: [aspx] shopping cart



Is it possible to create a shopping cart facility that stores data in a 

dataset and continually adds to it as the user shops through a site.  The 

data will come from selections made on a form.  Once the user is finished 

I want to modify the contents of the dataset before doing an insert to the 

database.



I want to hit the database only once, when the user has confirmed data in 

the dataset.



So far, when I bind a datagrid to the dataset to view it, I only have the 

last item that I have added (using newrow, then add method of the 

dataTable.



I thought my approached would build a dataset from empty to full of my 

selections made throughout my shopping site.



I am using VB, and only one aspx page.  All content is designed as various 

user controls, which are added and removed from my main aspx page.



Can you help?



Cheers

I would like to use the viewstate.  When the data is confirmed by the user I

will use a database to hold the data.  The database will provide a history

of data collected.



It all turns horrible when I can't seem to add additional datarows to the

datatable in the dataset.  I am using all the right methods to add.  I fill

the dataTable with nine rows on the page load.  On the post back I add one

more row, using the correct method.  I bind a datagrid just to view and have

only row ten to show(the row I added on the postback)



Surely I do not need to hit the database for every row I need to add on the

postback?



DataSets are disconnected data, I want to build the data in a disconnected

environment and then resist it in a db when I am ready to.  This would

enable me to hit the db just once.



Any ideas





-----Original Message-----

From: ToddC@m... [mailto:ToddC@m...] 

Sent: 06 March 2002 15:46

To: ASP+

Subject: [aspx] RE: shopping cart



Are you placing the DataSet in the Session, or Cache, or ViewState?



I prefer a Database first, then Session, then Cache.

 

tc



-----Original Message-----

From: yvonne [mailto:yvonne.dickson@p...] 

Sent: Wednesday, March 06, 2002 4:32 AM

To: ASP+

Subject: [aspx] shopping cart



Is it possible to create a shopping cart facility that stores data in a 

dataset and continually adds to it as the user shops through a site.  The 

data will come from selections made on a form.  Once the user is finished 

I want to modify the contents of the dataset before doing an insert to the 

database.



I want to hit the database only once, when the user has confirmed data in 

the dataset.



So far, when I bind a datagrid to the dataset to view it, I only have the 

last item that I have added (using newrow, then add method of the 

dataTable.



I thought my approached would build a dataset from empty to full of my 

selections made throughout my shopping site.



I am using VB, and only one aspx page.  All content is designed as various 

user controls, which are added and removed from my main aspx page.



Can you help?



Cheers

In your case, how is it possible to check Inventory each time the user 

selects an item, if you insert all items at the end of transaction at once.

 



Siva Ram Mateti 





> Is it possible to create a shopping cart facility that stores data in a 

> dataset and continually adds to it as the user shops through a site.  

The 

> data will come from selections made on a form.  Once the user is 

finished 

> I want to modify the contents of the dataset before doing an insert to 

the 

> database.

> 

> I want to hit the database only once, when the user has confirmed data 

in 

> the dataset.

> 

> So far, when I bind a datagrid to the dataset to view it, I only have 

the 

> last item that I have added (using newrow, then add method of the 

> dataTable.

> 

> I thought my approached would build a dataset from empty to full of my 

> selections made throughout my shopping site.

> 

> I am using VB, and only one aspx page.  All content is designed as 

various 

> user controls, which are added and removed from my main aspx page.

> 

> Can you help?

> 

> Cheers