Erste Summe der Werte einer bestimmten Spalte aus GridView

Müssen Sie die databinding-Ereignisse die Summe der Werte. Sehen dieses Beispiel und an Ihre Bedürfnisse anpassen:

private Decimal OrderTotal;

protected void GridView1_DataBinding(object sender, EventArgs e)
{ 
    OrderTotal = 0.0M;
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        //Keep adding the subtotal here
        OrderTotal += Subtotal;               
    }
}

protected void GridView1_DataBound(object sender, EventArgs e)
{      
    //Set a control with the total sum
    LabelOrderTotal.Text = OrderTotal.ToString("C");
}

Grundsätzlich, Sie halten das hinzufügen der Werte in der RowDataBound Veranstaltung und in der DataBound Veranstaltung, die Sie ein label mit der Summe. Alternativ können Sie iterieren über Ihr Stromnetz in die DataBound event und alles summieren.

InformationsquelleAutor nmat

Durchlaufen alle DataRow Zeilen auf der DataBound - Ereignis des gridview-Steuerelements und fügen Sie den Wert von "TextBox3", um eine laufende Summe variable.

Protected Sub grdItems_DataBound(ByVal sender as Object, ByVal e as EventArgs) 
    Dim row As GridViewRow = Nothing
    Dim runningTotal As Double = 0.0
    For i As Integer = 0 to grdItems.Rows.Count
        row = grdItems.Rows(i)
        If row.RowType = DataControlRowType.DataRow Then
            ' Add error handling here
            runningTotal += Ctype(CType(row.FindControl("TextBox3"), Label).Text, Double)
        End If
    Next i
End Sub

InformationsquelleAutor cbillowes

            <asp:TemplateField HeaderText="first_name" SortExpression="first_name">
            <EditItemTemplate>
            <asp:TextBox ID="TextBox_first_name" runat="server" Text='<%# Bind("first_name") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <asp:Label ID="Label_first_name" runat="server" Text='<%# Bind("first_name") %>'></asp:Label>      
            </ItemTemplate>
            </asp:TemplateField>

            <asp:TemplateField HeaderText="middle_name" SortExpression="middle_name">
            <EditItemTemplate>
            <asp:TextBox ID="TextBox_middle_name" runat="server" Text='<%# Bind("middle_name") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <asp:Label ID="Label_middle_name" runat="server" Text='<%# Bind("middle_name") %>'></asp:Label>
            </ItemTemplate>
            </asp:TemplateField>

            <asp:TemplateField HeaderText="last_name" SortExpression="last_name">
            <EditItemTemplate>
            <asp:TextBox ID="TextBox_last_name" runat="server" Text='<%# Bind("last_name") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
            <asp:Label ID="Label_last_name" runat="server" Text='<%# Bind("last_name") %>'></asp:Label>
            </ItemTemplate>


Protected Sub GridView_clients_RowCommand(sender As Object, e As GridViewCommandEventArgs) Handles GridView_clients.RowCommand

    If e.CommandName = "Select" Then

        Dim index As Integer = Convert.ToInt32(e.CommandArgument) 'gets the row

        '........................................

        Dim client_first_name As String = DirectCast(GridView_clients.Rows(index).FindControl("Label_first_name"), Label).Text.ToString
        Dim client_middle_name As String = DirectCast(GridView_clients.Rows(index).FindControl("Label_middle_name"), Label).Text.ToString
        Dim client_last_name As String = DirectCast(GridView_clients.Rows(index).FindControl("Label_last_name"), Label).Text.ToString


        'MsgBox(client_first_name)
        'MsgBox(client_middle_name)
        'MsgBox(client_last_name)

        lb_test.Text = client_first_name & " " & client_middle_name & " " & client_last_name

    End If

End Sub

von Craig Lewis Johnson von FSSA - Indiana

InformationsquelleAutor user2390722