I wrote below code to calculate 2 column in one row in my grid view.But it was not worked
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
$(function () {
$("[id*=tPkgs]").val("0");
$("[id*=tNetWeight]").val("0");
$("[id*=lblTotWeight]").val("0");
});
$("[id*=tPkgs]").live("change", function () {
if (isNaN(parseInt($(this).val()))) {
$(this).val('0');
} else {
$(this).val(parseInt($(this).val()).toString());
}
});
$("[id*=tNetWeight]").live("change", function () {
if (isNaN(parseInt($(this).val()))) {
$(this).val('0');
} else {
$(this).val(parseInt($(this).val()).toString());
}
});
$("[id*=tPkgs]").live("keyup", function () {
if (!jQuery.trim($(this).val()) == '') {
if (!isNaN(parseFloat($(this).val()))) {
var row = $(this).closest("tr");
$("[id*=lblTotWeight]", row).html(1 * parseFloat($(this).val()));
}
} else {
$(this).val('');
}
// var grandTotal = 0;
// $("[id*=lblTotWeight]").each(function () {
// grandTotal = grandTotal + parseFloat($(this).html());
//});
// $("[id*=lblTotWeight]").html(grandTotal.toString());
});
</script>
<div id = "dvGrid">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server" OnRowDataBound="OnRowDataBound"
AutoGenerateColumns = "False" Font-Names = "Arial"
Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"
HeaderStyle-BackColor = "green" AllowPaging ="True" ShowFooter = "True"
OnPageIndexChanging = "OnPaging" onrowediting="EditCustomer"
onrowupdating="UpdateCustomer" onrowcancelingedit="CancelEdit" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Vertical" >
<Columns>
<asp:TemplateField HeaderText = "StockID">
<ItemTemplate>
<asp:Label ID="tStockID" runat="server"
Text='<%# Eval("StockID")%>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lbltockID" runat="server" Text='<%# Eval("StockID")%>'></asp:Label>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Abb">
<ItemTemplate>
<asp:Label ID="lblAbb" runat="server"
Text='<%# Eval("Abb")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tAbb" runat="server"
Text='<%# Eval("Abb")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tAbb" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Lot No">
<ItemTemplate>
<asp:Label ID="lblLotNo" runat="server"
Text='<%# Eval("LotNo")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tLotNo" Text='<%# Eval("LotNo") %>' runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tLotNo" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Invoice No">
<ItemTemplate>
<asp:Label ID="lblInvoiceNo" runat="server"
Text='<%# Eval("InvoiceNo")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tInvoiceNo" runat="server"
Text='<%# Eval("InvoiceNo")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tInvoiceNo" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Tea State">
<ItemTemplate>
<asp:Label ID="lblTeaState" runat="server"
Text='<%# Eval("TeaState")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tTeaState" runat="server"
Text='<%# Eval("TeaState")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="cmdTeaState" runat="server"></asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Customer">
<ItemTemplate>
<asp:Label ID="lblCustomer" runat="server"
Text='<%# Eval("Customer")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tCustomer" runat="server"
Text='<%# Eval("Customer")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="cmdCustomer" runat="server"></asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Broker">
<ItemTemplate>
<asp:Label ID="lblBroker" runat="server"
Text='<%# Eval("Broker")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tBroker" runat="server"
Text='<%# Eval("Broker")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="cmdBroker" runat="server"></asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Tea Grade">
<ItemTemplate>
<asp:Label ID="lblTeaGrade" runat="server"
Text='<%# Eval("TeaGrade")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tTeaGrade" runat="server"
Text='<%# Eval("TeaGrade")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="cmdTeaGrade" runat="server"></asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Pkgs">
<ItemTemplate>
<asp:Label ID="lblPkgs" runat="server"
Text='<%# Eval("Pkgs")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tPkgs" runat="server"
Text='<%# Eval("Pkgs")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tPkgs" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Net Weight">
<ItemTemplate>
<asp:Label ID="lblBroker" runat="server"
Text='<%# Eval("NetWeight")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tNetWeight" runat="server"
Text='<%# Eval("NetWeight")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tNetWeight" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "TotWeight">
<ItemTemplate>
<asp:Label ID="lblTotWeight" runat="server"
Text='<%# Eval("TotWeight")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tTotWeight" runat="server"></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:Label ID="lblTotWeight" runat="server" Text="0"></asp:Label>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "PriceUSD">
<ItemTemplate>
<asp:Label ID="lblPriceUSD" runat="server"
Text='<%# Eval("PriceUSD")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tPriceUSD" runat="server"
Text='<%# Eval("PriceUSD")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tPriceUSD" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "Currency Rate">
<ItemTemplate>
<asp:Label ID="lblCurrencyRate" runat="server"
Text='<%# Eval("CurrencyRate")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tCurrencyRate" runat="server"
Text='<%# Eval("CurrencyRate")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tCurrencyRate" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "TotalAmtUSD">
<ItemTemplate>
<asp:Label ID="lblTotalAmtUSD" runat="server"
Text='<%# Eval("TotalAmtUSD")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tTotalAmtUSD" runat="server"
Text='<%# Eval("TotalAmtUSD")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tTotalAmtUSD" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText = "BrokerageUSD">
<ItemTemplate>
<asp:Label ID="lblBrokerageUSD" runat="server"
Text='<%# Eval("BrokerageUSD")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="tBrokerageUSD" runat="server"
Text='<%# Eval("BrokerageUSD")%>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="tBrokerageUSD" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkRemove" runat="server"
CommandArgument = '<%# Eval("StockID")%>'
OnClientClick = "return confirm('Do you want to delete?')"
Text = "Delete" OnClick = "DeleteCompany"></asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:Button ID="bSave" runat="server" Text="Add"
OnClick = "AddNewStock" />
</FooterTemplate>
</asp:TemplateField>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField />
</Columns>
<AlternatingRowStyle BackColor="White" />
<FooterStyle BackColor="#CCCC99" />
<HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
<RowStyle BackColor="#F7F7DE" />
<SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#FBFBF2" />
<SortedAscendingHeaderStyle BackColor="#848384" />
<SortedDescendingCellStyle BackColor="#EAEAD3" />
<SortedDescendingHeaderStyle BackColor="#575357" />
</asp:GridView>
