I appreciate your time in helping with this problem.
source code can be found at http://www.ryanupton.com/WebSiteTest2Userclick.zip
DESCRIPTION IN BRIEF
We have set up a Web-based form using 1 drop down selector(Infragistics seachcombo), and a submit button (Infragistics WebImageButton), a WebPanel (Infragistics WebPanel) , a refresh panel (Infragistics WebAsyncRefreshPanel)and excel exporter (Infragistics UltraWebGridExcelExporter)
that uses the values the user selects in the above mentioned controls to seed a query.
The query is then run against the database and the results displayed in the Intragistics Ultragrid
What we would expect is that upon selecting different parameters and hitting submit the display would update with the new result set. What we do see is results seem to persist in the Ultragrid control until the user starts to interact with the control via the slider or hit the submit button a second time.
We think that one possible cause is that the control is somehow caching the prev resultset in any case it does not respond in timely fashion.
The selector individually populates a class which is stored in the session using the session command
The User then presses the submit button. The submit button grabs the global session data and then populates the Infragistics Ultragrid control using mysql data and displays the data in a heiracheral form. The Ultragrid is set to XML and Load on demand XML.
This program works perfectly with one user on the server.
The size of the data and per the four brand tables is parent 1019 rows, child 5161, gndchild 48140 rows and ggchild 185937 rows
The existing setup is 4 computers,
Server 1 DATA : One Fedora Linux server Linux version 2.6.20-1.2952.fc6 runing MYSQL Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0 this stores the data Intel(R) Pentium(R) 4 CPU 3.40GHz
SERVER 2 HTML : One Windows XP Professional Version 2002 SP2 P4 3G 2G RAM IIS Internet Information Services Microsoft Corporation Version: 5.1 Running VS2005 Infragistics NetAdvantage for .NET 2007 Vol. 2 CLR 2.0
CLIENT 1 : One Windows XP Professional Version 2002 SP2 P4 2.8G 1G RAM IE VER 7.0.5730.11
CLIENT 2 : One Windows XP Professional Version 2002 SP2 Core Duo 2.8G 2G RAM Using Microsoft Internet Explorer Version 6.0.2900.2180.xpsp_sp2_gdr
DESCRIPTION OF PROBLEM
When two or more different users are logged in as clients and one user selects data using the selectors then the follow problem occurs Randomly every 5 or so selections.
As Seen on Client 2
1) User1 one selects filter using the Infragistics searchcombo (pull down menu) select, "Current Area", then presses submit. While a second user does the same. The Control seams to start waits then expires without running any code randomly on one user.
As seen on Client 1
Step 1) The user selects an area, presses submit and table populates Step 2) The user selects an area, presses submit Step 3) The async rotater spins then disappears and no new data appears ! The debug labels show new area selector code runs but that the submit code doesn't Step 4) If the user then selects another area the tables displays the selected data Step 5) Or iF The user presses submit again the data is displayed Step 6) Or if you export the code using excel export the table contains the new data.
Its as if the repaint or refresh of the Ultagridtable has not happened
I have debug flags down the bottom to figure out what is happening. if you export the code using excel export the table contains the new data.
HYPOTHESIS OF PROBLEM
1) Refresh / repaint of control broken
2) Program is sharing global variables with other programs
3) Program is sharing XML files
Where does the program store XML info? where is it stored is it on disk?
4) The click action of the Infragistics controls is being stolen
I still don't know if the problem is with Infragists, my code or something else.
It's important to have two users logged in at the same time so we need this problem fixed.