C# How to display total in database gridview

Question

I have created a database.. i have created a column for "Donations"

in my web form i would like to display the total amount of donations.

how can i do that? and my datatype for "Donation" column is INT

Example: First row is 2000, Second row is 3000

So i want to display the total which is 5000. How can i do that?

Answer 1

Hi Rajveer, Try this code

 

 

Gridview code change like 

 

<asp:GridView ID="gvPurchaseOrderDetail" CssClass="Gridview" HeaderStyle-BackColor="#61A6F8"

HeaderStyle-ForeColor="White" HeaderStyle-Font-Bold="true"

runat="server" ShowFooter="true" AllowPaging="true" PageSize="5" AutoGenerateColumns="false"

OnRowDataBound="gvPurchaseOrderDetail_RowDataBound">

<FooterStyle Font-Bold="true" BackColor="#61A6F8" ForeColor="black" />

<Columns>

<asp:BoundField DataField="Name" HeaderText="Name" />

<asp:TemplateField HeaderText="Donations">

<ItemTemplate>

<asp:Label ID="lblPrice" runat="server" />

</ItemTemplate>

<FooterTemplate>

<asp:Label ID="lblTotal" runat="server" />

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>​

In Code behinde cod like 

 

private void loadGrid()

{

string sqlQry = "select * from tbl_test1";

SqlCommand cmd = new SqlCommand(sqlQry, con);

cmd.CommandType = CommandType.Text;

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

DataSet ds = new DataSet();

sda.Fill(ds);

gvPurchaseOrderDetail.DataSource = ds;

gvPurchaseOrderDetail.DataBind();

}

protected void gvPurchaseOrderDetail_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

Label lblPrice = (Label)e.Row.FindControl("lblPrice");

decimal price = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "donations"));

lblPrice.Text = price.ToString();

total += price;

}

if (e.Row.RowType == DataControlRowType.Footer)

{

Label lblTotal = (Label)e.Row.FindControl("lblTotal");

lblTotal.Text = total.ToString();

}

}

 

protected void Button1_Click(object sender, EventArgs e)

{

SqlCommand cmd = new SqlCommand("Insert into customer(Id, Name, Email, Address, Number, Date, Donation) Values (@Id, @Name, @Email, @Address, @Number, @Date, @Donation)", con);

cmd.Parameters.AddWithValue("@Id", tb1.Text);

cmd.Parameters.AddWithValue("@Name", tb2.Text);

cmd.Parameters.AddWithValue("@Email", tb3.Text);

cmd.Parameters.AddWithValue("@Address", tb4.Text);

cmd.Parameters.AddWithValue("@Number", tb5.Text);

cmd.Parameters.AddWithValue("@Date", Calendar1.SelectedDate.ToShortDateString());

cmd.Parameters.AddWithValue("@Donation", tb7.Text);

cmd.ExecuteNonQuery();

con.Close();

loadGrid();

}

 

Answer 2

Hi Raja, please check my new thread. i hope u will help me thanks :)

Answer 3

Hi Rajveer, Thanks for appreation :). ALL THE BEST.

Answer 4

yes it work thank u so much!!! you are awesome!!!

Answer 5

Hello Rajveer Singh, 

have you tried my code. 

Answer 6

Hi, Please declare variable in global/public accessmodifier "decimal total = 0;"

Answer 7

Hello im having error: Error: The name 'total' does not exist in the current context

Answer 8

Hi, If you useful my answer kindly accept the answer.

Answer 9

Customer.aspx

 

<h3>CUSTOMER DONATIONS</h3>

<p>

<asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource2" ForeColor="#333333" GridLines="None" AllowSorting="True">

<AlternatingRowStyle BackColor="White" />

<Columns>

<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />

<asp:BoundField DataField="Donation" HeaderText="Donation" SortExpression="Donation" />

</Columns>

<EditRowStyle BackColor="#7C6F57" />

<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />

<RowStyle BackColor="#E3EAEB" />

<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />

<SortedAscendingCellStyle BackColor="#F8FAFA" />

<SortedAscendingHeaderStyle BackColor="#246B61" />

<SortedDescendingCellStyle BackColor="#D4DFE1" />

<SortedDescendingHeaderStyle BackColor="#15524A" />

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True" ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Name], [Donation] FROM [Customer]"></asp:SqlDataSource>

</p>

 

 

.cs

 

 

protected void Button1_Click(object sender, EventArgs e)

{

SqlCommand cmd = new SqlCommand("Insert into customer(Id, Name, Email, Address, Number, Date, Donation) Values (@Id, @Name, @Email, @Address, @Number, @Date, @Donation)", con);

cmd.Parameters.AddWithValue("@Id", tb1.Text);

cmd.Parameters.AddWithValue("@Name", tb2.Text);

cmd.Parameters.AddWithValue("@Email", tb3.Text);

cmd.Parameters.AddWithValue("@Address", tb4.Text);

cmd.Parameters.AddWithValue("@Number", tb5.Text);

cmd.Parameters.AddWithValue("@Date", Calendar1.SelectedDate.ToShortDateString());

cmd.Parameters.AddWithValue("@Donation", tb7.Text);

cmd.ExecuteNonQuery();

con.Close();

GridView1.DataBind();

GridView2.DataBind();

Label8.Visible = true;

Label8.Text = "NEW CUSTOMER ADDED";

 

Answer 10

Please checkout url http://weblogs.asp.net/jhallal/displaying-summary-information-sum-or-total-in-the-gridview-s-footer

Answer 11

yes share your code here...

Answer 12

hi i already have the GridView in my project so should i add a Label? do you need to see the code?

Answer 13

Hi Rajveer, try this query "SELECT SUM(donations) as Sum FROM tbl_test1"

Answer 14

i dont understand can u please explain further thanks

Answer 15

Hello,

 

Go through my article-

 

http://www.c-sharpcorner.com/UploadFile/77a82c/add-row-total-in-gridview-footer-in-Asp-Net/

 

 

kindly accept the answer. 

Answer 16

Hello Rajveer,

You can fetch the Sum of Donations column from the SQL query itself like:

 

SELECT SUM(Donations) FROM TABLE_NAME

--IF ANY WHERE COND

GROUP BY Donations

 

I hope this helps

Thanks

Accept if helps anyway 

Answer 17

Read the article carefully and download the code and debug in your system and you will get your answer.