How To Mix SqlTransaction
May 2, 2012'Credit to Daniel and Adrian.
Imports System.Data.Common
Imports System.Data.Common.DbDataAdapter
Module mdlDBConnect
[code]....
How to Mix SqlTransaction?
ADVERTISEMENT
SqlTransaction Shared Between Functions
May 21, 2010I've created a global sqlConnection in my app and it works fine for sharing the connection between functions. I have also defined a global sqlTransaction that I'd like to share between functions also, so I don't have to pass it around during a complex update but it's not working as I hoped.
Module Master
Public sqlConnString As String
Public SQL As String
[Code]....
Disable Read / Write To A Table Via SqlTransaction
Feb 16, 2011How to use SqlTransaction in .net 2.0 so that when I start reading data from a table, that table is blocked for others (other programs) to read/write to that table? If SqlTransaction is not a good option, than what is?
View 1 RepliesDelete Contents Of A Related Record From Two Tables( Using SQLTransaction)?
Dec 15, 2011I'm getting "Format of the initialization string does not conform to specification starting at index 0" error having used the following code. The commands are supposed to delete a related record from two tables namely StudentDetails.Students as the master table and RegistrationDetails.Registration as the child table. [code]...
View 1 RepliesC# - System.Data.SqlClient.SqlTransaction.Dispose - Protected Override Void Dispose(bool Disposing)
Jun 25, 2012I looked at the Dispose() method in System.Data.SqlClient.SqlTransaction (using a decompiler):
[Code]....
Why does everyone say in forums that it is Rolling back in the dispose? Where does it rollback?