Add two columns value and show total in another column

I have a gridview with 9 columns. I want to get the sum of column Net Premium, VAT & Registry Fee. I added another template field called TOTAL. Now, I want to display the sum result in the TOTAL column. But I got this error... attached also the snippets of my front and backend code.

"gvListOfIssuedTaxInvoice" runat="server" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
CellPadding="4" AutoGenerateColumns="False" ShowFooter="True" OnRowDataBound="gvListOfIssuedTaxInvoice_RowDataBound" DataSourceID="SqlDataSource1">
"Tax Invoice #" SortExpression="TaxInvoiceNumber">
"TextBox1" runat="server" Text='<%# Bind("TaxInvoiceNumber") %>'>
"Label1" runat="server" Text='<%# Bind("TaxInvoiceNumber") %>'>
"Date" SortExpression="TransactionDate">
"TextBox2" runat="server" Text='<%# Bind("TransactionDate") %>'>
"Label2" runat="server" Text='<%# Bind("TransactionDate") %>'>
"Book #" SortExpression="BookNumber">
"TextBox3" runat="server" Text='<%# Bind("BookNumber") %>'>
"Label3" runat="server" Text='<%# Bind("BookNumber") %>'>
"Customer Name" SortExpression="CustomerName">
"TextBox4" runat="server" Text='<%# Bind("CustomerName") %>'>
"Label4" runat="server" Text='<%# Bind("CustomerName") %>'>
"Province" SortExpression="Province">
"TextBox5" runat="server" Text='<%# Bind("Province") %>'>
"Label5" runat="server" Text='<%# Bind("Province") %>'>
"Net Premium" SortExpression="NetPremium">
"Label1" runat="server" Text='<%# Eval("NetPremium") %>'>
"Label6" runat="server" Text='<%# Bind("NetPremium") %>'>
"VAT" SortExpression="VAT">
"Label2" runat="server" Text='<%# Eval("VAT") %>'>
"Label7" runat="server" Text='<%# Bind("VAT") %>'>
"Registry Fee" SortExpression="RegistryFee">
"Label3" runat="server" Text='<%# Eval("RegistryFee") %>'>
"Label8" runat="server" Text='<%# Bind("RegistryFee") %>'>
"TOTAL">
"lblTOTAL" runat="server" >
"#99CCCC" ForeColor="#003399" />
"#003399" Font-Bold="True" ForeColor="#CCCCFF" />
"#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
"White" ForeColor="#003399" />
"#009999" Font-Bold="True" ForeColor="#CCFF99" />
"#EDF6F6" />
"#0D4AC4" />
"#D6DFDF" />
"#002876" />
protected void gvListOfIssuedTaxInvoice_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
decimal netpremium = Convert.ToDecimal(e.Row.Cells[6].Text);
decimal vat = Convert.ToDecimal(e.Row.Cells[7].Text);
decimal registry = Convert.ToDecimal(e.Row.Cells[8].Text);
Label lblTOTAL = (Label)e.Row.Cells[9].FindControl("lblTOTAL");
decimal sum = netpremium + vat + registry;
lblTOTAL.Text += sum.ToString();
}
}

Nitin Sontakke Thank you so much for all your advices. I really learn a lot from you. I'm just a self taught programmer and though I'm making programs for more than a year now but I still have to work hard on this. I am not a computer graduate but developing a program is what I really like the most. Below is what I did in my question which give me an answer:
SELECT

    h.TaxInvoiceNumber,
    h.TransactionDate,
    h.BookNumber,
    c.CustomerName,
    c.Province,

    sum(d.ConvertedNetPremium) as NetPremium,
    sum(d.ConvertedVAT) as VAT,
    sum(d.ConvertedRegistryFee) as RegistryFee,

    SUM(d.ConvertedNetPremium + d.ConvertedVAT + d.ConvertedRegistryFee) as TOTAL
FROM     dbo.CashierSalesHeader h INNER JOIN
                  dbo.CashierSalesDetails d ON h.TransactionNumber = d.TransactionNumber INNER JOIN
                  dbo.tblCustomers c ON d.CustomerNo = c.CustomerNo
WHERE  (h.TransactionDate BETWEEN '2017-03-17' AND '2017-03-17')
GROUP BY h.TaxInvoiceNumber, h.TransactionDate, h.BookNumber, c.CustomerName, c.Province

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
Try your best to avoid all of this unnecessary processing. Where is data coming from? If it is coming from a data reader (select statement) add a column there itself.
Nitin Sontakke9y ago
So is the issue resolved? If yes, please accept as answer.

See, I also do not have any formal education in computer science. I am a commerce graduate and started my career as data-entry operator. I am in IT only by accident.

There is really no rocket science any business application development. Just keep one thing in mind - "Is there a better way to do this?"
Jes Sie9y ago
Nitin Sontakke Thank you so much for all your advices. I really learn a lot from you. I'm just a self taught programmer and though I'm making programs for more than a year now but I still have to work hard on this. I am not a computer graduate but developing a program is what I really like the most. Below is what I did in my question which give me an answer:
SELECT

    h.TaxInvoiceNumber,
    h.TransactionDate,
    h.BookNumber,
    c.CustomerName,
    c.Province,

    sum(d.ConvertedNetPremium) as NetPremium,
    sum(d.ConvertedVAT) as VAT,
    sum(d.ConvertedRegistryFee) as RegistryFee,

    SUM(d.ConvertedNetPremium + d.ConvertedVAT + d.ConvertedRegistryFee) as TOTAL
FROM     dbo.CashierSalesHeader h INNER JOIN
                  dbo.CashierSalesDetails d ON h.TransactionNumber = d.TransactionNumber INNER JOIN
                  dbo.tblCustomers c ON d.CustomerNo = c.CustomerNo
WHERE  (h.TransactionDate BETWEEN '2017-03-17' AND '2017-03-17')
GROUP BY h.TaxInvoiceNumber, h.TransactionDate, h.BookNumber, c.CustomerName, c.Province
Rafnas T P9y ago
can you put debug and check what value is coming in e.Row.Cells[6].text