快救命呀

[badboy2002]

在vb.net里怎样创建一个带事务的组件，给段小代码。

[acewang]

Public Sub RunSqlTransaction(myConnString As String)
Dim myConnection As New SqlConnection(myConnString)
myConnection.Open()

Dim myCommand As New SqlCommand()
Dim myTrans As SqlTransaction

' Start a local transaction
myTrans = myConnection.BeginTransaction(IsolationLevel.ReadCommitted, "SampleTransaction")
' Must assign both transaction object and connection
' to Command object for a pending local transaction
myCommand.Connection = myConnection
myCommand.Transaction = myTrans

Try
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
myCommand.ExecuteNonQuery()
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
myCommand.ExecuteNonQuery()
myTrans.Commit()
Console.WriteLine("Both records are written to database.")
Catch e As Exception
myTrans.Rollback("SampleTransaction")
Console.WriteLine(e.ToString())
Console.WriteLine("Neither record was written to database.")
Finally
myConnection.Close()
End Try
End Sub 'RunSqlTransaction

[kandyasp]

不错

[badboy2002]

我说的不是数据操作的事务，而指的是Dim tran As System.EnterpriseServices.ContextUtil应用

[酋长]

The following schematic code shows how to use ContextUtil to create a transactional ServicedComponent.

[C#]
[Transaction]
public class TransactionalComponent : ServicedComponent
{

public void TransactionalMethod (string data)
{

ContextUtil.DeactivateOnReturn = true;
ContextUtil.MyTransactionVote = TransactionVote.Abort;

// Do work with data. Return if any errors occur.

// Vote to commit. If any errors occur, this code will not execute.
ContextUtil.MyTransactionVote = TransactionVote.Commit;

}

}

[酋长]

另外可以参考：
http://chs.gotdotnet.com/quickstart/aspplus/doc/mtstransactions.aspx

[standy]

public class NYXCRule : ServicedComponent
{
/// <summary>
/// 构造函数
/// </summary>
public NYXCRule()
{
}

/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE"></param>
private void CheckCorrect(BaseEntity p_BE)
{
NYXC NY=(NYXC)p_BE;
}
/// <summary>
/// 检查将要操作的数据是否符合业务规则
/// </summary>
/// <param name="p_BE1">单身实体</param>
private void CheckCorrect2(BaseEntity p_BE2)
{
NYXCAttach NYA=(NYXCAttach)p_BE2; //单身
}

/// <summary>
/// 显示所有符合条件的数据
/// </summary>
/// <param name="p_Condition">要显示的条件</param>
[AutoComplete]
public DataTable ShowAll(string p_Condition)
{
try
{
string SqlStr="SELECT * FROM UV_Rpt_NYXC WHERE ID<>0 "+p_Condition;
return SysUtils.Fill(SqlStr);
}
catch(BaseException)
{
throw;
}
catch(Exception E)
{
throw new BaseException(E.Message);
}
}