Paradox Database

[SK]

Hello,

I've a paradox database file named master.db.
What is the best way to access this using asp.net (VB)?

I want to put the data in a gridview.

- Thanks

 

[Paul Clement]

¤ Hello,
¤
¤ I've a paradox database file named master.db.
¤ What is the best way to access this using asp.net (VB)?
¤
¤ I want to put the data in a gridview.

I don't know which version of Paradox you are using but if it isn't the latest version then you can
probably use Jet OLEDB and the Paradox ISAM driver:

Dim ConnectionString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\ParadoxFolder;Extended Properties=Paradox 5.x;"
Dim ParadoxConn As New System.Data.OleDb.OleDbConnection(ConnectionString)
ParadoxConn.Open()

Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from Master", ParadoxConn)

Dim ds As New DataSet

da.Fill(ds, "Master")


Paul
~~~~
Microsoft MVP (Visual Basic)