C# (vb) read Paradox DB code

 C# 连接Paradox DB

win7 x64 C# 讀取 delphi Paradox db

Paradox 4 database connect and edit inside c#

##

C# Application to import paradox data to SQL Server

Paradox to SQL Server

----------------

C# code:

var strPath = @"D:\Test\4#新程序全兼容\4#新程序全兼容\Data";

string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + ";Extended Properties=Paradox 5.x;";

string mySelectQuery = "select * from TD2002002;";

OleDbConnection myConnection = new OleDbConnection(myConnectionString);

myConnection.Open();

OleDbDataAdapter da = new OleDbDataAdapter(mySelectQuery, myConnection);

DataSet ds = new DataSet();

da.Fill(ds);

----------

VB code:

Dim strPath As Object = "D:\Test\4#新程序全兼容\4#新程序全兼容\Data"

Dim myConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strPath + ";Extended Properties=Paradox 5.x;"

Dim mySelectQuery As String = "select * from TD2002002;"

Dim myConnection As New OleDbConnection(myConnectionString)

myConnection.Open()

Dim da As New OleDbDataAdapter(mySelectQuery, myConnection)

Dim ds As New DataSet()

da.Fill(ds)