如何导入csv文件并将数据显示在html表中，然后保存到asp .net内核的sql数据库中。

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

public class CsvImporter
{
    public DataTable ImportCsvData(string filePath)
    {
        DataTable dataTable = new DataTable();
        string[] csvData = File.ReadAllLines(filePath);

        if (csvData.Length > 0)
        {
            // 解析CSV文件的表头
            string[] headers = csvData[0].Split(',');
            foreach (string header in headers)
            {
                dataTable.Columns.Add(header);
            }

            // 解析CSV文件的数据行
            for (int i = 1; i < csvData.Length; i++)
            {
                string[] rows = csvData[i].Split(',');
                DataRow dataRow = dataTable.NewRow();
                for (int j = 0; j < headers.Length; j++)
                {
                    dataRow[j] = rows[j];
                }
                dataTable.Rows.Add(dataRow);
            }
        }

        return dataTable;
    }
}

// 假设已经通过AJAX从后端获取到了csvData变量，其中包含了CSV数据
var table = document.getElementById("csvTable");

for (var i = 0; i < csvData.length; i++) {
  var row = table.insertRow(i);

  for (var j = 0; j < csvData[i].length; j++) {
    var cell = row.insertCell(j);
    cell.innerHTML = csvData[i][j];
  }
}

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

public class DataSaver
{
    public void SaveDataToSql(DataTable dataTable, string connectionString)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 创建一个用于插入数据的SqlCommand对象
            using (SqlCommand command = connection.CreateCommand())
            {
                command.CommandType = CommandType.Text;
                command.CommandText = "INSERT INTO YourTableName (Column1, Column2, ...) VALUES (@Value1, @Value2, ...)";

                // 遍历DataTable的每一行，并将数据插入到SQL数据库中
                foreach (DataRow row in dataTable.Rows)
                {
                    command.Parameters.Clear();
                    command.Parameters.AddWithValue("@Value1", row["Column1"]);
                    command.Parameters.AddWithValue("@Value2", row["Column2"]);
                    // ...

                    command.ExecuteNonQuery();
                }
            }
        }
    }
}