Show total of datagridview selected rows in toolstrip label c#

Question

In my win form application i need to show the sum of my datagridview selected rows in toolstrip label, i am currently able to calculate the sum and display in the label for all the rows in my data grid view. But my requirement is :

If the datagridview gets filtered the label should show only the total of that filtered rows.
If the user selects some rows in the whole datagridview the should show only the total of that selected rows.
please help me how to do this here is my code so far:

int A = 0, B = 0;
                for (A = 0; A < iP_SpoolsDataGridView.Rows.Count; ++A)
                {
                    B += Convert.ToInt32(iP_SpoolsDataGridView.Rows[A].Cells[20].Value);
                }
                Total.Text = B.ToString();

image of my winform:

Answer 1

Hi ravikumar-1532,
First, you can use BindingSource.Filter property to filter the rows with dateTimePicker's value.
Then you can use DataGridView.SelectedRows property to get the collection of rows selected.
Meanwhile, you need to run these in DataGridView.SelectionChanged event which occurs when the current selection changes.
Here is my test code you can refer to.(In my test, I calculate the sum of column Field2)

public Form1()  
{  
    InitializeComponent();  
    dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;  
}  
  
private void button1_Click(object sender, EventArgs e)  
{  
    BindingSource bs = new BindingSource();  
  
    bs.DataSource = dataGridView1.DataSource;  
    bs.Filter = string.Format("Field2 >= #{0:MM/dd/yyyy}# And Field2 <= #{1:MM/dd/yyyy}#", dateTimePicker1.Value, dateTimePicker2.Value);  
  
}  
  
private void dataGridView1_SelectionChanged(object sender, EventArgs e)  
{  
    int total = dataGridView1.SelectedRows.Cast<DataGridViewRow>().Sum(row => (int)row.Cells[1].Value);  
    label1.Text = total.ToString();  
}  

Test result:

Best Regards,
Daniel Zhang

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.