Stored procedure runs fine from SSMS but fails when called from the C# app

Oh I'm not telling you your code doesn't/won't work, but I don't have the time to take it apart and figure out what's going wrong.

This is a little cleaner and should function as you've described. I've used it before on some other projects.