CSV-Datei einlesen

[Matthias von Deetzen]

Hallo zusammen,

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

Mfg

Matthias

[Crouchie1998]

English please

Something to do about a CSV date in a datagrid I think

[Cor Ligthert]

Matthias,

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(ByVa l sender As Object, _
ByVal e As System.EventArg s) Handles MyBase.Load
Dim file As String = "Test2.txt"
Dim path As String = "C:\Test1\"
Dim ds As New DataSet
Try
Dim f As System.IO.File
If f.Exists(path & file) Then
Dim ConStr As String = _
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" & _
path & ";Extended Properties=""Te xt;HDR=No;FMT=D elimited\"""
Dim conn As New OleDb.OleDbConn ection(ConStr)
Dim da As New OleDb.OleDbData Adapter("Select * from " & _
file, conn)
da.Fill(ds, "TextFile")
End If
Catch ex As Exception
MessageBox.Show (ex.ToString)
End Try
DataGrid1.DataS ource = ds.Tables(0)
End Sub
///
I hope this helps a little bit?

Cor>

[Herfried K. Wagner [MVP]]

"Matthias von Deetzen" <ma************ ******@consulti ng-company.net>
schrieb:

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
<URL:http://www.connections trings.com/>.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>