>>>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(); >>>} >>>>>>