Hallo zusammen,

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

Mfg

Matthias

English please

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

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(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
        Try
            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
            MessageBox.Show(ex.ToString)
     End Try
   DataGrid1.DataSource = ds.Tables(0)
End Sub
///
I hope this helps a little bit?

Cor>

Notice that this is an English language group.  You'll find connection
strings for connecting to CSV files at
<URL:http://www.connectionstrings.com/>.

Datagrid and arraylist
Screen Mate Creation
String.Split versus Strings.Split
SQL Question
typeof
Process.Start("Winword.exe") problem
How do you put a hyperlinked text on a blank form
Windowless application, pls help.
XML Schema
SELECT Statement