By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,703 Members | 1,400 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,703 IT Pros & Developers. It's quick & easy.

CSV-Datei einlesen

P: n/a
Hallo zusammen,

ich suche eine Möglichkeit eine CSV Datei in einem DataGrid anzuzeigen.



Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
English please

Something to do about a CSV date in a datagrid I think
Nov 21 '05 #2

P: n/a

See this old sample of me, be aware of the csv delimiter I don't know if it
is in Germany/Swiss/Italy/Austria/Belgia/Liechtenstein a semicolon or a
comma. Next time please in English, that is the used language in this
newsgroup, although many are not native English speakers.
Private Sub Form1_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
Dim file As String = "Test2.txt"
Dim path As String = "C:\Test1\"
Dim ds As New DataSet
Dim f As System.IO.File
If f.Exists(path & file) Then
Dim ConStr As String = _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
path & ";Extended Properties=""Text;HDR=No;FMT=Delimited\"""
Dim conn As New OleDb.OleDbConnection(ConStr)
Dim da As New OleDb.OleDbDataAdapter("Select * from " & _
file, conn)
da.Fill(ds, "TextFile")
End If
Catch ex As Exception
End Try
DataGrid1.DataSource = ds.Tables(0)
End Sub
I hope this helps a little bit?

Nov 21 '05 #3

P: n/a
"Matthias von Deetzen" <ma******************>
ich suche eine Möglichkeit eine CSV Datei in einem DataGrid anzuzeigen.

Notice that this is an English language group. You'll find connection
strings for connecting to CSV files at

M S Herfried K. Wagner
M V P <URL:>
V B <URL:>

Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.