.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Doubt about Transactions

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :ASP.Net
Hey guys sorry if this is not the place to write this post.   I've encounter a problem while using transactions on asp.net   In a procedure i'm making an INSERT then I call a store procedure that passes some values to a data reader. Well there's where the problem start, because while i'm reading this data reader I need to call another store procedure to make another insert. Since in total I have 3 store procedures i decided to make a transaction on server side so i can rollback if any problem happens on last procedure for exemple. My doubt relates to the data reader...somehow i can't call a store procedure inside the transaction if an data reader is in use. Is this true? Does the transaction have problems with this?  

View Complete Post

More Related Resource Links

Public Shared function doubt????

I am using VB.net/ASP.NET and SQL Server 2000 for a web application.

For populating the dropdowns, I wrote a Public Shared function LoadDDL(), in which I pass the dataset and dropdown name to set.

I have my doubts that this function will produce unexpected results for concurrent users. And will mix the results among sessions because it is a Shared function.

I am confused here. Is it the right way to go?

Please advice. Thanks in advance.


The Polyglot Programmer: ACID Transactions with STM.NET


STM.NET allows developers to mark their code with ACID-style transactional semantics, and leaves the grunt work of managing locks to the underlying environment.

Ted Neward

MSDN Magazine January 2010

Foundations: Easily Apply Transactions To Services


Managing state and error recovery using transactions is the topic of this month's installment of Foundations.

Juval Lowy

MSDN Magazine January 2009

Transactions: Build Scalable Systems That Handle Failure Without Losing Data


Systems that handle failure without losing data are elusive. Learn how to achieve systems that are both scalable and robust.

Udi Dahan

MSDN Magazine July 2008

NTFS: Enhance Your Apps With File System Transactions


Presented here is an overview of Transactional NTFS and how it revolutionizes transactions.

Jason Olson

MSDN Magazine July 2007

Data Points: Revisiting System.Transactions


The System.Transactions namespace of the Microsoft .NET Framework makes handling transactions much simpler than previous techniques. Read all about it this month.

John Papa

MSDN Magazine November 2006

{ End Bracket }: Transactions for Memory


Injecting parallelism into your app is easy-managed code offers things like explicit threading and a thread pool for that. Ensuring your code remains correct when run in parallel, on the other hand, is not quite so simple.

Joe Duffy

MSDN Magazine January 2006

Can't Commit?: Volatile Resource Managers in .NET Bring Transactions to the Common Type


Here Juval Lowy discusses the benefits you'll get when you implement transactions in your non-database applications, with a little help from volatile resource managers in the .NET Framework 2.0.

Juval Lowy

MSDN Magazine December 2005

Data Points: ADO.NET and System.Transactions


The Microsoft® . NET Framework versions 1. 0 and 1. 1 represented major changes in software development. However, one important thing that did not change much was support for distributed transactions.

John Papa

MSDN Magazine February 2005

top == self HTML DOM doubt


What does top == self mean?

My website loads in an iframe and this is used to check that it loads with an external banner. However I use it to ensure that the banner always shows.


However I have one more issue that the application again redirects and 2 banners are showing. Can I use some top.screenheight property to check and see if two banners are loading?




BIDS Doubt



        I m using BIDS for the first time. I m using stored procedure to retrieve data.

There are two options as Command Type with dropdown Text and stored Procedure.

I m seeing another existing report and in that one, In command Type Place, there is stored procedure and when I click dropdown, I got all the stored procedures listed there.

May I know how can I get that.? what is the difference.? I want to see my newly written stored procedure in that drop down box


web services transactions (select statement)

 Hi everybody, i'm just getting started in web services and i have a problem connecting to a database. All i want is that my web service recieves a string parameter and return a dataset so that in the client aplication i just show the result of the web service in a datagrid. Here's the code of the web service:    <%@ WebService Language="C#" CodeBehind="Service1.asmx.cs" %> using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Linq;using System.Web;using System.Web.Services;using System.Web.Services.Protocols;using System.Xml.Linq;using System.EnterpriseServices;using System.Data.SqlClient;namespace Farmacia{    [WebService(Namespace = "http://localhost/MyWebServices")]    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]    [ToolboxItem(false)]    public class Farmacia : System.Web.Services.WebService    {        private SqlDataAdapter da;        [WebMethod(TransactionOption=TransactionOption.RequiresNew)]        public DataSet Consultas (string sel)        {            if (sel == "")&


how is the the composition relation in a class able to use its parent class without any object creationexample:class A{method()}class B{A objobj.method();}here B is not having the main method its neither inherited even though due to composition relationship how is it able to acces the A class the class i have used is using C#

System.Transactions.TransactionManagerCommunicationException: Communication with the underlying tran

Hi there,I have an urgent issue at production.I hit the above mentioned exception when my application execute the line of System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)I also see this message from web server event viewer: MSDTC encountered an error (HR=0x80004005) while attempting to establish a secure connection with system <SQL Server macchine name>.I have configure the MSDTC servive as below at both web server and sql server:- Enable Network DTC Access- Allow Inbound- Allow Outbound- Select Mutual Authentication RequiredFirewall service is not running at both servers.One thing very interesting, I have exactly the same setting for development environment, it works perfectly at development environment, but not production.Please help!Thank you very much.Regards,Fenny

Doubt in sp execution

Hi,  i am executing sp in one of my database it is taking 4 minutes to complete execution. where as i am executing same sp in different database it is taking only 1 millisecond to complete execution. i have checked the table settings such as index and table data also everything is same. now i want to find where is the problem. what are steps to find such kind of problems.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend