I have a gridview with the facility to change the value of a textbox in gridview, I have managed to calculate rows values and displays values in the rightmost bar.
I would like to ask, how to calculate the values in a column and displays in the footer using javascript ?
here's my js code :
function JvfunonBlur() {
var grid = document.getElementById('<%=GridView1.ClientID %>');
var col1; var col2; var col3; var col4; var col5; var col6; var col7; var col8; var col9;
var total;
for (i = 0; i < grid.rows.length; i++) {
col1 = grid.rows[i].cells[2];
col2 = grid.rows[i].cells[3];
total = grid.rows[i].cells[4];
for (j = 0; j < col1.childNodes.length; j++) {
if (col1.childNodes[j].type == "text") {
if (!isNaN(col1.childNodes[j].value) && col1.childNodes[j].value != "") {
total.childNodes[j].value = parseFloat(col2.childNodes[j].value) + parseFloat(col1.childNodes[j].value)
}
}
}
for (j = 0; j < col2.childNodes.length; j++) {
if (col2.childNodes[j].type == "text") {
if (!isNaN(col2.childNodes[j].value) && col2.childNodes[j].value != "") {
total.childNodes[j].value = parseFloat(col2.childNodes[j].value) + parseFloat(col1.childNodes
}
}
}
}
}
here's my aspx code :
<asp:GridView runat="server" OnRowCommand="GridView1_RowCommand" onrowdatabound="GridView1_RowDataBound"
AllowSorting="True" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit"
GridLines="None" ShowFooter="True" ForeColor="#333333" ID="GridView1"
OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating" Width="1098px" Font-Bold="True">
<AlternatingRowStyle BackColor="White"></AlternatingRowStyle>
<Columns><asp:TemplateField HeaderText="No.Pengajuan" Visible="False">
<ItemTemplate><asp:Label ID="lblno_pengajuanP" runat="server" ForeColor="Black"
Text='<%# Eval("no_pengajuan") %>' Width="20px"></asp:Label></ItemTemplate></asp:TemplateField>
<asp:TemplateField HeaderText="Product" Visible="False">
<ItemTemplate>
<asp:Label ID="lblkode_produk" runat="server" ForeColor="Black"
Text='<%# Eval("kode_produk") %>' Width="20px"></asp:Label></ItemTemplate></asp:TemplateField>
<asp:TemplateField HeaderText="PRODUCT DESCRIPTION"
SortExpression="nama_produk">
<ItemTemplate>
<asp:Label ID="lblnamaproduk" runat="server" Text='<%# Eval("nama_produk")%>'
Width="300px"></asp:Label></ItemTemplate>
<ControlStyle Width="300px"></ControlStyle>
<HeaderStyle ForeColor="White"></HeaderStyle></asp:TemplateField>
<asp:TemplateField HeaderText="UNIT"
SortExpression="unit"> <FooterTemplate>
<asp:Label ID="total1" runat="server" />
</FooterTemplate><ItemTemplate>
<asp:TextBox ID="lblunitproduct" runat="server" Text='<%# Eval("unit")%>'
Width="50px"></asp:TextBox></ItemTemplate>
<ControlStyle Width="50px"></ControlStyle>
<HeaderStyle ForeColor="White" HorizontalAlign="Center"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" /></asp:TemplateField>
<asp:TemplateField HeaderText="ONFAKTUR"
SortExpression="onfaktur"> <FooterTemplate>
<asp:Label ID="total2" runat="server" />
</FooterTemplate>
<EditItemTemplate><asp:TextBox ID="txtonfaktur" runat="server" Text='<%# Eval("onfaktur")%>'
Width="20px" ReadOnly="true"></asp:TextBox></EditItemTemplate>
<ItemTemplate>
<asp:TextBox ID="lblonfaktur" runat="server" Text='<%# Eval("onfaktur")%>'
Width="20px"></asp:TextBox></ItemTemplate>
<ControlStyle Width="50px"></ControlStyle>
<HeaderStyle ForeColor="White"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" /></asp:TemplateField>
<asp:TemplateField HeaderText="TOTAL" SortExpression="total_diskon">
<HeaderTemplate>
<asp:LinkButton ID="linktotal_diskon"
ForeColor="White" runat="server" Text="TOTAL" CommandName="Sort"
CommandArgument="total_diskon">
</asp:LinkButton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lbltotal_diskon" runat="server" Width="50px"
Text='<%# Eval("totaldiskon")%>'></asp:Label>
</ItemTemplate>
<ControlStyle Width="100px"></ControlStyle>
<HeaderStyle ForeColor="White"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="50px"></ItemStyle>
</asp:TemplateField>
</Columns>
<EditRowStyle BackColor="White"></EditRowStyle>
<FooterStyle HorizontalAlign="Center" BackColor="FloralWhite" Font-Bold="True"
ForeColor="Black"></FooterStyle>
</asp:GridView>