using (SqlConnection conn = new SqlConnection(SQLHelper.constr))//SQLHelper.constr为数据库连接字符串
{
conn.Open();//连接数据库
//使用事务处理多SQL语句
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
}
catch (Exception)
{
trans.Rollback();
}
finally
{
conn.Close();
}
}
}
转载于:https://www.cnblogs.com/QiuJL/archive/2011/08/08/4524323.html