Use a transaction

xiaoxiao2021-03-06  40

Using (SqlConnection Conn = New SqlConnection (SQLHELPER.CONN_STRING_NON_DTC)) {

Cn.open ();

Using (SqlTransaction Trans = Conn.BegintransAction ()) {

Try {

SQLHELPER.EXECUTENONQUERY (Trans, CommandType.Text, SQL_INSERT_SIGN, SIGNPARMS);

SQLHELPER.EXECUTENONQUERY (Trans, CommandType.Text, SQL_INSERT_ACCOUNT, AccountParms);

SQLHELPER.EXECUTENONQUERY (Trans, CommandType.Text, SQL_INSERT_PROFILE, PROFILEPARMS);

TRANS.COMMIT ();

} catCH {

TRANS. ROLLBACK ();

Throw;

}

}

}

转载请注明原文地址:https://www.9cbs.com/read-74470.html

New Post(0)