Copy data from one table to another using asp.net

[monkeymagic2222]

Hi,

I have 2 sql tables, one called tbl_orders and one called tbl_stock.

When a user places an order, the details of that order go into the tbl_orders table. The order then comes to us to process. A status field in this table is set to "ordered"

When the item comes in I would like to update the status field in the orders table to say "complete" and then add this information, as well as some new detail (such as item serial number, etc.) as a new record to the stock table.

I can do this with classic asp but only have basic asp.net knowledge.

Any tips or help would be much appreciated!

 

[jbenson001]

I doesn't matter if you are using ASP or ASP.NET. What you want to do needs to be done with SQL. Sounds like a trigger might work for what you want.