sum of filtered rows of datagridview

[petrogeo]

Hi,

I have a datagridview in my application with numeric columns and date column. This datagridview is filtered by date. I want a label to show the sum of the filtered rows.

Can you help me?

[ForumAccount]

Are you binding the DataGridView? How are you filtering the rows?

[petrogeo]

Yes I am. Please find below the code:

  
    Private Sub DateTimePicker1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DateTimePicker1.ValueChanged
        Dim strData As String
        strData = DateTimePicker1.Text
        Me.CadastroSeqBindingSource.Filter = "Data = '" + strData + "'"
        Me.CadastroSeqTableAdapter.Fill(Me.Db01DataSet.CadastroSeq)
End Sub

Thanks

[jmcilhinney]

E.g.

Dim sum = CInt(Me.Db01DataSet.CadastroSeq.Compute("SUM(SomeColumn)", Me.CadastroSeqBindingSource.Filter)

[petrogeo]

Wawww, It works very well, thank you.