如何从Txt文件创建和填充Datatable

Name,Age,City
Alice,30,New York
Bob,25,Los Angeles
Charlie,35,Chicago

using System;
using System.Data;
using System.IO;

class Program
{
    static void Main()
    {
        string filePath = "data.csv";
        DataTable dataTable = new DataTable();

        // 创建列
        dataTable.Columns.Add("Name", typeof(string));
        dataTable.Columns.Add("Age", typeof(int));
        dataTable.Columns.Add("City", typeof(string));

        // 读取文件并填充数据
        using (StreamReader reader = new StreamReader(filePath))
        {
            string line;
            bool isHeader = true;

            while ((line = reader.ReadLine()) != null)
            {
                if (isHeader)
                {
                    isHeader = false;
                    continue; // 跳过标题行
                }

                string[] values = line.Split(',');
                DataRow row = dataTable.NewRow();
                row["Name"] = values[0];
                row["Age"] = int.Parse(values[1]);
                row["City"] = values[2];
                dataTable.Rows.Add(row);
            }
        }

        // 输出DataTable内容
        foreach (DataRow row in dataTable.Rows)
        {
            Console.WriteLine($"Name: {row["Name"]}, Age: {row["Age"]}, City: {row["City"]}");
        }
    }
}