Mike,
Last month i upgraded from IG2010-V1 to IG2011-V2. After this upgradation i faced some issues in the grid.
Normally in my framework, i created the grid with tablenames like "TableTest0" (first band), "Tabletest1" (second band). If I need any formula for the columns i would apply it on grid generation. In runtime i fetched values from database and bind it to my grid. While binding new datasource i gave different table name. This is working fine upto IG 2010 version 1. But in IG 2011 v2 i got an error (calc manager error) as below. This error came only if i used the formula in the grid.
"at Infragistics.Win.UltraWinGrid.RefSummaryValueCollection.RefSummaryValueCollectionEnumerator.MoveNext() at Infragistics.Win.CalcEngine.RangeCalcInfo.EvaluateNextRow() at Infragistics.Win.CalcEngine.UltraCalcEngine.Evaluate(Int64 ticks) at Infragistics.Win.CalcEngine.UltraCalcEngine.Recalc(Int64 ticks, Boolean isStartOfRecalcOperation) at Infragistics.Win.UltraWinCalcManager.UltraCalcManager.ReCalcInternal(Int64 ticks) at Infragistics.Win.UltraWinCalcManager.UltraCalcManager.ReCalc(Int64 millis)"
I gone through infragistics forum and found the below link
http://forums.infragistics.com/forums/p/52238/272700.aspx#272700
From the link i found that if we changed the tablename of grid's datasource the error will come. So as per the instruction given in the link, i gave the same table name for datasource while generating and as well as in runtime. After that my problem solved globally.
But in one of my screen, i got this same issue (refer attachment-1 & attachment-2) even after having same tablename. In that screen i am using 7 grids and in that 7 grids i am using formula for 4 grids. I checked the table name for this all grids while creation and in runtime. We didn't change the table name at any point. I removed the formulas one by one in every grid and found that it come from one grid which having no rows.
Is there any other methods to solve this problem? Whether anything i missed to check or change?
Guide me to solve this problem.
Hi,
I'm having trouble understanding the new issue. The discussion in the link you posted here had a problem because the name of the table defined in the grid at design-time was not matching up to the table name in the data source the grid was bound to at run-time.
So there was no case where the table name or band name was changed, they just never matched up.
In any case, if you are getting a similar exception in a new case - where they are no rows, then we would need to see a sample project demonstrating this new issue. We need to be able to see the issue in order to debug it - and since there's no information here about what formulas you are using and what you are applying them to, there's no way I can try to duplicate this exception.
Can you post a small sample project?
I herewith attached a sample project for my problem.
In this application I have a grid with 17 columns. I load this grid structure from an xml (measuremen.xml).
I am setting the formula for column "totalnos" as "[nos] * [nosineach]" in the form load.
If you run the application, an exception will fire and the application will close.
(Note : I am using the same grid structure in my original project.)
Guide me to solve this issue.
Finally I found the problem. While creating the datatable my developer wrongly gave a space at the end of tablename as below :
dataTable =
New DataTable("vtcetworkprogressms ")
I found and changed the code as below
dataTable = New DataTable("vtcetworkprogressms")
The empty space triggered the problem.
Thanks for the support.
Aha. I'm glad you got it sorted out. :)