学步园

protected void Page_Load(object sender, EventArgs e)
        {
            
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnStr"].ToString()))
            {
                conn.Open();
                SqlTransaction _transaction = conn.BeginTransaction();                  
                try
                {
                    SqlCommand _cmd = new SqlCommand("Insert Into T_Test(F_Name) values(@Name)",conn);
                    _cmd.Parameters.Add(new SqlParameter("@Name", "Test1"));
                    _cmd.Transaction = _transaction;
                    _cmd.ExecuteNonQuery();

                    _cmd.Parameters.Clear();
                    _cmd.Parameters.Add(new SqlParameter("@Name", "Test2" + new String('2', 100)));
                    _cmd.ExecuteNonQuery();//F_Name为Nvarchar(50)，这里会报错

                    _transaction.Commit();

                    Response.Write("二条记录已经成功入库!");
                }
                catch (Exception ex)
                {
                    Response.Write("发生错误：" + ex.Message.ToString());
                    try
                    {
                        _transaction.Rollback();
                        Response.Write("<br/>事务已成功回滚!");
                    }
                    catch (Exception ex2)
                    {
                        Response.Write("<br/>回滚失败：" + ex2.Message.ToString());
                    }
                }
                _transaction.Dispose();
            }
        }