62,046
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn = null;
SqlCommand cmd = null;
SqlTransaction tran = null;
try
{
string strConn = "";
conn = new SqlConnection(strConn);
cmd = new SqlCommand();
cmd.Connection = conn;
string strSql1 = "";
conn.Open();
conn.BeginTransaction();
cmd.CommandText = strSql1;
cmd.ExecuteNonQuery();
string strSql2 = "";
cmd.CommandText = strSql2;
cmd.ExecuteNonQuery();
tran.Commit();
conn.Close();
}
catch
{
tran.Rollback();
conn.Close();
}