Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
.NET Sharing Data with VFP6 Free Tables
Message
De
04/07/2007 03:17:40
 
 
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
01237590
Message ID:
01237696
Vues:
37
Hello Evelyn,

You can simply use a OleDbCommand / -Connection to get data from VFP tables and write it back into them. It's quite easy and the speed is also reasonable.

Example for using VFP data inside .NET, opening the whole table:
OleDbConnection conn = new OleDbConnection(@"Data Source=D:\vfpdev\;Collating Sequence=MACHINE;Provider=VFPOLEDB.1");
OleDbCommand cmd = new OleDbCommand("USE vfptable");
OleDbDataAdapter da = new OleDbDataAdapter(cmd.CommandText, conn);
DataSet ds = new DataSet();
da.Fill(ds);
da.Dispose();
cmd.Dispose();
conn.Dispose();
In this example the DataSet (ds) will contain all rows from the VFP table similar to the VFP's USE and BROWSE commands. Though the USE command opens the VFP table it can still be opened EXCLUSIVE from VFP, it doesn't lock the table.

>Hi! I love this forum and I missed plugging in for quite some time.
>
>I need to rewrite an existing VFP application using .net (either C# or VB). This application shares table files with another VFP 6 application, which is a third-party application (ABRAWin). ABRAWin does not use a database container and so far my application has been accessing the table files as free tables, too. Both applications use VFP's native database engine only. Question is would I be able to convert my app to .net and still share the table files with ABRAWin?
>
>I am not familiar with .net. Any good advice will be appreciated.
>
>Evelyn
robert.oh.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform