asp dot net project on pay roll and stock managment

i want to maintain a stock table about the items i want to if the items are sold out then i want they can be deducted from that row in the number so pls send me the code