DevExpress v24.1 Update — Your Feedback Matters
Our What's New in v24.1 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.
Take the survey
Not interested
DxGrid.GetTotalSummaryFormattedValue(IGridSummaryItem) Method
Namespace : DevExpress.Blazor
Assembly :
DevExpress.Blazor.v24.1.dll
NuGet Package :
DevExpress.Blazor
# Declaration
# Parameters
# Returns
Type
Description
String
The total summary item’s formatted value.
Use the ValueDisplayFormat property to specify the pattern to format the summary value .
The following code snippet customizes the Unit Price column’s footer. The footer contains the summary’s label and formatted value.
@using Microsoft.EntityFrameworkCore
@inject IDbContextFactory<NorthwindContext> NorthwindContextFactory
@ implements IDisposable
<DxGrid @ref ="Grid3"
Data ="@ Data" >
<Columns >
<DxGridDataColumn FieldName ="Country" />
<DxGridDataColumn FieldName ="City" />
<DxGridDataColumn FieldName ="OrderDate" />
<DxGridDataColumn FieldName ="UnitPrice" DisplayFormat ="c" Width ="180px" >
<FooterTemplate >
@{
var summaryItems = context.SummaryItems;
if (summaryItems.Any())
{
foreach (var i in summaryItems)
{
@context.Grid.GetTotalSummaryLabel(i)
<text> of </text>
@context.DataColumn.FieldName
<text>: </text>
@context.Grid.GetTotalSummaryFormattedValue(i)
}
}
}
</FooterTemplate >
</DxGridDataColumn >
<DxGridDataColumn FieldName ="Quantity" />
</Columns >
<TotalSummary >
<DxGridSummaryItem SummaryType ="GridSummaryItemType.Max" ValueDisplayFormat ="c" FieldName ="UnitPrice" />
</TotalSummary >
</DxGrid >
@ code {
object Data { get ; set ; }
NorthwindContext Northwind { get ; set ; }
@* ... *@
IGrid Grid3 { get ; set ; }
protected override void OnInitialized ( ) {
Northwind = NorthwindContextFactory.CreateDbContext();
Data = Northwind.Invoices
.ToList();
}
@* ... *@
public void Dispose ( ) {
Northwind?.Dispose();
}
}
using System ;
#nullable disable
namespace Grid.Northwind {
public partial class Invoice {
public string ShipName { get ; set ; }
public string ShipAddress { get ; set ; }
public string ShipCity { get ; set ; }
public string ShipRegion { get ; set ; }
public string ShipPostalCode { get ; set ; }
public string ShipCountry { get ; set ; }
public string CustomerId { get ; set ; }
public string CustomerName { get ; set ; }
public string Address { get ; set ; }
public string City { get ; set ; }
public string Region { get ; set ; }
public string PostalCode { get ; set ; }
public string Country { get ; set ; }
public string Salesperson { get ; set ; }
public int OrderId { get ; set ; }
public DateTime? OrderDate { get ; set ; }
public DateTime? RequiredDate { get ; set ; }
public DateTime? ShippedDate { get ; set ; }
public string ShipperName { get ; set ; }
public int ProductId { get ; set ; }
public string ProductName { get ; set ; }
public decimal UnitPrice { get ; set ; }
public short Quantity { get ; set ; }
public float Discount { get ; set ; }
public decimal ? ExtendedPrice { get ; set ; }
public decimal ? Freight { get ; set ; }
}
}
using Microsoft.EntityFrameworkCore ;
#nullable disable
namespace Grid.Northwind {
public partial class NorthwindContext : DbContext {
public NorthwindContext (DbContextOptions<NorthwindContext> options )
: base (options ) {
}
public virtual DbSet<Invoice> Invoices { get ; set ; }
protected override void OnConfiguring (DbContextOptionsBuilder optionsBuilder ) {
if (!optionsBuilder.IsConfigured) {
optionsBuilder.UseSqlServer("Server=.\\sqlexpress;Database=Northwind;Integrated Security=true" );
}
}
protected override void OnModelCreating (ModelBuilder modelBuilder ) {
modelBuilder.Entity<Invoice>(entity => {
entity.HasNoKey();
entity.ToView("Invoices" );
entity.Property(e => e.Address).HasMaxLength(60 );
entity.Property(e => e.City).HasMaxLength(15 );
entity.Property(e => e.Country).HasMaxLength(15 );
entity.Property(e => e.CustomerId)
.HasMaxLength(5 )
.HasColumnName("CustomerID" )
.IsFixedLength(true );
entity.Property(e => e.CustomerName)
.IsRequired()
.HasMaxLength(40 );
entity.Property(e => e.ExtendedPrice).HasColumnType("money" );
entity.Property(e => e.Freight).HasColumnType("money" );
entity.Property(e => e.OrderDate).HasColumnType("datetime" );
entity.Property(e => e.OrderId).HasColumnName("OrderID" );
entity.Property(e => e.PostalCode).HasMaxLength(10 );
entity.Property(e => e.ProductId).HasColumnName("ProductID" );
entity.Property(e => e.ProductName)
.IsRequired()
.HasMaxLength(40 );
entity.Property(e => e.Region).HasMaxLength(15 );
entity.Property(e => e.RequiredDate).HasColumnType("datetime" );
entity.Property(e => e.Salesperson)
.IsRequired()
.HasMaxLength(31 );
entity.Property(e => e.ShipAddress).HasMaxLength(60 );
entity.Property(e => e.ShipCity).HasMaxLength(15 );
entity.Property(e => e.ShipCountry).HasMaxLength(15 );
entity.Property(e => e.ShipName).HasMaxLength(40 );
entity.Property(e => e.ShipPostalCode).HasMaxLength(10 );
entity.Property(e => e.ShipRegion).HasMaxLength(15 );
entity.Property(e => e.ShippedDate).HasColumnType("datetime" );
entity.Property(e => e.ShipperName)
.IsRequired()
.HasMaxLength(40 );
entity.Property(e => e.UnitPrice).HasColumnType("money" );
});
OnModelCreatingPartial(modelBuilder);
}
partial void OnModelCreatingPartial (ModelBuilder modelBuilder ) ;
}
}
using Microsoft.EntityFrameworkCore ;
builder.Services.AddDbContextFactory<NorthwindContext>((sp, options) => {
var env = sp.GetRequiredService<IWebHostEnvironment>();
var dbPath = Path.Combine(env.ContentRootPath, "Northwind-5e44b51f.mdf" );
options.UseSqlServer("Server=(localdb)\\MSSQLLocalDB;Integrated Security=true;AttachDbFileName=" + dbPath);
});
For more information about summaries in the Grid component, refer to the following topic: Summary in Blazor Grid .
See Also