Question is :What if I want to call the stored procedure with just @a and @f,
As long as other are optional SP will be executed without any errors.
In this case do I need to Add other parameters also (b,c,d,e) anyway?
No, you don’t.
If I add just 2 parameters how stored procedure knows the order?
Order is not important here. The parameter name is. It has to match the one from SP declaration.
6
solved Omit named parameters from OleDbCommand [closed]