需要帮助将某些数据从数据表动态插入到C#中

using System;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
        string query = "SELECT * FROM YourTable";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                // 从数据表中读取数据并插入到C#对象中
                int id = (int)reader["Id"];
                string name = (string)reader["Name"];
                DateTime date = (DateTime)reader["Date"];

                // 在这里可以根据需要进行进一步的处理，例如创建对象、调用方法等

                Console.WriteLine($"Id: {id}, Name: {name}, Date: {date}");
            }

            reader.Close();
        }
    }
}