Read a DBASE III file in VB.NET

[Maurice Mertens]

Hi,

how can I open and read a DbaseIII file in .NET?
--
Met vriendelijke groet / With regards / Saludos,
Moviat Automatisering
Maurice Mertens
mauricem@moviat_KillSpamWordForEMail.nl

tel: [phone]
fax: [phone]

[Marinus Holkema]

This might wor

In Server Explorer
New Add Connectio
Select as Provider Microsoft OLEDB provider for ODBC Driver
Select dBASE files as DataSource Nam
Enter as Initial the directory which holds your table(s). Not the tables itsel
Test Connectio

Now you can the table to your form
I'll write a next message with the code exampl

Marinus Holkem

[Paul Clement]

On Wed, 19 May 2004 00:34:05 -0700, Maurice Mertens <mauricem@moviat_KillSpamWordForEMail.nl> wrote:

¤ Hi,
¤
¤ how can I open and read a DbaseIII file in .NET?

You can use Jet OLEDB and the ISAM driver as in ADO:

Private Sub ConnectTodBaseDataReader()

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\dBase;Extended Properties=dBase III"
Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(ConnectionString )
dBaseConnection.Open()

Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT * FROM MyDBase",
dBaseConnection)
Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
dBaseCommand.ExecuteReader(CommandBehavior.Sequent ialAccess)

While dBaseDataReader.Read
Console.WriteLine(dBaseDataReader("Column1").ToStr ing)
Console.WriteLine(dBaseDataReader("Column2").ToStr ing)
Console.WriteLine(dBaseDataReader("Column3").ToStr ing)
End While

dBaseConnection.Close()

End Sub
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Maurice Mertens]

Thanks Paul, I will try this code !!!

--
Met vriendelijke groet / With regards / Saludos,
Moviat Automatisering
Maurice Mertens
mauricem@moviat_KillSpamWordForEMail.nl

tel: [phone]
fax: [phone]

[Marinus Holkema]

This might wor

In Server Explorer
New Add Connectio
Select as Provider Microsoft OLEDB provider for ODBC Driver
Select dBASE files as DataSource Nam
Enter as Initial the directory which holds your table(s). Not the tables itsel
Test Connectio

Now you can the table to your form
I'll write a next message with the code exampl

Marinus Holkem

[Paul Clement]

On Wed, 19 May 2004 00:34:05 -0700, Maurice Mertens <mauricem@moviat_KillSpamWordForEMail.nl> wrote:

¤ Hi,
¤
¤ how can I open and read a DbaseIII file in .NET?

You can use Jet OLEDB and the ISAM driver as in ADO:

Private Sub ConnectTodBaseDataReader()

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\dBase;Extended Properties=dBase III"
Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(ConnectionString )
dBaseConnection.Open()

Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT * FROM MyDBase",
dBaseConnection)
Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
dBaseCommand.ExecuteReader(CommandBehavior.Sequent ialAccess)

While dBaseDataReader.Read
Console.WriteLine(dBaseDataReader("Column1").ToStr ing)
Console.WriteLine(dBaseDataReader("Column2").ToStr ing)
Console.WriteLine(dBaseDataReader("Column3").ToStr ing)
End While

dBaseConnection.Close()

End Sub
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Maurice Mertens]

Thanks Paul, I will try this code !!!

--
Met vriendelijke groet / With regards / Saludos,
Moviat Automatisering
Maurice Mertens
mauricem@moviat_KillSpamWordForEMail.nl

tel: [phone]
fax: [phone]