不同列数CSV导入DataGridView：数据不显示问题求助

需要将CSV文件导入WinForms的DataGridView，要求列数随CSV文件动态调整。目前已能生成对应数量的列，但数据无法显示，使用CsvHelper库，相关代码如下：

using CsvHelper;
using CsvHelper.Configuration;
using Microsoft.VisualBasic.FileIO;
using System;
using System.Globalization;
using System.IO;
using System.Windows.Forms;

namespace ImportCSV
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void loadCSV_button_Click(object sender, EventArgs e)
        {
            string csvFilePath = "C:\\LoadCSV\\addresses.csv"; 
            int numberOfColumns = CountColumns(csvFilePath);
            CreateDataGridViewColumns(numberOfColumns);
            LoadDataIntoDataGridView(csvFilePath);
        }
        private int CountColumns(string filePath)
        {
            int columnCount = 0;

            using (TextFieldParser parser = new TextFieldParser(filePath))
            {
                parser.SetDelimiters(",");
                parser.HasFieldsEnclosedInQuotes = true;

                if (!parser.EndOfData)
                {
                    string[] fields = parser.ReadFields();
                    columnCount = fields.Length;
                }
            }

            return columnCount;
        }

        private void CreateDataGridViewColumns(int numberOfColumns)
        {
            for (int i = 0; i < numberOfColumns; i++)
            {
                DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
                column.Name = $"Column{i + 1}";
                column.HeaderText = $"Column {i + 1}";
                dataGridView1.Columns.Add(column);
            }
        }

        private void LoadDataIntoDataGridView(string filePath)
        {
            using (var reader = new StreamReader(filePath))
            using (var csv = new CsvReader(reader, new    CsvConfiguration(CultureInfo.InvariantCulture) ))
            {
                var records = csv.GetRecords<dynamic>();
                foreach (var record in records)
                {
                    
                    DataGridViewRow row = new DataGridViewRow();
                    foreach (var property in record.GetType().GetProperties())
                    {
                                      
                        DataGridViewCell cell = new DataGridViewTextBoxCell();
                        
                       
                        cell.Value = property.GetValue(record, null);
                        dataGridView1.DataSource = record;
                        row.Cells.Add(cell);
                    }
                    dataGridView1.Rows.Add(row);
                    
                }
            }
        }
    }
}

你的代码存在几个关键问题导致数据无法显示：

• 手动创建列后，手动添加行的逻辑错误（错误设置dataGridView1.DataSource = record，破坏了DataGridView的绑定逻辑）
• 两次读取文件（计数列和读数据）既低效又可能因CSV格式差异导致列数不匹配
• 手动处理动态对象属性并添加单元格的方式易出错，不符合WinForms数据绑定的最佳实践

更简洁可靠的方式是用DataTable承载CSV数据，直接绑定到DataGridView，自动生成列和填充数据。修改后的完整代码如下：

using CsvHelper;
using CsvHelper.Configuration;
using System;
using System.Globalization;
using System.IO;
using System.Windows.Forms;
using System.Data;

namespace ImportCSV
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void loadCSV_button_Click(object sender, EventArgs e)
        {
            string csvFilePath = "C:\\LoadCSV\\addresses.csv"; 
            // 清空现有列和行，避免重复导入时出现冲突
            dataGridView1.Columns.Clear();
            dataGridView1.Rows.Clear();
            
            // 加载CSV到DataTable并绑定到DataGridView
            var dataTable = LoadCsvToDataTable(csvFilePath);
            dataGridView1.DataSource = dataTable;
        }

        private DataTable LoadCsvToDataTable(string filePath)
        {
            var dataTable = new DataTable();
            using (var reader = new StreamReader(filePath))
            using (var csv = new CsvReader(reader, new CsvConfiguration(CultureInfo.InvariantCulture)
            {
                HasHeaderRecord = true, // 若CSV无表头，改为false
                Delimiter = ","
            }))
            {
                // 读取表头并创建DataTable列
                csv.Read();
                csv.ReadHeader();
                foreach (var header in csv.HeaderRecord)
                {
                    dataTable.Columns.Add(header);
                }

                // 逐行读取数据并填充到DataTable
                while (csv.Read())
                {
                    var row = dataTable.NewRow();
                    for (int i = 0; i < csv.HeaderRecord.Length; i++)
                    {
                        row[i] = csv.GetField(i);
                    }
                    dataTable.Rows.Add(row);
                }
            }
            return dataTable;
        }
    }
}

关键修改说明 #

• 移除手动计数列和创建列的代码，改用CsvReader读取表头直接生成DataTable列，避免重复读取文件
• 用DataTable作为数据载体，直接绑定到DataGridView的DataSource，这是WinForms数据绑定的标准方式，自动处理列和行的显示
• 每次导入前清空DataGridView的现有列和行，避免重复导入时出现列重复问题
• 可根据CSV实际情况调整CsvConfiguration参数（比如HasHeaderRecord，无表头时设为false，列名将自动设为Column1、Column2等）

内容的提问来源于stack exchange，提问作者SamSamson