none
resultset in ado.net RRS feed

  • Question

  • In my application the user can select a state and when he hits search the user should see data only pertaining to tht state. when i hit search i even see data relating to other states which i dont want. then i execute the same procedure in query analyzer and it is returning correct result set. then if i come back to app the hit search it shows correct information.

     

    weird thing that is happening is: only after i execute the stored proc in analyzer the app is responding correctly. is it something to do with sql cache or .net cache.

     

    All the parameters are getting passed correctly to the stored proc and i even used sql profiler to see wht query is being executed.

     

    Thanks...

    Friday, August 3, 2007 8:04 PM