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 : 16:36:40
|
| 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 |
|
|
|
|
|
|
|
order form