Can you do a calculation on a Grid View?

Question

1.00/5 (1 vote)

See more:

I have a GridView that has bound data on it. I have three columns. Two has data but the third has no data. I am trying to do a calculation that will calculate column A if column B is 1 or 2 and put the answer in column C.

Example:

HTML

Column A      Column B     Column C
500            168            03
500            120            04

Is there a way of doing it that way?

Posted 2-Feb-15 9:36am

Computer Wiz99

Updated 2-Feb-15 9:44am

Sergey Alexandrovich Kryukov

v2

Add a Solution

Comments

ZurdoDev 2-Feb-15 15:50pm

I'd suggest doing it in Sql.

Computer Wiz99 2-Feb-15 16:05pm

Okay, Thanks.

TheKarateKid 2-Feb-15 16:44pm

As RyanDev suggested we do it on SQL server side in Stored Procedures, if there are tens of thousands of records. But I might do it DTOs or Entities by adding calculated readonly properties or GridView's RowDataBound. For example if you I want to display running total in the footer of each gridview page.

1 solution

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)

Gideon van Dyk · Answer 1 · 2015-02-02T18:14:00

You could do it, but you will need to ensure that you have a dummy column defined in your SQL that will add the column name you want to put your calculation result in:

SQL

select *, null 'Column C' from ....

This will allow your datasource to bind because the columns will exist to store the result in.

You then perform a RowDataBound event on the GridView that should be something like this:

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    DataRow rowView = (DataRow)e.Row.DataItem;
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        // perform your calculation;
        int value = Convert.ToInt32(rowView["Column A"]) * Convert.ToInt32(rowView["Column B"]);
        e.Row.Cells[e.Row.Cells.Count - 1].Text = value.ToString();
    }
}