Click here to Skip to main content
15,917,731 members
Home / Discussions / C#
   

C#

 
GeneralRe: Filenames and open file dialog Pin
SRJ9229-Mar-10 10:07
SRJ9229-Mar-10 10:07 
QuestionDoes anybody have ups rate calculator for asp.net? Pin
bigeyed29-Mar-10 7:15
bigeyed29-Mar-10 7:15 
AnswerRe: Does anybody have ups rate calculator for asp.net? Pin
Not Active29-Mar-10 7:28
mentorNot Active29-Mar-10 7:28 
AnswerRe: Does anybody have ups rate calculator for asp.net? Pin
Dave Kreskowiak29-Mar-10 9:57
mveDave Kreskowiak29-Mar-10 9:57 
Questiondid you Google Block Gmail?! Pin
Jassim Rahma29-Mar-10 5:50
Jassim Rahma29-Mar-10 5:50 
AnswerRe: did you Google Block Gmail?! Pin
Richard MacCutchan29-Mar-10 6:41
mveRichard MacCutchan29-Mar-10 6:41 
GeneralRe: did you Google Block Gmail?! Pin
Jassim Rahma29-Mar-10 11:30
Jassim Rahma29-Mar-10 11:30 
GeneralRe: did you Google Block Gmail?! [modified] Pin
Richard MacCutchan29-Mar-10 11:41
mveRichard MacCutchan29-Mar-10 11:41 
QuestionTreeview aftercheck Pin
Wannes Geysen29-Mar-10 5:21
Wannes Geysen29-Mar-10 5:21 
AnswerRe: Treeview aftercheck Pin
Kevin Marois29-Mar-10 5:28
professionalKevin Marois29-Mar-10 5:28 
AnswerRe: Treeview aftercheck Pin
Tarakeshwar Reddy29-Mar-10 6:44
professionalTarakeshwar Reddy29-Mar-10 6:44 
GeneralRe: Treeview aftercheck Pin
Wannes Geysen29-Mar-10 21:25
Wannes Geysen29-Mar-10 21:25 
QuestionGet list of groups for a given user using ActiveDirectory Pin
QuickDeveloper29-Mar-10 2:18
QuickDeveloper29-Mar-10 2:18 
AnswerRe: Get list of groups for a given user using ActiveDirectory Pin
Abhinav S29-Mar-10 4:05
Abhinav S29-Mar-10 4:05 
QuestionAutomatic Server Shutdown Pin
FJJCENTU29-Mar-10 0:18
FJJCENTU29-Mar-10 0:18 
AnswerRe: Automatic Server Shutdown Pin
DaveyM6929-Mar-10 0:48
professionalDaveyM6929-Mar-10 0:48 
AnswerRe: Automatic Server Shutdown Pin
David Skelly29-Mar-10 1:56
David Skelly29-Mar-10 1:56 
AnswerRe: Automatic Server Shutdown Pin
Dave Kreskowiak29-Mar-10 3:43
mveDave Kreskowiak29-Mar-10 3:43 
QuestionRemoving items from list while performing operations on it Pin
xkrja29-Mar-10 0:17
xkrja29-Mar-10 0:17 
AnswerRe: Removing items from list while performing operations on it Pin
Keith Barrow29-Mar-10 0:47
professionalKeith Barrow29-Mar-10 0:47 
AnswerRe: Removing items from list while performing operations on it Pin
SeMartens29-Mar-10 0:48
SeMartens29-Mar-10 0:48 
Questionusing (SqlTransaction... ) Pin
Dewald29-Mar-10 0:12
Dewald29-Mar-10 0:12 
AnswerRe: using (SqlTransaction... ) Pin
Eddy Vluggen29-Mar-10 1:06
professionalEddy Vluggen29-Mar-10 1:06 
AnswerRe: using (SqlTransaction... ) Pin
Keith Barrow29-Mar-10 1:07
professionalKeith Barrow29-Mar-10 1:07 
AnswerRe: using (SqlTransaction... ) Pin
PSK_29-Mar-10 1:08
PSK_29-Mar-10 1:08 
You should be using it through using block like following


  using (SqlTransaction mySqlTransaction = mySqlConnection.BeginTransaction())
{
    // First SQL command that is part of an atomic transaction
    using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
    {
        mySqlCommand.ExecuteScalar(); // or whatever
    }   // Second SQL command that is part of an atomic transaction
    using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
    {
        mySqlCommand.ExecuteScalar(); // or whatever
    }
    mySqlTransaction.Commit();
}



Using block implements try-catch-finally internally, so your transaction will be rolled backed automatically in case any exception occurs.
WWW, WCF, WWF, WPF, WFC .... WTF

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.