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.