DataSet from/to CSV

[Ondrej Sevecek]

Hello,
is there any method to load DataSet from CSV file and on the other side to
place them to the file or some string?

Ondra.

 

[William Ryan]

You can walk through the rows and for each column, write the current rows
value and a comma except for the last row use a Carriage Return. You can do
the same reading it in. Two loops should do it for you in either direction.

However, if you can, examine DataSet.WriteXML and DataSet.ReadXML, it's much
cleaner and easier to use.

HTH,

Bill

 

[Paul Clement]

¤ Hello,
¤ is there any method to load DataSet from CSV file and on the other side to
¤ place them to the file or some string?
¤

You can pull data in from a CSV file but you can't update the CSV file directly:

Private Sub ConnectToTextII_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Handles ConnectToTextII.Click

Dim ConnectionString As String
Dim SQLString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\TextFiles;Extended Properties=Text;"

SQLString = "Select * from TextFile.csv"

Dim ConnectionText As New OleDb.OleDbConnection()
ConnectionText = New OleDb.OleDbConnection()

ConnectionText.ConnectionString = ConnectionString

ConnectionText.Open()

Dim AdapterText As New OleDb.OleDbDataAdapter(SQLString, ConnectionText)

Dim DataSetText As New DataSet("TextFiles")
AdapterText.Fill(DataSetText, "TextFile")

DataGrid1.SetDataBinding(DataSetText, "TextFile")

ConnectionText.Close()

End Sub


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)