How to sum the first cell value with second cell value in the same column and display result in another column in gridview

Question

2.00/5 (1 vote)

See more:

I have a gridview in asp.net with backend sql. I need to add the first cell value with the second cell value in the same column and display result in next column.
Eg: sql table:
NO Item TYPE QTY

1 glass Transfer 2
2 glass Invoice -1
3 glass Transfer 4

and I need to display the result as

NO Item TYPE QTY Balance

1 glass Transfer 2 2
2 pen Invoice -1 1
3 glass Transfer 4 5

I need to add the 4th column first cell with 2nd cell and display result in 5th column.
Pls help.

Posted 4-Jul-15 21:58pm

Member 11357862

Updated 4-Jul-15 22:00pm

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 5-Jul-15 6:26am

What have you tried?

Suvendu Shekhar Giri 5-Jul-15 14:30pm

What do you mean by Cell and Column ? Looks very confusing. Do you mean "Row" when you are saying "cell"?

barneyman 5-Jul-15 23:25pm

sounds like you need to add a 'balance' column to the sql query you're populating the gridview with

Member 11357862 6-Jul-15 1:57am

Yes, I need to add the balance column like I shown in the example table 2

Member 11357862 6-Jul-15 2:57am

I have tried lag function, but its not working in sqlserver 2008

Member 11357862 6-Jul-15 5:11am

I have tried this code in asp.net grid view row databound event.

double tot=0;
if (e.Row.RowType == DataControlRowType.DataRow)
{
total = total + Convert.ToDouble(GridView1.Rows[1].Cells[6].Text);
GridView1.Rows[1].Cells[7].Text = total.ToString();
}

but it shows error.

Uzzal Kanti Barua 21-Jul-15 1:13am

variable total is not declared.
instead of row value static 1, use dynamic e.Row.
above code will replace value of cell 6 to 7 only.nothing else.

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)