Adding columns value

Carlos kambui

11y1.1kVisual Basic .NET

How to add sum of row in c# displaying total in textbox

11 Replies

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

Nanhe Siddique11y ago
is your problem solve or not

for (int col = 0; 6 < dgFeesstructure.Columns.Count; col++)

put col inplace of 6

Mark Aceept Answer if my effort help you
Carlos kambui11y ago
private void sbalance()
{
int total = 0;
for (int i = 0; i < dgFeesstructure.Rows.Count; i++)
{
for (int col = 0; 6 < dgFeesstructure.Columns.Count; col++)
total += Convert.ToInt32(dgFeesstructure.Rows[i].Cells[6].Value);
txtTotalTotalAmountpaid.Text = total.ToString();
}
}
redundancy of highlighted column is the problem thanks all for your assistance
Shuvojit Halder11y ago
Your two method is correct. First you should check this method will be placed after generate the gridview. and also check the cell no which you have use.
Nanhe Siddique11y ago
1. may be the problem is on click-events...
check the following way..
->goto design of the form
->select the the button which is not working
->goto properties of that button and select the events
->goto click event check the proper event is attached to that button or not..
->if there is no event or wrong event then select the correct button event..
ex:
"button 1"->it must have the click event like button1_Click(object sender, EventArgs e)
2.

Check you have the events wired up in the designer.
Look at each button in turn, and double click it. Does it go to a new method, or one of the existing ones?
If all buttons go to the existing methods, then put a breakpoint on the first line of each, then run your program. Does each button hit a breakpoint? If not, then you need to look at what is disconnecting the event handlers. If it does, then single step though to find out why it doesn't seem to be doing what you think it should.
BTW: It is a bad idea to keep the VS default names - when you create a control, give it a name which reflects what the user is going to do with it: that way your code is more self documenting, and easier to follow. "button2_Click" is a lot less clear than "butNormalizeChromatics_Click" or whatever you code is actually doing.
And if you post code fragments again, make it just the relevant bits, not your whole program, and don't post redundant, commented out old rubbish. Help us to help you by making it as clear as you can.
3.

there is no any clearance of code error so you may have to try this....

if you getting no response with successful debugging of your code then just close your app and restart your computer after it if again no any response then put the break points on your button click events and run your app it will definitely give response

it may help you
Carlos kambui11y ago
have created to class ant then call them on form load
sbalance();
tpaid();
private void sbalance()
{
int total = 0;
for (int i = 0; i < dgFeesstructure.Rows.Count; i++)
{
for (int col = 0; 6 < dgFeesstructure.Columns.Count; col++)
total += Convert.ToInt32(dgFeesstructure.Rows[i].Cells[6].Value);
txtTotalTotalAmountpaid.Text = total.ToString();
}
}
private void tpaid()
{
int sum = 0;
for (int i = 0; i < dgFeesstructure.Rows.Count; ++i)
{
sum += Convert.ToInt32(dgFeesstructure.Rows[i].Cells[1].Value);
}
txtTotalbalance.Text = sum.ToString();
}
Nanhe Siddique11y ago
what you have written in form load show me.
Carlos kambui11y ago
i kindly help when i add codes to my project on form load after clicking button no response when i delete the codes it work what could be the problem
Nanhe Siddique11y ago
read this link

http://www.codeproject.com/Articles/12979/SumColumn-Custom-DataGrid-Column-that-automaticall

http://www.beansoftware.com/ASP.NET-Tutorials/Total-GridView-Footer.aspx

or
on rowdatabound event write following code

Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, _
ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound

myTotal += CDbl(e.Item.Cells(2).Text)
'Format the data, and then align the text of each cell to the right.
'Use the footer to display the summary row.
e.Item.Cells(1).Text = "Total Sales"
e.Item.Cells(1).Attributes.Add("align", "left")
e.Item.Cells(2).Attributes.Add("align", "right")
e.Item.Cells(2).Text = myTotal.ToString("c")
End Select
End Sub

it may help you

Mark Accept Answer if it help you

it may help you

Shuvojit Halder11y ago

You can do this,,

int sum = 0;

for (int i = 0; i < dataGridView1.Rows.Count; ++i)

 {     sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value);

TextBox1.text = sum.ToString();

Carlos kambui11y ago
i have a datagrid with columns i.e Amount_paid Client_name and i want to have the total amount for Amount_paid displayed o textbox
Nanhe Siddique11y ago
explain more your questions