• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Select Statement Stored Procedures in MS sql server not returning anything...

 
Justin Fox
Ranch Hand
Posts: 802
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok,

here is my 'driver class' :



the SqlComand.Fill() method:



and finally, here is the stored procedure....



ok the problem is, when i take the 'where itemnumber = @Itemnumber' out of the
sproc, the resultset gets filled fine and I see it print, but if i uncomment/put the
'where itemnumber = @itemnumber' then the resultset doesn't get filled for some
reason...

Am I missing something?

Thanks,

Justin Fox>
 
ujjwal soni
Ranch Hand
Posts: 403
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Are you able to call stored procedure directly without using the application ?

 
Justin Fox
Ranch Hand
Posts: 802
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't really understand what you mean. I can call the stored procedure from the MS Sql management studio in a query,
but I need to call it from the app.

And like I said before, if i take out the 'where itemnumber = @itemnumber' then the resultset gets filled if I leave it in there
it doesn't get filled.

its weird too because the parameter is always there, but when i use it, it doesn't work.

thanks,

Justin
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic