asp.net txt文件导入数据库

using System.IO;
using System.Text;

string filePath = "path/to/your/file.txt";
using (StreamReader reader = new StreamReader(filePath, Encoding.UTF8))
{
    string line;
    while ((line = reader.ReadLine()) != null)
    {
        // 处理每一行数据
    }
}

string line = "column1,column2,column3";
string[] columns = line.Split(',');
if (columns.Length == 3)
{
    // 处理每一列数据
}
else
{
    // 处理格式错误的情况
}

using System.Data.SqlClient;

string connectionString = "your_connection_string";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    string sql = "INSERT INTO YourTable (Column1, Column2, Column3) VALUES (@Column1, @Column2, @Column3)";
    using (SqlCommand command = new SqlCommand(sql, connection))
    {
        command.Parameters.AddWithValue("@Column1", columns[0]);
        command.Parameters.AddWithValue("@Column2", columns[1]);
        command.Parameters.AddWithValue("@Column3", columns[2]);
        command.ExecuteNonQuery();
    }
}