没有例外，但我的数据没有写入SQL Server数据库

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Server=your_server;Database=your_database;User Id=your_user;Password=your_password;";
        try
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Connected to the database.");
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("Connection failed: " + ex.Message);
        }
    }
}

INSERT INTO YourTable (Column1, Column2) VALUES ('Value1', 'Value2');

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlTransaction transaction = connection.BeginTransaction();
    try
    {
        SqlCommand command = new SqlCommand("INSERT INTO YourTable (Column1, Column2) VALUES ('Value1', 'Value2')", connection, transaction);
        command.ExecuteNonQuery();
        transaction.Commit();
        Console.WriteLine("Data inserted successfully.");
    }
    catch (Exception ex)
    {
        transaction.Rollback();
        Console.WriteLine("Transaction rolled back: " + ex.Message);
    }
}