I'm creating a simple app in Winforms/C#, for a friend who just has a standalone PC.

I don't want to mess with SQL Server or even MSDE for a single-user install, because it will never be beyond one user. So it seems like using VFP DBF files will be the easiest way to go.

I have two questions:

1) I believe the following code covers the basics for accessing VFP data...correct?

using System.Data.OleDb;

OleDbConnection oConn = null;
DataSet oDS = null;

oConn = new OleDbConnection("Provider=vfpoledb.1;" +
@"Data Source=c:\\mylocation ;" +
"Exclusive=false;Nulls=false");

oConn.Open();
string lcSQL = "select * from testfile";
OleDbDataAdapter oAdapter = new OleDbDataAdapter(lcSQL, oConn);


2) If I go this route, are there any additional DLL files that I need to install on my friend's machine [in addition to the .NET framework and my Winforms app?] This is the part that confuses me...I know there's a new OLE DB Provider for VFP8, but I didn't know if I only needed that on my development machine or if that was also required on the runtime machine.

Thanks in advance,
Kevin


oDS = new DataSet();

oAdapter.Fill( oDS,"test");
this.dataGrid1.DataSource = oDS.Tables[0];