fill a text file data to datagridview

  • Thread starter Thread starter great stuff
  • Start date Start date
G

great stuff

I am trying to import a textfile into datagridview using
oledbconnection.

Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter

MyConnection = New System.Data.OleDb.OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & connectionString &
";Extended Properties='text;HDR=No;FMT=TabDelimited'")

MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [" &
fileName & "]", MyConnection)

DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet, "TextFile")
DataGridView1.DataSource = DtSet

but the values get formatted in this case
if i have the text file as below:
01
02
03
04

i get as below:
1
2
3
4

Without formatting the text file (i .e., setting quotes to each number
in the text file for eg., "01") how can this be done??
Is there any other way to do this ??

Thanks for any suggestion...
 
Back
Top