What happens to pending transactions if a SqlTransaction instance is closed before a commit or rollback is performed?
Thanks in advance!
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21687168.html
Zones:
C#Date Answered: 01/06/2006 Rating: 9.8 Views: 0
Hello experts!
Does SqlTransaction work with Oracle? I know that SqlTransaction does work with SQL Server. If it doesn't work with Oracle, do I have to change something?
=======
Dim myTrans As...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20862065.html
Zones:
.NETDate Answered: 01/25/2004 Rating: 8.6 Views: 0
I am writing my winform client updating process with a few web methods located in two web servers. I need to execute transaction for the all-or-none updating process using those web methods. I th...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_21015090.html
Zones:
.NETDate Answered: 06/28/2004 Rating: 8.6 Views: 4
I have a stored procedure that I am calling as shown below, but I can not figure out how to bind that to a gridview. Can someone tell me how and at what point I should connect the gridview?
Than...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_22033697.html
Using Vb.Net (3.5), SQL 2005
I have 5 Updates that I run on a database that are all in separate Procedures. They all use the same connection object. They use different dataadapters and comma...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_24464708.htm...
I am using ASP.NET / VB.NET to access SQL Server 2000. I am accessing an table to insert / update which is heavily hit during peak hours of usage. The following is the piece of code which is does n...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20504881.html
Zones:
MS SQL ServerDate Answered: 09/03/2003 Rating: 6.0 Views: 14
Consider the following code in an application, which writes some data rows in the database.
SqlTransaction trans = m_connection.BeginTransaction();
adapter.InsertCommand.Connection = m_connec...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20641203.html
Zones:
MS SQL ServerDate Answered: 07/10/2004 Rating: 8.4 Views: 0
Hello,
I am facing a problem in my application. This occurs when I synchronize data from one sql server to another via internet.
The problem is only faced on Windows 98, ME and some versions of...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_20974591.htm...
Good day all..
I have a need to be able to handel nested transactions. It seems that what I want is not easily attained.
I just about have what I need but...
Here's the situation...
...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21108705.htm...
Hi,
I have an Order object that has a Persist() method, and a Items array that contains OrderItem objects. Within the Persist() method of the Order class, I am calling the Persist() method of ea...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21139403.html
