[code]
static void Main(string[] args)
{
using (TransactionScope scope = new TransactionScope())
{
SqlConnection sqlConn = new SqlConnection(
ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString);
sqlConn.Open();
string insertSql = "insert into [TransTestTable] values(11,'11')";
string updateSql = "update [TransTestTable] set [Name] = '111' where [Id] = 11";
SqlCommand sqlComm = new SqlCommand(insertSql, sqlConn);
sqlComm.CommandType = System.Data.CommandType.Text;
sqlComm.ExecuteNonQuery();
sqlComm = new SqlCommand(updateSql, sqlConn);
sqlComm.CommandType = System.Data.CommandType.Text;
sqlComm.ExecuteNonQuery();
sqlConn.Close();
scope.Complete();
}
Console.ReadLine();
}
[/code]
本文来自优快云博客,转载请标明出处:http://blog.youkuaiyun.com/tjvictor/archive/2009/04/14/4074240.aspx