在C#中显示@@ROWCOUNT

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "UPDATE YourTable SET YourColumn = 'NewValue' WHERE YourCondition";

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

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                int rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine($"Number of rows affected: {rowsAffected}");
            }

            int rowCount;
            using (SqlCommand command = new SqlCommand("SELECT @@ROWCOUNT", connection))
            {
                rowCount = (int)command.ExecuteScalar();
            }

            Console.WriteLine($"@@ROWCOUNT: {rowCount}");

            connection.Close();
        }
    }
}