Скачать или смотреть How to Sum Selected Rows in a WPF DataGrid Using C#

Learn how to easily sum specific columns of selected rows in a WPF DataGrid using C-. This guide walks you through the steps with clear examples to help you implement it seamlessly.
---
This video is based on the question https://stackoverflow.com/q/70915086/ asked by the user 'Tamal Banerjee' ( https://stackoverflow.com/u/6119995/ ) and on the answer https://stackoverflow.com/a/70916111/ provided by the user 'Jayanta_KMC' ( https://stackoverflow.com/u/17938241/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How do I do a sum of gridview cells from selected rows in WPF using c-?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Sum Selected Rows in a WPF DataGrid Using C-

Working with data in WPF applications often involves displaying it in a DataGrid. A common requirement is performing operations on selected rows, such as calculating the sum of specific columns. If you're wondering how to sum values from selected rows in a DataGrid, you've come to the right place. Let's break it down step by step.

The Problem

Let’s say you have a DataGrid in your WPF application populated with rows of data. You want to calculate the total of a particular column for the rows that have been selected by the user. In Windows Forms, you might be used to accessing the Cells property of a selected row, but in WPF, the approach is a little different, which can lead to confusion. As you've encountered, trying to access Cells directly on DataGridRow results in an error because DataGridRow does not expose the Cells property like DataGridViewRow does.

Solution Overview

Here's how to efficiently sum the values of a specified column from the selected rows in a WPF DataGrid using C-. We'll utilize a combination of List<T> to store the values and a simple for loop to iterate through the selected items. Below are the detailed steps to achieve this.

Step-by-Step Solution

Create a list to store target cell values:

We'll declare a list of type decimal to hold the values we want to sum.

[[See Video to Reveal this Text or Code Snippet]]

Loop through the selected items:

Use a for loop to iterate through the SelectedItems of the DataGrid. Each selected item can be cast to DataRowView, which allows us to access the underlying data.

[[See Video to Reveal this Text or Code Snippet]]

Here, row[2] corresponds to the column index you want to sum. Adjust the index as per your DataGrid's structure.

Calculate the total:

Once we have all the relevant data in our list, we can easily calculate the total by calling the Sum method.

[[See Video to Reveal this Text or Code Snippet]]

Complete Code Example

Here’s how the entire code snippet looks:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

By following these steps, you can successfully calculate the sum of specific columns from the selected rows in your WPF DataGrid. While this method utilizes a for loop to gather data, experienced developers may also explore LINQ to streamline the process even further. However, the approach above is straightforward, making it accessible to those who may not be familiar with LINQ.

Don't hesitate to experiment with this solution in your WPF applications. Happy coding!