How to use transaction in asp.net give me a step by step ex.

Question

hello.. sir
 i don,t know about the store procedure and transaction  i am always use Query in my project but that time i have need the transaction/store procedure used for updating two table record plse give me step by step example ....plz i am fresher.....