Experiment and molecular dynamics simulation were carried out to study the tunable stability of oilcontaining SDS-stabilized Nitrogen-in-water foam. The experimental results show that the foam stability could be tuned by the concentrations of SDS and modified SiO2 nanoparticles. In the foam systems with a low SDS concentration (0.2 wt.%), the foams show poor stability and the foam stability was almost not affected by the addition of modified SiO2 nanoparticles. The foam stability was greatly improved at moderate SDS concentration (0.5 wt.%), it enhanced first and then weakened with the increase of modified SiO2 concentration, and the half-life time achieved a maximum value of 1292 s at 0.05 wt.% modified SiO2. However, at high SDS concentration (0.8 wt.%), the foam stability was pretty good except for when the modified SiO2 concentration is too high (>0.2 wt.%). The microscopic mechanism was obtained by investigating the structural and dynamic properties of the foam film. The simulation work showed consistent results of foam stability with the experimental results. Moreover, it also revealed that the concentration and configuration of SDS will affect its interaction with SiO2 and oil molecule, which is critical to foam stability.