使用C sharp对象动态填充select

using System;
using System.Data;
using System.Reflection;

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

public class Program
{
    public static void Main()
    {
        // 模拟从数据库中获取的查询结果
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("Name", typeof(string));
        dataTable.Columns.Add("Age", typeof(int));
        dataTable.Rows.Add("John", 25);
        dataTable.Rows.Add("Alice", 30);

        // 动态填充select
        var select = new List<Person>();
        foreach (DataRow row in dataTable.Rows)
        {
            var person = new Person();
            foreach (DataColumn column in dataTable.Columns)
            {
                PropertyInfo property = person.GetType().GetProperty(column.ColumnName);
                if (property != null && row[column] != DBNull.Value)
                {
                    property.SetValue(person, row[column]);
                }
            }
            select.Add(person);
        }

        // 输出结果
        foreach (var person in select)
        {
            Console.WriteLine($"Name: {person.Name}, Age: {person.Age}");
        }
    }
}