حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to begin and end sql transaction in asp.net code

suchitra

SOLVED CLOSED ACTIVE ANSWERED
User: suchitra
Posted: on Feb 05, 2012 10:12 PM
Forum: ASP.Net Web Forms
Answer: 2
Views: 5325

Hi,

I have not used sql transactions in my code in asp.net. How to begin and end it.. ?

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 3

Reply
ANSWER
User: Mudassar
Replied: on Feb 05, 2012 11:38 PM
Report

This way

CREATE PROCEDURE Test
	
AS
BEGIN
	SET NOCOUNT ON;
	BEGIN TRY
		BEGIN TRANSACTION
		
		--Queries here
		
		COMMIT TRANSACTION
	END TRY  
	BEGIN CATCH
		ROLLBACK TRANSACTION
	END CATCH
END
GO

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

How to begin and end sql transaction in asp.net code

Company

Explore

Follow us

Contact Us