How to code to transfer information from one table to another (ASP.NET)
Posted on 2004-03-22
I'm new to EE as well as asp.net
I'm trying to create an ecommerce website thru the learning process,
so that i can show it as part of my portfolio in later part of my life.
I have a question here...
i have table Cart, Orders, OrderDetails.
under Cart, i have columns as follows... with example entries
CartID, MemberID, ProductID, ProductName, ProductPrice, Quantity
1 77 101 Test1 $20.00 2
2 77 102 Test2 $25.00 3
CartID is the primary key to identiy each row... nothing more than that
1 MemberID can have many CartID
On button click,
how do i transfer all the rows for MemberID 77 from Cart to OrderDetails ?
juz assume that OrderDetails have the following columns:
OrderID, ProductID, ProductName, ProductPrice, Quantity
Forget about OrderID data entries.
OrderID and ProductID are the primary keys.