Original
General Structure SP in FoxPro database:

*VFP Stored Procedure:
PROCEDURE DoSomething
  LPARAMETERS x
  SELECT * FROM myTable WHERE something = x INTO CURSOR myCursor
  RETURN SETRESULTSET("myCursor")
ENDPROC

and in VB.NET something like:
...
With oCommand
  .CommandType = CommandType.StoredProcedure
  .CommandText = "DoSomething"
  '.Parameters.Add .....
End With
da.SelectCommand = oCommand
da.Fill(oDataSet)