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

¤ 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)

SQL Syntax ?
ODBC - Error
Oracle Table Adapter Querry Wizard Error
UpdateBatchSize and SqlTransaction
Find Equivalent