2012年2月2日 星期四

csv 中文讀不出來

參考引用
--
依來源,我稍調整讀取的編碼方式(這取決匯出的編碼原則)
  1. Public Function CSVFileToDT(ByVal FullFileName As String) As DataTable
  2. Dim newDataTable As New DataTable
  3. Dim CloumnNameFlag As Boolean = True
  4. Using sr As IO.StreamReader = New IO.StreamReader(FullFileName,System.Text.Encoding.Default)
  5. Dim Tempstr As String = Nothing
  6. Tempstr = sr.ReadLine
  7. While Tempstr IsNot Nothing
  8. If CloumnNameFlag = True Then
  9. For i As Integer = 0 To Tempstr.Split(",").Length - 1
  10. newDataTable.Columns.Add(Tempstr.Split(",")(i))
  11. Next
  12. CloumnNameFlag = False
  13. Else
  14. Dim row As DataRow = newDataTable.NewRow
  15. For i As Integer = 0 To Tempstr.Split(",").Length - 1
  16. row.Item(i) = Tempstr.Split(",")(i)
  17. Next
  18. newDataTable.Rows.Add(row)
  19. End If
  20. Tempstr = sr.ReadLine
  21. End While
  22. sr.Close()
  23. End Using
  24. Return newDataTable 
End Function

---
以上這組能解決使用 OleDB 讀取 csv 後一些碼不見的問題!
PS:被這問題困了2-3小時

沒有留言:

張貼留言