110,534
社区成员
发帖
与我相关
我的任务
分享
SqlTransaction ts1 = conn.BeginTransaction();
//ts1
SqlCommand cmd = new SqlCommand("ResgionInsert", conn);
cmd.Transaction = ts1;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter id = new SqlParameter("@ID", SqlDbType.Int, 0, ParameterDirection.Output, false, 0, 0, "id", DataRowVersion.Default, null);
SqlParameter name = new SqlParameter("@name", SqlDbType.NVarChar);
name.Value = "Neal Liu";
SqlParameter age = new SqlParameter("@age", SqlDbType.Int);
age.Value = 21;
cmd.Parameters.Add(id);
cmd.Parameters.Add(name);
cmd.Parameters.Add(age);
cmd.UpdatedRowSource = UpdateRowSource.OutputParameters;
int newId = -1;
SqlCommand cmd1 = new SqlCommand("select * from stu", conn);
cmd1.Transaction = ts1;
try
{
cmd.ExecuteNonQuery();
newId = (int)cmd.Parameters["@ID"].Value;
SqlDataReader dr = cmd1.ExecuteReader();
dt.Load(dr);
ts1.Commit();
}
catch
{
ts1.Rollback();
}
SqlTransaction ts2 = conn.BeginTransaction();
SqlCommand cmd2 = new SqlCommand("select * from stu", conn);
cmd2.Transaction = ts2;
try
{
SqlDataReader dr2 = cmd2.ExecuteReader();
dt.Load(dr2);
ts2.Commit();
}
catch
{
ts2.Rollback();
}
}