G
Guest
Hi
How can I use the streamReader to read a CSV file and possibly fill a dataset
Thanks
How can I use the streamReader to read a CSV file and possibly fill a dataset
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Tucker [MVP]
Hi,
Use a oledbconnection to fill the dataset. look at the text
connection string here.
http://www.connectionstrings.com/
Ken
Use a oledbconnection to fill the dataset. look at the text
connection string here.
http://www.connectionstrings.com/
Ken
G
Guest
Hi
I tried this but it us removing the leading zeros. If I have 012 in the text file it returns 12. Is there another way to parse a csv file. I need to send this data to the database.
I tried this but it us removing the leading zeros. If I have 012 in the text file it returns 12. Is there another way to parse a csv file. I need to send this data to the database.
C
Cor
Hi Chris,
I made a short time ago a complete sample for that, remember, the delimiter
needs to be confirm your globalization style.
I hope this helps?
Cor
\\\
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 made a short time ago a complete sample for that, remember, the delimiter
needs to be confirm your globalization style.
I hope this helps?
Cor
\\\
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
///