get a summery of for filtered items in UI for ASP.NET AJAX

This is a migrated thread and some comments may be shown as answers.

get a summery of for filtered items

3 Answers 5 Views

Grid

This is a migrated thread and some comments may be shown as answers.

3 Answers, 1 is accepted

Accepted

answered on 07 Nov 2018, 06:52 PM

Hello Mohammad,

The Count Aggregate will give you that information. You can see more about in the following resources:

demo (see the Product ID column, you can also remove the default grouping the demo has): https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/grouping/group-footers/defaultcs.aspx.
documentation on aggregates: https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/how-to/Common/totals-in-grid-footers.

Here's also a very simple example I created for you:

<telerik:RadGrid runat="server" ID="rg1" OnNeedDataSource="rg1_NeedDataSource" AllowFilteringByColumn="true" ShowFooter="true">

<MasterTableView>

<Columns>

<telerik:GridBoundColumn Aggregate="Count" FooterAggregateFormatString="total count of items: {0}" DataField="Id"></telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

and some dummy data to get it running:

protected DataTable GetDummyData()

{

DataTable tbl = new DataTable();

tbl.Columns.Add(new DataColumn("Id", typeof(decimal)));

tbl.Columns.Add(new DataColumn("textField", typeof(string)));

tbl.Columns.Add(new DataColumn("valueField", typeof(int)));

tbl.Columns.Add(new DataColumn("fourthField", typeof(string)));

tbl.Rows.Add(new object[] { 1, "one", 1, "red" });

tbl.Rows.Add(new object[] { 1, "two", 2, "green" });

tbl.Rows.Add(new object[] { 5, "three", 3, "blue" });

tbl.Rows.Add(new object[] { 6, "four", 1, "pink" });

return tbl;

}

protected void rg1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)

{

(sender as RadGrid).DataSource = GetDummyData();

}

Regards,
Marin Bratanov
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.