Basic Questions on SQL Stored Procedure

[Rahithi]

Hi all, if we want to use Stored procedures in VB.Net page, then what are the namespaces we have to import?? and how can we implement Transaction management in the stored procedure?? thanks, Rahi

If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "

[gauthee]

system.data.sqlclient transaction can be maintained by simple way of begin transaction and thereby commit transaction or rollback the transaction. If not you can use the concurrency levels too!!!

Gautham