检索int数据库并将其存储在C#中的变量中

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            string query = "SELECT YourIntColumn FROM YourTable";
            
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                int result = (int)command.ExecuteScalar();
                
                Console.WriteLine("Retrieved int value: " + result);
            }
        }
    }
}