SqlConnection conn=new SqlConnection("server=(local);database=db_07;UserID=sa;PWD=");
conn.Open();
SqlTransaction st=con.BeginTransaction();
SqlCommand comm=con.CreateCommand();
comm.Transaction=st;
try
{
comm.CommandText="";
comm.ExecuteNonQuery();
comm.CommandText="";
comm.ExecuteQuery();
st.Commit();//提交事务
Response.Write("<script>alert('成功');</script>");
}
catch(Exception error)
{
st.Rollback();//回滚事务
}