How to pass the parameter using Ado.net to SQL & Oracle

1)
To pass parameter in SQL query OR stored procedure
use- NAME = @MYNAME
here- @MYNAME is parameter

2)
To pass parameter in Oracle query OR stored procedure
use: NAME = :MYNAME
here- :MYNAME is parameter