excuse_potti
asked on
How to code to transfer information from one table to another (ASP.NET)
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i see the point in your suggesstion.....
my database design is inefficient.