Yes,
ADO.NET --> uses ActiveX Data Objects for .NET
OLE DB --> uses COM interfaces (in my opinion the easiest and the fastest to work with)
While using ADO.net connection in the execute sqltask you have mention the parameter as @parameter as the parameter name.
ex:select * from table1 where column1 = @column1
While using Oledb connection you have set the parameter index start with 0
Ex:Select * from table1 where column1=?.so it will the value from the index as "0" as a parameter name.