Apologies if I'm not clear about anything, I'm new to Infragistics
What is the Issue?
When reloading an UltraGrid with new data, Grid.Rows is not being populated correctly from Grid.DataSource and only the column headers are displayed until the grid is reloaded again. Note that this only occurs on a Microsoft Surface tablet and cannot be reproduced on a more traditional Windows 10 machine
Below is the LoadGrid method called(note that nominalCodeTable and costCentreTable are both DataTables, I have tried converting the to DataViews too):
private void LoadGrid(bool dataload) { if (dataload) { LoadNominalTable(); LoadCostCentreTable(); this.splitContainer1.Panel2.Hide(); } //Sets the Grid data source //Setting the Datasource to null is intentional. By nulling the datasource before attaching a new one //the columns are shown in the right order when the tab is changed. Databind and Refresh does not work. viewGridBase.Grid.DataSource = null; if (budgetControl.SelectedTab != null) { if (budgetControl.SelectedTab.Index == 0) { if (nominalCodeTable != null) { viewGridBase.Grid.DataSource = nominalCodeTable; } } else { if (costCentreTable != null) { viewGridBase.Grid.DataSource = costCentreTable; } } } viewGridBase.Grid.DataBind(); List<string> totalSummaryColumns = new List<string>(); if (viewGridBase.Grid.DataSource != null) { foreach (DataColumn column in ((DataTable) viewGridBase.Grid.DataSource).Columns) { if (column.ColumnName.Equals("TotalBudgetedValue") && !totalSummaryColumns.Contains("TotalBudgetedValue")) totalSummaryColumns.Add("TotalBudgetedValue"); if (column.ColumnName.Equals("Total") && !totalSummaryColumns.Contains("Total")) totalSummaryColumns.Add("Total"); if (column.ColumnName.Contains("FinancialYear") && !totalSummaryColumns.Contains(column.ColumnName)) totalSummaryColumns.Add(column.ColumnName); } } if (viewGridBase.Grid.Rows.Count > 0) { viewGridBase.Grid.Rows[0].Selected = true; } CreateColumnTotalSummary(totalSummaryColumns); }
At the end of the method the Grid.DataSource.Rows count does not match the Grid.Rows count, I’m assuming this is because the data has not been bound correctly?
What I've Tried
Any ideas what I can try to get this to work? Any help/suggestions are greatly appreciated.
That's really weird. I can't see any reason why the machine you are running on should matter. Are you absolutely certain that it's the grid that is the problem here and it's not just that the DataTable you are assigning actually has no data in it?
If the grid's not updating it's display even after you call Refresh or Rows.Refresh, then that would seem to indicate that the data source itself has no rows. Is it possible you are updating that data source on another thread and so it hasn't populated, yet? As a test, try putting an inbox DataGrid control on there and bind it to the same data source as the grid and see if it shows data.
This is a bit of a stretch but perhaps, at some other point in your application, you specified a DataMember on the grid, and so setting the DataSource to a DataTable is having trouble resolving that DataMember, since DataTables don't have multiple table. You might try changing the DataSource setter and instead use a call to SetDataBinding and pass in null for the DataMember.
Another wild stab in the dark is that perhaps there's an Exception occurring here that is being caught and handled. So if you are running this in Visual Studio with debugging, you might want to set it up to break on all Run-time exceptions so you can see if that's happening.
Mike Saltzman said:That's really weird. I can't see any reason why the machine you are running on should matter.
I agree! But this is the state of the viewGridBase object at the end of running LoadGrid on the Surface:
And on my regular PC:
You can see that viewGridBase.Grid.DataSource.Count = 3 on both machines and when looking into the DataSource, all data is present. But viewGridBase.Grid.Rows only gets populated on the regular PC.
I tried breaking on all exceptions, but nothing was thrown unfortunately.
Not in the simple test application I just made, but then with that level of simplicity, the UltraGrid worked too. To change any grids to DataGridView in our full solution would be weeks of work to get the solution to build
Not sure if it helps, or makes it more confusing, but there is a different instance of an UltraGrid in our project that works as expected on the Surface, but only when using it through a remote desktop. When viewing the grid directly on the surface display it has the same issue as the example shown above. I've ruled out this being anything to do with scaling by replicating the display settings from my PC on the Surface.
Hi Jake,
We are certainly not suggesting that you replace the WinGrid in your application with a DataGridView. The idea is, just as a test, stick a DataGridView on the same form with the grid and bind it to the same data source to see if it shows any data. That will tell us if the problem is truly with the WinGrid or something in your application, the data source, or the BindingManager. My understanding is that the grid shows data initially and only loses it when you change from one data source to another, so clearly the grid is working on that machine. And now you say there's another grid in the application that also works. So whatever is happening here is some complex interaction caused by a series of events or perhaps some combination of property settings. And since it only happens on a single device and only in your full application, that makes it extremely difficult to track down.
The best case scenario would have been if one of the workarounds we suggested work. But since none of them do, we are left with few options. I suppose one think you could try to would to be dispose of the existing grid and create a new one in code. If changing the data source has somehow gotten the grid into a bad state, that should fix it. It's a terrible solution, but it's seems like that might be the best of all the bad options. If we want to continue to pursue finding the cause of the issue, then we would really need a sample demonstrating it so we can debug it. And we may not be able to reproduce it even with a sample, since we may not necessarily have the same device available to us. And even if we do, there's a good chance it won't happen on our machine. Are you seeing this problem on more than one device? Have you tested it on more than one? The only other thing I can think of is... if you want to export some of the grid property settings from your running application to a couple of files, I can take a look at them and see if I noticed anything obviously wrong. It's a long shot and I doubt anything will come of it, but at this point, it might be worth while. What you would have to do is get the grid into the bad state and then run some code to export some data to files and then send me the two XML files:
this.ultraGrid1.DisplayLayout.SaveAsXml(displayLayoutFileName); var gridPresets = PresetSerializer.FromObject(this.ultraGrid1, PresetType.All); gridPresets.SaveAsXml(presetFilename);
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <SOAP-ENV:Body> <a1:UltraGridDisplayLayout id="ref-1" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <BorderStyle>4</BorderStyle> <GroupByBox href="#ref-5"/> <_x0030_ href="#ref-6"/> <MaxColScrollRegions>1</MaxColScrollRegions> <MaxRowScrollRegions>1</MaxRowScrollRegions> <Override href="#ref-7"/> <RowConnectorColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </RowConnectorColor> <RowConnectorStyle>4</RowConnectorStyle> <ViewStyleBand>2</ViewStyleBand> <ScrollStyle>1</ScrollStyle> <Bands href="#ref-8"/> <UseFixedHeaders>true</UseFixedHeaders> <ScrollBounds>0</ScrollBounds> <CaptionVisible>2</CaptionVisible> </a1:UltraGridDisplayLayout> <a1:GroupByBox id="ref-5" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <BorderStyle>4</BorderStyle> <AppearanceHolder href="#ref-9"/> <Hidden>true</Hidden> <BandLabelAppearance href="#ref-10"/> <PromptAppearance href="#ref-11"/> <Style>1</Style> </a1:GroupByBox> <a2:AppearanceHolder id="ref-6" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-12"/> </a2:AppearanceHolder> <a1:UltraGridOverride id="ref-7" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AllowUpdate>1</AllowUpdate> <BorderStyleRow>2</BorderStyleRow> <BorderStyleCell>2</BorderStyleCell> <CellPadding>0</CellPadding> <HeaderClickAction>3</HeaderClickAction> <RowSelectors>1</RowSelectors> <RowSelectorHeaderStyle>4</RowSelectorHeaderStyle> <FilterClearButtonLocation>4</FilterClearButtonLocation> <FilterEvaluationTrigger>1</FilterEvaluationTrigger> <FilterOperatorDefaultValue>11</FilterOperatorDefaultValue> <FilterOperatorLocation>3</FilterOperatorLocation> <FilterRowPrompt id="ref-13">Click here to filter data...</FilterRowPrompt> <FilterUIType>2</FilterUIType> <SpecialRowSeparator>4</SpecialRowSeparator> <HeaderStyle>1</HeaderStyle> <_x0031_ href="#ref-14"/> <_x0032_ href="#ref-15"/> <_x0034_ href="#ref-16"/> <_x0035_ href="#ref-17"/> <_x0038_ href="#ref-18"/> <_x0039_ href="#ref-19"/> <_x0031_3 href="#ref-20"/> <_x0031_6 href="#ref-21"/> <_x0033_0 href="#ref-22"/> <_x0034_3 href="#ref-23"/> <_x0034_5 href="#ref-24"/> </a1:UltraGridOverride> <a1:BandsCollection id="ref-8" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Count>1</Count> <_x0030_ href="#ref-25"/> </a1:BandsCollection> <a2:AppearanceHolder id="ref-9" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-26"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-10" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-27"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-11" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-28"/> </a2:AppearanceHolder> <a2:Appearance id="ref-12" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4294639605</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackGradientAlignment>3</BackGradientAlignment> <BorderColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>17</knownColor> <state>1</state> </BorderColor> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-14" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-29"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-15" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-30"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-16" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-31"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-17" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-32"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-18" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-33"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-19" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-34"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-20" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-35"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-21" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-36"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-22" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-37"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-23" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-38"/> </a2:AppearanceHolder> <a2:AppearanceHolder id="ref-24" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-39"/> </a2:AppearanceHolder> <a1:UltraGridBand id="ref-25" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Key id="ref-40">K2DT</Key> <Override href="#ref-41"/> <Columns href="#ref-42"/> <Summaries href="#ref-43"/> </a1:UltraGridBand> <a2:Appearance id="ref-26" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor> <BackColor2 xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackGradientAlignment>3</BackGradientAlignment> <BackGradientStyle>5</BackGradientStyle> <BorderColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>79</knownColor> <state>1</state> </BorderColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-27" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>12</knownColor> <state>1</state> </ForeColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-28" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor> <BackColor2 xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor2> <BackGradientStyle>3</BackGradientStyle> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>12</knownColor> <state>1</state> </ForeColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-29" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>10</knownColor> <state>1</state> </ForeColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-30" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BorderColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>150</knownColor> <state>1</state> </BorderColor> <TextTrimming>3</TextTrimming> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-31" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackColor2 xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackGradientAlignment>1</BackGradientAlignment> <BackGradientStyle>2</BackGradientStyle> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColor> <TextHAlign>1</TextHAlign> <ThemedElementAlpha>3</ThemedElementAlpha> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-32" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>24</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-33" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackColor2 xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColorDisabled> <BackColorDisabled2 xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColorDisabled2> <BackGradientStyle>2</BackGradientStyle> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColor> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-34" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackColor2 xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackGradientStyle>2</BackGradientStyle> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-35" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4294639605</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackGradientAlignment>3</BackGradientAlignment> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-36" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>27</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-37" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>8</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-38" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>103</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-39" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorAlpha>2</BackColorAlpha> <Id>0</Id> </a2:Appearance> <a1:UltraGridOverride id="ref-41" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellClickAction>2</CellClickAction> <HeaderClickAction>1</HeaderClickAction> <BorderStyleSummaryFooter>2</BorderStyleSummaryFooter> <BorderStyleSummaryValue>1</BorderStyleSummaryValue> <SummaryFooterCaptionVisible>2</SummaryFooterCaptionVisible> <FixedHeaderIndicator>2</FixedHeaderIndicator> </a1:UltraGridOverride> <a1:ColumnsCollection id="ref-42" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Count>18</Count> <_x0030_ href="#ref-44"/> <_x0031_ href="#ref-45"/> <_x0032_ href="#ref-46"/> <_x0033_ href="#ref-47"/> <_x0034_ href="#ref-48"/> <_x0035_ href="#ref-49"/> <_x0036_ href="#ref-50"/> <_x0037_ href="#ref-51"/> <_x0038_ href="#ref-52"/> <_x0039_ href="#ref-53"/> <_x0031_0 href="#ref-54"/> <_x0031_1 href="#ref-55"/> <_x0031_2 href="#ref-56"/> <_x0031_3 href="#ref-57"/> <_x0031_4 href="#ref-58"/> <_x0031_5 href="#ref-59"/> <_x0031_6 href="#ref-60"/> <_x0031_7 href="#ref-61"/> </a1:ColumnsCollection> <a1:SummarySettingsCollection id="ref-43" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <_x0030_ href="#ref-62"/> <_x0031_ href="#ref-63"/> </a1:SummarySettingsCollection> <a1:UltraGridColumn id="ref-44" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-64"/> <Header href="#ref-65"/> <Hidden>true</Hidden> <Key id="ref-66">BudgetUID</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-45" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-67"/> <Header href="#ref-68"/> <Hidden>true</Hidden> <Key id="ref-69">DetailType</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-46" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-70"/> <Header href="#ref-71"/> <Hidden>true</Hidden> <Key id="ref-72">DetailID</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-47" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-73"/> <Header href="#ref-74"/> <Key id="ref-75">CostCentreCode</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>2</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-48" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-76"/> <Header href="#ref-77"/> <Hidden>true</Hidden> <Key id="ref-78">CostCentreTypeID</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-49" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-79"/> <Header href="#ref-80"/> <Hidden>true</Hidden> <Key id="ref-81">DetailPartTwoID</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-50" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-82"/> <Header href="#ref-83"/> <Key id="ref-84">CostCentrePartTwoDescription</Key> <Width>150</Width> <IsBound>true</IsBound> <ExcludeFromColumnChooser>2</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-51" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-85"/> <Header href="#ref-86"/> <Key id="ref-87">Type</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>2</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-52" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellAppearanceHolder href="#ref-88"/> <Header href="#ref-89"/> <Key id="ref-90">CostTypeID</Key> <Nullable>4</Nullable> <Style>6</Style> <ValueListControl id="ref-91"></ValueListControl> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> <CellClickAction>1</CellClickAction> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-53" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-92"/> <Header href="#ref-93"/> <Hidden>true</Hidden> <Key id="ref-94">CostType</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-54" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-95"/> <Header href="#ref-96"/> <Key id="ref-97">CostCentreDescription</Key> <Width>150</Width> <IsBound>true</IsBound> <ExcludeFromColumnChooser>2</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-55" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-98"/> <Header href="#ref-99"/> <Key id="ref-100">CostCentreClassification</Key> <Width>150</Width> <IsBound>true</IsBound> <ExcludeFromColumnChooser>2</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-56" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-101"/> <Header href="#ref-102"/> <Key id="ref-103">AuthorisationStatus</Key> <Width>150</Width> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-57" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-105"/> <Header href="#ref-106"/> <Key id="ref-107">TotalBudgetedValue</Key> <MaskInput id="ref-108">{LOC}$ nn,nnn,nnn.nn</MaskInput> <Nullable>4</Nullable> <NullText id="ref-109">£0.00</NullText> <Width>120</Width> <Format id="ref-110">C</Format> <IsBound>true</IsBound> <MinValue xsi:type="a5:ObjectWrapper" xmlns:a5="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <objectValue xsi:type="xsd:decimal">0</objectValue> </MinValue> <MaxValue xsi:type="a5:ObjectWrapper" xmlns:a5="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <objectValue xsi:type="xsd:decimal">99999999.99</objectValue> </MaxValue> <ExcludeFromColumnChooser>2</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-58" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-111"/> <Header href="#ref-112"/> <Hidden>true</Hidden> <Key id="ref-113">IsLumpSum</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-59" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-114"/> <Header href="#ref-115"/> <Hidden>true</Hidden> <Key id="ref-116">LastUpdatedDate</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-60" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellAppearanceHolder href="#ref-117"/> <Header href="#ref-118"/> <Key id="ref-119">Total</Key> <MaskInput id="ref-120">{LOC}$ nn,nnn,nnn,nnn.nn</MaskInput> <Nullable>4</Nullable> <NullText id="ref-121">£0.00</NullText> <Width>120</Width> <Format id="ref-122">C</Format> <IsBound>true</IsBound> <MinValue xsi:type="a5:ObjectWrapper" xmlns:a5="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <objectValue xsi:type="xsd:decimal">0</objectValue> </MinValue> <MaxValue xsi:type="a5:ObjectWrapper" xmlns:a5="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <objectValue xsi:type="xsd:decimal">99999999999.99</objectValue> </MaxValue> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> <CellClickAction>1</CellClickAction> </a1:UltraGridColumn> <a1:UltraGridColumn id="ref-61" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <CellActivation>2</CellActivation> <CellAppearanceHolder href="#ref-123"/> <Header href="#ref-124"/> <Hidden>true</Hidden> <Key id="ref-125">TotalID</Key> <IsBound>true</IsBound> <ExcludeFromColumnChooser>1</ExcludeFromColumnChooser> </a1:UltraGridColumn> <a1:SummarySettings id="ref-62" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Key id="ref-126">TotalBudgetedValue</Key> <DisplayFormat id="ref-127">{0:C}</DisplayFormat> <AppearanceHolder href="#ref-128"/> <SummaryType>1</SummaryType> <SourceColumn href="#ref-129"/> <SourceColumnBandKey href="#ref-40"/> <SourceColumnBandIndex>0</SourceColumnBandIndex> </a1:SummarySettings> <a1:SummarySettings id="ref-63" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Key href="#ref-119"/> <DisplayFormat href="#ref-127"/> <AppearanceHolder href="#ref-130"/> <SummaryType>1</SummaryType> <SourceColumn href="#ref-131"/> <SourceColumnBandKey href="#ref-40"/> <SourceColumnBandIndex>0</SourceColumnBandIndex> </a1:SummarySettings> <a2:AppearanceHolder id="ref-64" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-132"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-65" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-133"/> <Caption id="ref-134">Budget UID</Caption> <Enabled>false</Enabled> <VisiblePosition>0</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-67" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-135"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-68" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-136"/> <Caption id="ref-137">Detail Type</Caption> <Enabled>false</Enabled> <VisiblePosition>1</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-70" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-138"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-71" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-139"/> <Caption id="ref-140">Detail ID</Caption> <Enabled>false</Enabled> <VisiblePosition>2</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-73" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-141"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-74" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-142">Cost Centre Code</Caption> <VisiblePosition>3</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-76" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-143"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-77" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-144"/> <Caption id="ref-145">Cost Centre Type ID</Caption> <Enabled>false</Enabled> <VisiblePosition>4</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-79" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-146"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-80" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-147"/> <Caption id="ref-148">Detail Part Two ID</Caption> <Enabled>false</Enabled> <VisiblePosition>5</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-82" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-149"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-83" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-150">Cost Centre Part Two Description</Caption> <VisiblePosition>6</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-85" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-151"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-86" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <VisiblePosition>7</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-88" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-152"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-89" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-153">Cost Type</Caption> <VisiblePosition>8</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-92" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-154"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-93" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-155"/> <Caption id="ref-156">Cost Type</Caption> <Enabled>false</Enabled> <VisiblePosition>9</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-95" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-157"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-96" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-158">Cost Centre Description</Caption> <VisiblePosition>10</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-98" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-159"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-99" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-160">Cost Centre Classification</Caption> <VisiblePosition>11</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-101" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-161"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-102" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-162">Authorisation Status</Caption> <VisiblePosition>12</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-105" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-163"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-106" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Caption id="ref-164">Budget Total</Caption> <VisiblePosition>13</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-111" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-165"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-112" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-166"/> <Caption id="ref-167">Is Lump Sum</Caption> <Enabled>false</Enabled> <VisiblePosition>14</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-114" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-168"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-115" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-169"/> <Caption id="ref-170">Last Updated Date</Caption> <Enabled>false</Enabled> <VisiblePosition>15</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-117" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-171"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-118" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <VisiblePosition>16</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-123" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-172"/> </a2:AppearanceHolder> <a1:ColumnHeader id="ref-124" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <AppearanceHolder href="#ref-173"/> <Caption id="ref-174">Total ID</Caption> <Enabled>false</Enabled> <VisiblePosition>17</VisiblePosition> </a1:ColumnHeader> <a2:AppearanceHolder id="ref-128" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-175"/> </a2:AppearanceHolder> <a1:SerializedColumnID id="ref-129" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Key href="#ref-107"/> <RelativeIndex>13</RelativeIndex> <Bound>true</Bound> <SortIndicator>0</SortIndicator> <IsGroupByColumn>false</IsGroupByColumn> </a1:SerializedColumnID> <a2:AppearanceHolder id="ref-130" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-176"/> </a2:AppearanceHolder> <a1:SerializedColumnID id="ref-131" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win.UltraWinGrid/Infragistics4.Win.UltraWinGrid.v11.2"> <Key href="#ref-119"/> <RelativeIndex>16</RelativeIndex> <Bound>true</Bound> <SortIndicator>0</SortIndicator> <IsGroupByColumn>false</IsGroupByColumn> </a1:SerializedColumnID> <a2:Appearance id="ref-132" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-133" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-177"/> </a2:AppearanceHolder> <a2:Appearance id="ref-135" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-136" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-178"/> </a2:AppearanceHolder> <a2:Appearance id="ref-138" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-139" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-179"/> </a2:AppearanceHolder> <a2:Appearance id="ref-141" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-143" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-144" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-180"/> </a2:AppearanceHolder> <a2:Appearance id="ref-146" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-147" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-181"/> </a2:AppearanceHolder> <a2:Appearance id="ref-149" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-151" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-152" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-154" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-155" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-182"/> </a2:AppearanceHolder> <a2:Appearance id="ref-157" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-159" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-161" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-163" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <TextHAlign>3</TextHAlign> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-165" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-166" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-183"/> </a2:AppearanceHolder> <a2:Appearance id="ref-168" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-169" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-184"/> </a2:AppearanceHolder> <a2:Appearance id="ref-171" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <TextHAlign>3</TextHAlign> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-172" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>28</knownColor> <state>1</state> </BackColorDisabled> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:AppearanceHolder id="ref-173" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Appearance href="#ref-185"/> </a2:AppearanceHolder> <a2:Appearance id="ref-175" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor> <FontData href="#ref-186"/> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColor> <TextHAlign>3</TextHAlign> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-176" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor> <FontData href="#ref-187"/> <ForeColor xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColor> <TextHAlign>3</TextHAlign> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-177" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-178" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-179" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-180" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-181" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-182" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-183" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-184" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:Appearance id="ref-185" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColorDisabled xsi:type="a3:Color" xmlns:a3="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a2:Appearance> <a2:FontData id="ref-186" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Bold>1</Bold> </a2:FontData> <a2:FontData id="ref-187" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <Bold>1</Bold> </a2:FontData> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <SOAP-ENV:Body> <a1:ObjectStreamer id="ref-1" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <PresetType>-1</PresetType> <TargetTypeName id="ref-4">UltraGridBase</TargetTypeName> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4294639605</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <DisplayLayout href="#ref-5"/> <Text id="ref-6">ultraGrid1</Text> </a1:ObjectStreamer> <a1:ObjectStreamer id="ref-5" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <Override href="#ref-8"/> <TargetTypeName id="ref-9">UltraGridLayout</TargetTypeName> <RowConnectorStyle>4</RowConnectorStyle> <BorderStyle>4</BorderStyle> <PresetType>-1</PresetType> <UseFixedHeaders>true</UseFixedHeaders> <MaxColScrollRegions>1</MaxColScrollRegions> <GroupByBox href="#ref-10"/> <ScrollStyle>1</ScrollStyle> <RowConnectorColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </RowConnectorColor> <Appearance href="#ref-11"/> <MaxRowScrollRegions>1</MaxRowScrollRegions> <CaptionVisible>2</CaptionVisible> <ScrollBounds>0</ScrollBounds> <ViewStyleBand>2</ViewStyleBand> </a1:ObjectStreamer> <a1:ObjectStreamer id="ref-8" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <SpecialRowSeparator>4</SpecialRowSeparator> <FilterRowPrompt id="ref-12">Click here to filter data...</FilterRowPrompt> <RowSelectorHeaderStyle>4</RowSelectorHeaderStyle> <GroupByRowAppearance href="#ref-13"/> <RowAppearance href="#ref-14"/> <HeaderStyle>1</HeaderStyle> <RowSelectorAppearance href="#ref-15"/> <FilterEvaluationTrigger>1</FilterEvaluationTrigger> <CellPadding>0</CellPadding> <CellAppearance href="#ref-16"/> <AllowUpdate>1</AllowUpdate> <FilterRowPromptAppearance href="#ref-17"/> <SelectedRowAppearance href="#ref-18"/> <RowSelectors>1</RowSelectors> <FilterOperatorLocation>3</FilterOperatorLocation> <TemplateAddRowAppearance href="#ref-19"/> <HeaderClickAction>3</HeaderClickAction> <TargetTypeName id="ref-20">UltraGridOverride</TargetTypeName> <CardAreaAppearance href="#ref-21"/> <HeaderAppearance href="#ref-22"/> <BorderStyleCell>2</BorderStyleCell> <FilterClearButtonLocation>4</FilterClearButtonLocation> <FilterRowAppearance href="#ref-23"/> <FilterOperatorDefaultValue>11</FilterOperatorDefaultValue> <BorderStyleRow>2</BorderStyleRow> <FilterUIType>2</FilterUIType> <PresetType>-1</PresetType> <ActiveCellAppearance href="#ref-24"/> </a1:ObjectStreamer> <a1:ObjectStreamer id="ref-10" xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Infragistics.Shared.Serialization/Infragistics4.Shared.v11.2"> <PresetType>-1</PresetType> <Appearance href="#ref-25"/> <PromptAppearance href="#ref-26"/> <TargetTypeName id="ref-27">GroupByBox</TargetTypeName> <BandLabelAppearance href="#ref-28"/> <Hidden>true</Hidden> <BorderStyle>4</BorderStyle> <Style>1</Style> </a1:ObjectStreamer> <a4:Appearance id="ref-11" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4294639605</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackGradientAlignment>3</BackGradientAlignment> <BorderColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>17</knownColor> <state>1</state> </BorderColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-13" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4294639605</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackGradientAlignment>3</BackGradientAlignment> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-14" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>24</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-15" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackColor2 xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackGradientStyle>2</BackGradientStyle> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-16" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BorderColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>150</knownColor> <state>1</state> </BorderColor> <TextTrimming>3</TextTrimming> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-17" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColorAlpha>2</BackColorAlpha> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-18" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackColor2 xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackColorDisabled xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColorDisabled> <BackColorDisabled2 xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColorDisabled2> <BackGradientStyle>2</BackGradientStyle> <ForeColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColor> <ForeColorDisabled xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColorDisabled> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-19" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>8</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-21" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>27</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-22" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor> <BackColor2 xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4289378435</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackGradientAlignment>1</BackGradientAlignment> <BackGradientStyle>2</BackGradientStyle> <ForeColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>35</knownColor> <state>1</state> </ForeColor> <TextHAlign>1</TextHAlign> <ThemedElementAlpha>3</ThemedElementAlpha> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-23" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>103</knownColor> <state>1</state> </BackColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-24" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>10</knownColor> <state>1</state> </ForeColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-25" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor> <BackColor2 xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>4293522119</value> <knownColor>0</knownColor> <state>2</state> </BackColor2> <BackGradientAlignment>3</BackGradientAlignment> <BackGradientStyle>5</BackGradientStyle> <BorderColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>79</knownColor> <state>1</state> </BorderColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-26" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <BackColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor> <BackColor2 xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>164</knownColor> <state>1</state> </BackColor2> <BackGradientStyle>3</BackGradientStyle> <ForeColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>12</knownColor> <state>1</state> </ForeColor> <Id>0</Id> </a4:Appearance> <a4:Appearance id="ref-28" xmlns:a4="http://schemas.microsoft.com/clr/nsassem/Infragistics.Win/Infragistics4.Win.v11.2"> <ForeColor xsi:type="a2:Color" xmlns:a2="http://schemas.microsoft.com/clr/nsassem/System.Drawing/System.Drawing"> <name xsi:null="1"/> <value>0</value> <knownColor>12</knownColor> <state>1</state> </ForeColor> <Id>0</Id> </a4:Appearance> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
Here are the XMLs in the broken state. I'll get to trying the DataGridView as soon as I get the time.
Thanks again for looking into this
I looked over these files and I don't see anything obvious that would cause the grid not to show the rows. One thing that occurred to me is that you have filtering turned on in your grid. So if there were filters applied to the grid, that would explain why the data source has rows and the grid doesn't show any of them. But I don't see any ColumnFilters applied to your grid in the DisplayLayout file. I suppose it's possible that your DataTable has filtering applied to it directly. So that might be worth looking into. Another thing I checked is the grid's LoadStyle - I was thinking maybe if it was set to LoadOnDemand the rows would get loaded into the grid asynchronously. But that does not appear to be the case either. The one thing I noticed that seems most likely to be an issue is that you are apparently using v11.2 of the Infragistics assemblies. That's about 8 years old, which is positively ancient in the world of application development. :) So this could very easily be an old bug in the controls that has long-since been fixed. So I would definitely recommend download the latest (20.1) trial version and testing your application with that version to see if that fixes the issue. I would not be at all surprised if the issue you are experiencing came up in some other way and was fixed.
Apologies for the late reply.
It looks as though updating to v20.1 does fix the issue.
Thanks for the help!