>I know this is probably a rookie question, but how do I get a value from VFP free table from c#? I have VFP7 installed, so I should have access to VFPOLEDB.
>What is the best way to just send a select statement with 1 param and read just one result out? Query would be like:
>
>mFilter = "Some String"
>
>select myValue;
>from myTable;
>where myFilter = ?mFilter
>
>Thanks


Check out this article, its in VB.NET but you can translate the syntax to C#. Just change the connection string and use the ADO style of the parameterized query, not the VFP style:

select myValue
from myTable
where myFilter = ?

and populate the parameter objects like the article describes.


-Dave