Hi Dmitry,

I got it to work now. Thank you.

>>Hi all,
>>
>>How do I access my VFP database stored procedures from .Net? C# preferred.
>>
>>Thanks.
>
>
>Here is a sample code that I use to call VFP Stored Procedure:
>
>

>string connectionString = "PROVIDER=VFPOLEDB.1;" + "DATA SOURCE=" + strDataLocation + ";UID='';PWD=''";
>string commandText = "My_StoredProc";
>
>OleDbCommand oCommand = new OleDbCommand();
>OleDbConnection OleDbConn2Vfp = new OleDbConnection(connectionString);
>OleDbConn2Vfp.Open();
>oCommand.Connection = OleDbConn2Vfp;
>oCommand.CommandText = commandText;
>oCommand.CommandType = CommandType.StoredProcedure;
>
>// Pass parameters to SP
>oCommand.Parameters.Add( "@Param1Name", strParam1Value );
>oCommand.Parameters.Add( "@Param2Name", strParam2Value );
>oCommand.Parameters.Add( "@Param3Name", strParam3Value );
>
>try
>{
>strReturnXml = (string) oCommand.ExecuteScalar();
>}
>catch
>{
>strErrorMessage = "Failed to execute Stored Procedure";
>}
>finally
>{
>OleDbConn2Vfp.Close();
>}
>

>
>Please let me know if you have any questions about my code.
>
>HTH