Asp.net中的事务处理(sql)

using System;
using System.Data;
using System.Configuration;
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;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=sufei;Integrated Security=True");
        con.Open();
        SqlTransaction mqtransaction = con.BeginTransaction();
        SqlCommand comm = new SqlCommand();
        comm.Connection = con;
        comm.Transaction = mqtransaction;
        try
        {
            comm.CommandText = "INSERT INTO levelogion(学号, 姓名, 性别)VALUES ('sufdytytytufei', '4', '4')";
            comm.ExecuteNonQuery();
            comm.CommandText += "INSERT INTO levelogion(学号, 姓名, 性别)VALUES ('sufeisufei', '4', '4')";
            mqtransaction.Commit();
            Response.Write("成功");
        }
        catch (Exception ee)
        {
            mqtransaction.Rollback();
            Response.Write(ee.ToString());
            Response.Write("不成功");
        }
        finally
        {
            con.Close();
            comm.Dispose();
        }

    }
}