string connectionString = "PROVIDER=VFPOLEDB.1;" + "DATA SOURCE=" + 
strDataLocation + ";UID='';PWD=''";

// name of your Stored Procedure in VFP
string commandText = "SP_MYPROC";

OleDbCommand oCommand = new OleDbCommand();
OleDbConnection OleDbConn2Vfp = new OleDbConnection
(connectionString);

OleDbConn2Vfp.Open();
oCommand.Connection = OleDbConn2Vfp;
oCommand.CommandText = commandText;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue( "@ParamName", cParamValue );

try 
{
  strReturnXml = (string) oCommand.ExecuteScalar();
}
  catch (Exception e)
{
  strErrorMessage = "Failed to execute Stored Procedure: " +   e.Message;
}
finally 
{
   OleDbConn2Vfp.Close();
}