使用c#从分隔文本文件中插入SQL Server表中的批量数据

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

class Program
{
    static void Main(string[] args)
    {
        // 连接字符串
        string connectionString = "Data Source=localhost;Initial Catalog=mydb;Integrated Security=True";

        // 表名
        string tableName = "mytable";

        // 文件路径
        string filePath = "data.txt";

        // 分隔符
        char delimiter = ',';

        // 批量插入数据
        BulkInsert(connectionString, tableName, filePath, delimiter);
    }

    static void BulkInsert(string connectionString, string tableName, string filePath, char delimiter)
    {
        // 创建数据表
        DataTable dataTable = new DataTable();
        dataTable.Columns.Add("Column1", typeof(string));
        dataTable.Columns.Add("Column2", typeof(string));
        dataTable.Columns.Add("Column3", typeof(string));

        // 读取文件
        using (StreamReader reader = new StreamReader(filePath))
        {
            string line;
            while ((line = reader.ReadLine()) != null)
            {
                string[] values = line.Split(delimiter);
                DataRow dataRow = dataTable.NewRow();
                dataRow["Column1"] = values[0];
                dataRow["Column2"] = values[1];
                dataRow["Column3"] = values[2];
                dataTable.Rows.Add(dataRow);
            }
        }

        // 批量插入数据
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
            {
                bulkCopy.DestinationTableName = tableName;
                bulkCopy.WriteToServer(dataTable);
            }
        }
    }
}