inaccuracy between a DB table and its boud Asp.net Grid View

Hello,
I have one Sql Server 2005, bound to an Asp.net web application.
There is something weird happening!!

There is one page using a grid view, and in it there is one column "Stock"  that is displaying wrong values for some records.
Those values are wrong because they are different from the DB table.
I would say like 20% of the records in this GV are having this problem.

And, there is one text box and a button on the page, where the user can enter a product code to filter the relative record in the GV.
When all the records are displayed in the GV with no filter value set, suppose that we check in the whole list the records ABC, and we found a stock 0 instead of 15, that's not good because in the DB table it's 15.
But if we filter the ABC we foung 15 !!
Can someone help please!
Nyana22Asked:
Who is Participating?
 
spprivateCommented:
I guess there is a problem in your select query.This causes the weird result coming up
0
 
GiftsonDJohnCommented:
Please post the code.
0
 
Nyana22Author Commented:
i don't thing there is a problem in the select, because i tested it.

and now i created a new page, where the data source is the same stored procedure and it worked fine!
and by the way on my pc (development) there were no problem, only it happened on the server.!!
thanks
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Anthony PerkinsCommented:
>>on my pc (development) there were no problem, only it happened on the server<<
Ah, yes.  That is a very common problem. It is called the "But it works on my workstation" syndrome.
0
 
spprivateCommented:
Please post the code
0
 
spprivateCommented:
Can you explain what was the issue
0
 
Anthony PerkinsCommented:
And more importantly why I was awarded points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.