将表示SQL查询中的记录数(计数)的值赋给C#中的变量。

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串

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

            string sqlQuery = "SELECT COUNT(*) FROM YourTable"; // 替换为你的SQL查询语句

            using (SqlCommand command = new SqlCommand(sqlQuery, connection))
            {
                int recordCount = (int)command.ExecuteScalar();
                Console.WriteLine("记录数: " + recordCount);
            }
        }
    }
}