aspcms数据库锁死

using System;
using System.Data.SqlClient;

public class DatabaseHelper
{
    private string connectionString = "your_connection_string_here";

    public void ExecuteTransaction()
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            SqlTransaction transaction = connection.BeginTransaction();

            try
            {
                SqlCommand command1 = new SqlCommand("UPDATE Table1 SET Column1 = 'Value1' WHERE ID = 1", connection, transaction);
                SqlCommand command2 = new SqlCommand("UPDATE Table2 SET Column2 = 'Value2' WHERE ID = 2", connection, transaction);

                command1.ExecuteNonQuery();
                command2.ExecuteNonQuery();

                transaction.Commit();
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                Console.WriteLine("Transaction rolled back due to an error: " + ex.Message);
            }
        }
    }
}