VB.Net Calculating values using GridView bound fields and outputting value to another field

Question

Within a GridView is it possible, using the output of two or more asp BoundFields, to calculate a value and then output this in it's own field?

eg calculating % from two bound fields:

Amount    Total    % (calculated field from Amount / Total * 100)
137       69       50.4

or is it better to generate this calculation using SQL and output the result to it's own BoundField?

I'd probably do it in the SQL for sheer convenience - otherwise you'd be repeating the work by looping through the gridview and calculating for each row. — Tim
– Tim, Commented Apr 10, 2013 at 8:07

Praveen Nambiar · Accepted Answer · 2013-04-10 08:10:34Z

3

Use TemplateField instead of the BoundField

<asp:TemplateField HeaderText="Calculation">
    <ItemTemplate>
        <asp:TextBox ID="tb" runat="server" 
                     Text='<% ((Convert.ToDecimal(Eval("Amount"))/Convert.ToDecimal(Eval("Total")))*Convert.ToDecimal(100)).ToString() %>' >  
        </asp:TextBox>
   </ItemTemplate>
</asp:TemplateField>

answered Apr 10, 2013 at 8:10

Praveen Nambiar

4,9022 gold badges24 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VB.Net Calculating values using GridView bound fields and outputting value to another field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related