110,568
社区成员
发帖
与我相关
我的任务
分享
conn.Open();
SqlTransaction trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sqlDelete, parms1);
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms2);
}
trans.Commit();
}
catch (Exception e) {
trans.Rollback();
throw new ApplicationException(e.Message);
}
finally {
conn.Close();
}
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection(connectionString);
try {
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
cmd.CommandType = cmdType;
SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return rdr;
}
catch {
conn.Close();
throw;
}
using (SqlCommand cmd = new SqlCommand(selectStr, conn);)
{
conn.Open();
SqlTransaction ts = conn.BeginTransaction(IsolationLevel.ReadUncommitted);
cmd.Transaction = ts;
try
{
SqlDataReader dr = cmd.ExecuteReader();
Update();
while (dr.Read())
{
Console.WriteLine("{0},{1}", dr[0], dr[1]);
}
dr.Close();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine("{0},{1}", dr[0], dr[1]);
}
dr.Close();
trans.Commit();
SqlTransaction ts = conn.BeginTransaction(IsolationLevel. RepeatableRead);
cmd.Transaction = ts;
try
{
SqlDataReader dr = cmd.ExecuteReader();
Update();
Add();
while (dr.Read())
{
Console.WriteLine("{0},{1}", dr[0], dr[1]);
}
dr.Close();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine("{0},{1}", dr[0], dr[1]);
}
dr.Close();
trans.Commit();
SqlTransaction ts = conn.BeginTransaction(IsolationLevel. Snapshot);
cmd.Transaction = ts;
try
{
SqlDataReader dr = cmd.ExecuteReader();
Update();
while (dr.Read())
{
Console.WriteLine("{0},{1}", dr[0], dr[1]);
}
dr.Close();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine("{0},{1}", dr[0], dr[1]);
}
dr.Close();
trans.Commit();