I would assume that you aren’t passing the parameters to the procedure correctly. Run SQL Profiler against the SQL Server. This will tell you what the exact command being run against the SQL Server is. If when you run that you get the correct data back then the SQL Part is working correctly, and you can focus on the .NET code not working correctly.
What’s the exact error that you are getting?