Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [" + Path.GetFileName(FileName) + "]", cn)
  2.  
  3. Private Sub GetData(ByRef dt As DataTable, FilePath As String, Optional ByVal Header As Boolean = True)
  4. Dim Fields() As String
  5. Dim Start As Integer = CInt(Header) * -1
  6. If Not File.Exists(FilePath) Then
  7. Return
  8. End If
  9. dt.Clear()
  10. Dim Lines() As String = File.ReadAllLines(FilePath)
  11. If CBool(Start) AndAlso dt.Columns.Count = 0 Then
  12. Lines(0) = Lines(0).Replace(Chr(34), "")
  13. For Each h As String In Lines(0).Split(",")
  14. dt.Columns.Add(h)
  15. Next
  16. End If
  17. For I = Start To Lines.Count - 1
  18. Fields = Lines(I).Split(",")
  19. dt.Rows.Add(Fields)
  20. Next
  21. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement