如何打开.db悖论文件 [英] How to open the .db paradox file
本文介绍了如何打开.db悖论文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想查看test.db文件,我搜索它的编辑器但没有得到任何文件 因此,请像SQL Server一样在编辑器中查看它.
i want to view the test.db file, i search for it's editor but didn't get any one So please help to see the it in editor as like sql server.
我找到了一些sqlite编辑器,但在大多数论坛上它都不是sqlite文件,它说这是一个矛盾的.db文件.
i found some sqlite editor but it's not an sqlite file on most forum it say that it is an paradox .db file.
那我怎么打开它
谢谢
推荐答案
要访问.NET中的Paradox表,可以使用ODBC.这是一个小示例(在C#中):
To access Paradox tables in .NET you can use ODBC. Here's a small example (in C#):
private static void RunMinimumParadoxTest()
{
const string ConnectionStringFormat =
"Driver={{Microsoft Paradox Driver (*.db )}};Uid={0};UserCommitSync=Yes;Threads=3;SafeTransactions=0;" +
"ParadoxUserName={0};ParadoxNetStyle=4.x;ParadoxNetPath={1};PageTimeout=5;MaxScanRows=8;" +
"MaxBufferSize=65535;DriverID=538;Fil=Paradox 7.X;DefaultDir={2};Dbq={2};CollatingSequence={3}";
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.Odbc");
using (DbConnection connection = factory.CreateConnection())
{
string userName = "Tor";
string paradoxNetPath = @"C:\BdeNet";
string databasePath = @"C:\LangloMainSrv\LData\Ordre\LordWin\Database2011";
string collatingSequence = "Norwegian-Danish";
connection.ConnectionString =
String.Format(ConnectionStringFormat, userName, paradoxNetPath, databasePath, collatingSequence);
connection.Open();
using (DbCommand command = connection.CreateCommand())
{
command.CommandText = "select Count(*) from [OrdreDet] where [Ordrenr] = 81699002";
object itemCount = command.ExecuteScalar();
Console.WriteLine("Order items: {0}", itemCount);
Console.ReadKey();
}
}
}
另请参见以下链接以了解更多详细信息: http://msdn.microsoft.com/zh-CN/library/ms710922(VS.85).aspx .
Also see the following link for more details: http://msdn.microsoft.com/en-us/library/ms710922(VS.85).aspx.
这篇关于如何打开.db悖论文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文