scott mcnitt (11/9/2007)
For those of us coming from the old ADO world, do the parameter names have to exactly match the sproc parm names? In ADO the ordinal position mattered not the name.
The order does not matter in .NET but the names do. So, if the sproc has a paramter @test-2, then from .NET it is required to give @test-2 as parameter name. Not doing so will result in runtime error.