Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
longinos
Starting Member
11 Posts |
 Posted - 2007-10-04 : 18:11:51
|
| How do you fill out an order form; there is an Order(OrderID, CustomerID, Subtotal, Tax, Total), Orderdetail(OrderID, ProductID, Qty, UnitPrice, ExtendedPrice)How do I get those tow together in the same form, which can be called order, or invoice it doesn't matter as long as I can get them in the same form numberd like order 1, then order 2, ect. is it by stored procedure, or by ado.net, or both ? or is there anywhere I can find information? like a book? or website ?For example;Order no. 1, Customer 3, Product 3, Qty 2, UnitPrice $20.00, ExtendedPrice $40.00Product 2, Qty 3, UnitPrice $10.00, ExtendedPrice $30.00Product 4, Qty 2, UnitPrice $5.00, ExtendedPrice $10.00 ---here I can be adding as many as neededSubtotal $80.00Tax $5.00Total $85.00 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 18:17:48
|
| It's your third post of same issue:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90503 |
 |
|
|
|
|
|
|
|
orders form