open text file ado.net

[veer]

Hi
i want to open a text file from vb.net coding but i am not getting any idea
actually i used the following code
conect = ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=d:\as.tx t;Extended Properties=text ;HDR=Yes;FMT=De limited")

scon.Connection String = conect
scon.Open()
cmd.CommandText = "select * from as.txt"
cmd.Connection = scon
dtAdaptor = New System.Data.Ole Db.OleDbDataAda pter(cmd)
dtAdaptor.Fill( ds, "as.txt")
but it shows the error
invalid installed ISAM

[r035198x]

Why not use a Textreader

[CODE=vbnet]Dim tr As System.IO.TextR eader
tr = New IO.StreamReader ("filename.txt" )
Console.WriteLi ne(tr.ReadToEnd ())[/CODE]

[IanWright]

Hi
i want to open a text file from vb.net coding but i am not getting any idea
actually i used the following code
conect = ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=d:\as.tx t;Extended Properties=text ;HDR=Yes;FMT=De limited")

scon.Connection String = conect
scon.Open()
cmd.CommandText = "select * from as.txt"
cmd.Connection = scon
dtAdaptor = New System.Data.Ole Db.OleDbDataAda pter(cmd)
dtAdaptor.Fill( ds, "as.txt")
but it shows the error
invalid installed ISAM

Are you aware that you need to specify the delimeter somewhere? See [HTML]http://www.connections trings.com/?carrier=textfi le[/HTML]

Secondly I believe you need to enclose your filename with square brackets.
[CODE=c#]
cmd.CommandText = "SELECT * FROM [as.txt]"[/CODE]


Finally I believe you need to set the select of the adapter

[CODE=c#]dtAdaptor.Selec tCommand = cmd;[/CODE]