Infragistics logo
메뉴
.NET and JavaScript UI Controls
Version

Value Property (SummaryValue)

Returns the calculated summary value for this summary.
Syntax
'Declaration
 
Public ReadOnly Property Value As Object
public object Value {get;}
Remarks

Value property returns the calculated summary value for this summary. The type of object returned depends on the type of calculations performed. For example, Minimum or Maximum summary calculations simply return the smallest or the largest cell value, without performing any conversion on the value. For Sum or Average summary type it will be a decimal instance and for Count summary type it will be an integer.

You can use the SummaryText property to retrive the text as it's displayed in summary.

Example
Following code shows some of the information available in SummaryValueChanged event. It sets different appearance on different summaries based on summary values.

For an overview of how to handle events in Visual Basic or Visual C#, see Event Handlers in Visual Basic and Visual C#. For specific information and code examples illustrating how to consume events in your application, see Consuming Events in the .NET Framework Developer's Guide.

Imports Infragistics.Shared
Imports Infragistics.Win
Imports Infragistics.Win.UltraWinGrid

  Private Sub UltraGrid1_SummaryValueChanged(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.SummaryValueChangedEventArgs) Handles ultraGrid1.SummaryValueChanged

      ' Use the key to identify what summary the SummaryValue object is associated with
      ' and set appearance properties accordingly.

      If e.SummaryValue.Key = "Max" Then
          If CType(e.SummaryValue.Value, Decimal) < 20 Then
              ' If the max is less than han 40, then highlight the summary with red color
              ' by setting the back color to red
              e.SummaryValue.Appearance.BackColor = Color.LightYellow
          Else
              e.SummaryValue.Appearance.BackColor = Color.SkyBlue
          End If
      End If

      If e.SummaryValue.Key = "Avg" Then
          If CType(e.SummaryValue.Value, Decimal) > 20 Then
              ' If the sum is greater than 20, then highlight the summary with red color
              ' by setting the back color to red
              e.SummaryValue.Appearance.BackColor = Color.LightSkyBlue
          Else
              e.SummaryValue.Appearance.BackColor = Color.LightYellow
          End If
      End If

  End Sub
using Infragistics.Shared;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System.Diagnostics;

private void ultraGrid1_SummaryValueChanged(object sender, Infragistics.Win.UltraWinGrid.SummaryValueChangedEventArgs e)
{

	// Use the key to identify what summary the SummaryValue object is associated with
	// and set appearance properties accordingly.

	if ( e.SummaryValue.Key == "Max" )
	{	
		if ( (decimal)e.SummaryValue.Value < 20 )
		{
			// If the max is less than han 40, then highlight the summary with red color
			// by setting the back color to red
			e.SummaryValue.Appearance.BackColor = Color.LightYellow;
		}
		else 
		{
			e.SummaryValue.Appearance.BackColor = Color.SkyBlue;
		}
	}

	if ( e.SummaryValue.Key == "Avg" )
	{	
		if ( (decimal)e.SummaryValue.Value > 20 )
		{
			// If the sum is greater than 20, then highlight the summary with red color
			// by setting the back color to red
			e.SummaryValue.Appearance.BackColor = Color.LightSkyBlue;
		}
		else 
		{
			e.SummaryValue.Appearance.BackColor = Color.LightYellow;
		}
	}

}
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also