RunningBalance in Columns of Gridview in ASP.NET Webforms C#

Jes Sie

10y2.2k.NET

Hi! I created a Cash Book webform application in C#. In the columns Debit, Credit and Balance, I want to get the running balance from Debit and Credit columns.

I'm using a TemplateField. Here's what I started but still no luck. Hope someone can help me.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataRowView dtview = e.Row.DataItem as DataRowView;
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label Debit = (Label)e.Row.FindControl("lblDebit");
GetDebit += GetDebit + Convert.ToDecimal(Debit.Text);
Label Credit = (Label)e.Row.FindControl("lblCredit");
GetCredit += GetCredit + Convert.ToDecimal(Credit.Text);
Label Balance = (Label)e.Row.FindControl("lblBalanceForwared");
GetBalance += GetBalance + Convert.ToDecimal(Balance.Text) + GetBalance- GetCredit;
}
}

Another thing, I am just a neophyte in programming. Thanks in advance.

2 Replies

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

Jes Sie10y ago
@Santhakumar Munuswamy, Thank you for your suggestion but I don't want the running balance to be at the footer. This is a cash book and the running balance should in line with the transactions made. Please try to solve my problem. Thanks a lot.
Santhakumar Munuswamy10y ago
Hi,
you can try this code
Add footer template to Gridview control like
"Balance">
"lblBalance"runat="server"Text='<%#Bind("Balance")%>'CssClass="lblStyle">
"server"ID="lblTotalBalance">

Similarly, you can add Debit and Credit columns on Gridview control in aspx page
Add logic code to Gridview_RowDatabound event like
privatefloatTotalBalanceAmount=0;
protectedvoidgvItemDetails_RowDataBound(objectsender,GridViewRowEventArgse)
{
if(e.Row.RowType==DataControlRowType.DataRow)
{
LabellblBalance=(Label)e.Row.FindControl("lblBalance");
if(lblBalance!=null)
{
if(lblBalance.Text!="")
{
TotalBalanceAmount+=Convert.ToSingle(lblBalance.Text.Trim());
}
}
}
if(e.Row.RowType==DataControlRowType.Footer)
{
e.Row.Cells[6].Text=TotalBalanceAmount.ToString().Trim();
}
}
Similarly, you can add Total balance of Debit and Credit columns