SQL C#接口- SQL加载填充了额外空格的数据。

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "SELECT * FROM YourTable";

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

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        string data = reader.GetString(0).Trim(); // 使用TRIM函数去除额外空格
                        Console.WriteLine(data);
                    }
                }
            }
        }
    }
}