如何对DataGrid列进行求和，并在VB.net WPF中的TextBox、标签或网格页脚显示结果？

<DataGrid x:Name="myDataGrid" ItemsSource="{Binding YourDataCollection}" AutoGenerateColumns="False">
    <DataGrid.Columns>
        <DataGridTextColumn Header="Column1" Binding="{Binding Property1}" />
        <DataGridTextColumn Header="Column2" Binding="{Binding Property2}" />
        <!-- 其他列 -->
    </DataGrid.Columns>
</DataGrid>

Private Sub CalculateSum()
    Dim dataTable As DataTable = (TryCast(myDataGrid.ItemsSource, DataView)).ToTable()
    Dim sum As Double = 0

    For Each row As DataRow In dataTable.Rows
        Dim value As Double
        If Double.TryParse(row("Column1").ToString(), value) Then
            sum += value
        End If
    Next

    ' 将总和显示在TextBox、标签或网格页脚上
    myTextBox.Text = sum.ToString()
    ' 或者
    myLabel.Content = sum.ToString()
    ' 或者
    myDataGrid.FooterRow.Cells(0).Text = sum.ToString()
End Sub

Private Sub CalculateButton_Click(sender As Object, e As RoutedEventArgs)
    CalculateSum()
End Sub