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)