导入CSV文件并读取特定行VB.NET ASPX ASP.NET SQL数据表

Dim csvFile As String = "path/to/file.csv"
Dim lines As String() = File.ReadAllLines(csvFile)

Dim specificLine As Integer = 2 ' 读取第2行
Dim fields As String() = lines(specificLine - 1).Split(","c)
Dim specificValue As String = fields(0) ' 获取第一个字段的值

Dim connectionString As String = "Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password"
Dim connection As New SqlConnection(connectionString)
connection.Open()

Dim insertQuery As String = "INSERT INTO your_table (column1, column2) VALUES (@value1, @value2)"
Dim command As New SqlCommand(insertQuery, connection)
command.Parameters.AddWithValue("@value1", specificValue)
command.Parameters.AddWithValue("@value2", otherValue)
command.ExecuteNonQuery()

connection.Close()