asp.net 事务回滚

      

        string getTitle = this.TextBox1.Text;
        string getAuthor = this.TextBox2.Text;
        string sql = "insert into 表(title,author) values ('" + getTitle + "','" + getAuthor + "'); select @@identity AS RID";

       //string sql = "insert into DepartMent(DepartMentName,DepartMentCode) values ('" + getName + "','" + getCode + "');insert into DepartMent(ID,DepartMentName) values ('"+@@identity +"','新部门测试')";
        string connStr = System.Configuration.ConfigurationManager.AppSettings["fff"].ToString();

        SqlConnection myconn = new SqlConnection(connStr);
        SqlCommand mycomm = new SqlCommand(sql,myconn);
        myconn.Open();
        SqlTransaction myTrans = myconn.BeginTransaction();
        mycomm.Transaction = myTrans;

        try
        {
            mycomm.ExecuteNonQuery();
            myTrans.Commit();
        }
        catch
        {
            myTrans.Rollback();
        }
        finally
        {
            myconn.Close();
        }