在sap匯出的csv資料，想在asp.net上匯入到DataTable里。提示 “在選定的資料源上未找到名為“Purchase Order ID”的欄位或屬性。”，而用WPS保存下，又可以。是什么原因造成的？
...
Dim strConn As String = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='text;HDR=Yes;FMT=Delimited;CharacterSet=65001';Data Source='" & mp & "'")
'連接資料。 Data Source為CSV檔案存在的目錄
Dim conn As New OleDbConnection(strConn)
Dim dt1 As New DataTable()
Dim sql As String = "select * from (" + filename + ") "
conn.Open()
Dim dr As New OleDbDataAdapter(sql, conn)
Dim ds As New DataSet()
dr.Fill(ds, "table1")
dt1 = ds.Tables("table1")
If dt1.Rows.Count > 0 Then
Try
GridView1.DataSource = dt1
GridView1.DataBind()
Dim i As Integer
For i = 0 To GridView1.Rows.Count - 1
Dim txtPONum As String = (GridView1.Rows(i).Cells(1).Text).Trim
If txtPONum.Replace(" ", "").Trim = "" Then
GridView1.Rows(i).Cells(1).Text = GridView1.Rows(i - 1).Cells(1).Text
End If
Next
Response.Write("<script>alert('讀取數據成功！');</script>")
Catch ex As Exception
End Try
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/171595.html
標籤：ASP.NET
上一篇：WPF MVVM 彈框之等待框