Hopw to insert primay key in another table in sql server sing asp.net C#
I have two table one order table col(orderID(PK),CustomerName) and second one table is order detail col(OrderID(FK),Productionname,qty).
Now i want that when i insert product then orderID auto insert into Order detail table.
Product table is separate and customer table also separate.
Please try to understand.
Gridview
Add Product button |
Delete Product button |
Order ID |
Product |
QTY |
Rate |
Total Amount |
Save button
|
Delete button
|
Please consider my this question.Thanks