ASP.NET里的事务处理(运用sql)

[原创]

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class tranTest_sql : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strConn = System.Configuration.ConfigurationManager.AppSettings["sqlConnectionStringusertest"];
        SqlConnection conn = new SqlConnection(strConn);
        conn.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = "sqlTest";
        cmd.CommandType = CommandType.StoredProcedure;
        try
        {
            cmd.ExecuteNonQuery();
            Response.Write("成功执行语句!");
        }
        catch (Exception error)
        {
            Response.Write("语句没有成功执行:<br><br>"+error.Message.ToString());
        }
    }
}

---

--drop procedure sqlTest
create procedure sqlTest
as
  begin tran
     insert into tranTest (id,name,sex) values (6,'廖平','女')
        if (@@error<>0)
            begin
               rollback tran
            end
     insert into tranTest  (id,name,sex) values (7,'龚小军','男')
        if (@@error<>0)
           begin
               rollback tran
            end
 commit tran
  GO