want sum of several columns in gridview

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

C#

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>View Docket Values </title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView runat="server" ID="gvrecords"  AutoGenerateColumns="false"
HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White" DataKeyNames="DocketNo" Width="80px">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<a href ='<%#"UpdateDocket.aspx?DocketNo="+DataBinder.Eval(Container.DataItem,"DocketNo") %>'> <%#Eval("DocketNo") %>  </a>
</ItemTemplate>
</asp:TemplateField>
    <asp:BoundField DataField="ConsignorName" HeaderText="Consigner" />
    <asp:BoundField DataField="ConsigneeName" HeaderText="Consignee" />
    <asp:BoundField DataField="Date" HeaderText="Booking Date" />
    <asp:BoundField DataField="FromSTN" HeaderText="Booking Station" />
    <asp:BoundField DataField="ToStn" HeaderText="Delivery Station" />
    <asp:BoundField DataField="PKG" HeaderText="No. of Packets" />
    <asp:BoundField DataField="ActualWt" HeaderText="Actual Weight" />
    <asp:BoundField DataField="ChargeWt" HeaderText="Charge Weight" />
    <asp:BoundField DataField="InvoiceValue" HeaderText="Invoice Value" />
    <asp:BoundField DataField="Basis" HeaderText="Basis" />
    <asp:BoundField DataField="FreightCharge" HeaderText="Freight Charge" />
    <asp:BoundField DataField="FuelSurcharge" HeaderText="Fuel Surcharge" />
    <asp:BoundField DataField="FOV" HeaderText="FOV" />
    <asp:BoundField DataField="COD" HeaderText="COD" />
    <asp:BoundField DataField="FOD" HeaderText="FOD" />
    <asp:BoundField DataField="PickupCharge" HeaderText="Pickup Charge" />
    <asp:BoundField DataField="DoorDelivery" HeaderText="Door Delivery" />
    <asp:BoundField DataField="Handling" HeaderText="Handling" />
    <asp:BoundField DataField="Misc" HeaderText="Misc" />
    <asp:BoundField DataField="DktCharge" HeaderText="Docket Charge" />
    <asp:BoundField DataField="SubTotal" HeaderText="Sub Total" />
    <asp:BoundField DataField="ServiceTax" HeaderText="Service Tax" />
    <asp:BoundField DataField="GrandTotal" HeaderText="Grand Total" />
    <asp:BoundField DataField="Service" HeaderText="Service" />
</Columns>
</asp:GridView>

and the C# Code is

C#

public partial class Docket : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridview();
        }
    }
    protected void BindGridview()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString);
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from Docket", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        cmd.ExecuteNonQuery();
        con.Close();
        DataSet ds = new DataSet();
        da.Fill(ds);
        gvrecords.DataSource = ds;
        gvrecords.DataBind();
    }

}

In this case I want the sum of Actual_Wt,FreightCharge,FuelSurcharge,FOD,FOV,COD,DocketCharge in the end of the gridview is there any possible way

Posted 6-Mar-15 18:51pm

Member 11111143

Updated 6-Mar-15 19:03pm

King Fisher

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2015-03-06T18:57:00

Solution 1

Refer: Displaying Total in Footer of GridView and also Add Sum of columns(row vise) in last Column[^]

Posted 6-Mar-15 18:57pm

Peter Leow

Comments

Member 11111143 7-Mar-15 1:04am

ok i will work on this to see that this works well for me to. I have one more question on this is I want to put 2 text boxes which shows me two date which will show data between these two dates.Is there any possible way please suggest

Member 11111143 7-Mar-15 1:50am

I have one more question on this is I want to put 2 text boxes which shows me two date which will show data between these two dates.Is there any possible way please suggest

Peter Leow 7-Mar-15 2:04am

Yes, retrieve database records using a query like this:
select * from tablename where datecolumn between date_from_textbox1 AND date_from_textbox2
then populate the gridview.

Member 11111143 7-Mar-15 2:10am

I will take A button ok,put this code in it
(select * from tablename where datecolumn between date_from_textbox1 AND date_from_textbox2)I understood this then(then populate the gridview.)how to do this I am not understanding

Peter Leow 7-Mar-15 2:17am

Post it as new question.

Member 11111143 7-Mar-15 2:55am

peter I have posted my Question with the name of "Showing data between two dates in gridview" Please tell me A solution which could work

King Fisher · Answer 2 · 2015-03-06T19:07:00

Solution 2

Grid view Footer Total instead of calculating in Rowdatabound .

http://techblog.turultechnologies.com/how-to-display-gridview-footer-total-in-asp-net/[^]

Posted 6-Mar-15 19:07pm

King Fisher

Updated 6-Mar-15 19:11pm

v2

Rajesh waran · Answer 3 · 2015-03-06T19:08:00

Solution 3

Another way to handle it, Just add following code before binding Gridview.
And also you should use to add show footer="true" in Gridview.

C#

DataSet ds = new DataSet();
da.Fill(ds);
 gvrecords.Columns[7].FooterText = (from row in dt.AsEnumerable()
                                                        select row.Field<double>("ActualWt")).Skip(gvrecords.PageIndex * gvrecords.PageSize).Take(gvrecords.PageSize).Sum().ToString("C", culmoney).Remove(0, 2).Trim();

gvrecords.DataSource = ds;
gvrecords.DataBind();
</double>

In your Html Page Make these Changes, Just Add Show footer as True

C#

<asp:GridView runat="server" ID="gvrecords" AutoGenerateColumns="false" ShowFooter="true" HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White" DataKeyNames="DocketNo" Width="80px">

Posted 6-Mar-15 19:08pm

Rajesh waran

Updated 6-Mar-15 19:26pm

v4

Comments

Member 11111143 7-Mar-15 1:19am

how to make footer true When I am trying it is not accepting

Rajesh waran 7-Mar-15 1:23am

In your Html page make this changes, Add ShowFooter="true" here,
<asp:GridView runat="server" ID="gvrecords" AutoGenerateColumns="false" ShowFooter="true" HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White" DataKeyNames="DocketNo" Width="80px">

Member 11111143 7-Mar-15 1:27am

thanks U very much, I thinks a just forget it.

Rajesh waran 7-Mar-15 1:33am

If you got solution from me, just accecpt the answer as solution in order to remove this question from unanswered queue.

Rajesh waran 7-Mar-15 1:26am

Now i have updated my solution, Check it out.

Member 11111143 7-Mar-15 1:43am

I did it like this
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridview();
}
}
protected void BindGridview()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("select * from Docket", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
con.Close();
DataSet ds = new DataSet();
da.Fill(ds);
gvrecords.DataSource = ds;
gvrecords.DataBind();
DataSet ds = new DataSet();
da.Fill(ds);
gvrecords.Columns[7].FooterText = (from row in dt.AsEnumerable() select row.Field<double>("ActualWt")).Skip(gvrecords.PageIndex * gvrecords.PageSize).Take(gvrecords.PageSize).Sum().ToString("C", culmoney).Remove(0, 2).Trim();
gvrecords.DataSource = ds;
gvrecords.DataBind();

}

Error List

Error 4 ; expected 38 6
Error 3 Invalid expression term '}' 38 5
Error 1 Invalid expression term '<' 37 9
Error 2 Invalid expression term 'double' 37 17
What shall I do now

Rajesh waran 7-Mar-15 1:49am

Please Check your column 7 is ActualWt or not? and also to have to cast it in your correct format. So check that ActualWt datatype is float or double or int etc.,
select row.Field<double>, Here you have to change your datatype. If your column is in int, change field to int.