asp.net csv导入数据库

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

public class CsvImporter
{
    public void ImportCsv(string csvFilePath, string connectionString)
    {
        // 读取 CSV 文件
        string[] lines = File.ReadAllLines(csvFilePath);
        string[] headers = lines[0].Split(',');

        // 创建 DataTable
        DataTable dataTable = new DataTable();
        foreach (string header in headers)
        {
            dataTable.Columns.Add(header);
        }

        // 填充 DataTable
        for (int i = 1; i < lines.Length; i++)
        {
            string[] values = lines[i].Split(',');
            DataRow row = dataTable.NewRow();
            for (int j = 0; j < headers.Length; j++)
            {
                row[headers[j]] = values[j];
            }
            dataTable.Rows.Add(row);
        }

        // 连接数据库并插入数据
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
            {
                bulkCopy.DestinationTableName = "YourTableName";
                bulkCopy.WriteToServer(dataTable);
            }
        }
    }
}