Need Details code of Transaction in .net 2.0

[shashikant.262]

Hi Every One,
I am new to .net and i want to use transaction in my code for storing and manipulation of the data .

basically i use transaction for insert , update , delete query and two sp which used in the coding ....

for insertion , updation and deletion i use command.commandtext = mstrsql
and after that command.executenonquery () for my sql query...

but for my stored procedure i don't now how to use it.

basically my first stored procedure returns multiple records , and the second one does not returns any records for that for first one i use dataaddapter, and for 2nd query i use executenonquery .....

if any one in this form have the code and technique then let me know ....
the suggestion will be heartly appreciated by me ....
I need this very urgen.......


Hope all of u understand my problem
thanx in advance.....

 

[cjard]

Read the DW2 link in my signature, section "Saving data in a transaction"