This is a migrated thread and some comments may be shown as answers.

Telerik grid Calculated column

12 Answers 1338 Views

Grid

This is a migrated thread and some comments may be shown as answers.

12 Answers, 1 is accepted

answered on 07 Oct 2009, 05:59 AM

Please find the code for the Telerik grid.
Even after doing custom paging and custom sorting, I am getting the same error.

Default.aspx
<asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <div>
        <telerik:RadGrid ID="RadGrid1" runat="server" EnableEmbeddedSkins="true" AllowPaging="True"
            AllowSorting="True" PageSize="2" GridLines="None" EnableLinqExpressions="false">
            <MasterTableView AutoGenerateColumns="False" AllowNaturalSort="false">
                <Columns>
                    <telerik:GridBoundColumn HeaderText="Account" UniqueName="AccountNumber" DataField="AccountNumber"
                        AllowSorting="true">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="TotalShares" DataField="TotalShares" HeaderText="Total No. of Shares"
                        DataType="System.Double">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn UniqueName="MarketValue" DataField="MarketValue" HeaderText="Market Value"
                        DataType="System.Double">
                    </telerik:GridBoundColumn>
                    <telerik:GridCalculatedColumn HeaderText="Total Price" DataFields="TotalShares, MarketValue"
                        Expression="{0}*{1}" />
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

Default.aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "RAD prototype";

            List<Account> accList = new List<Account>();
            Account acc = new Account();
            acc.AccountNumber = 123;
            acc.MarketValue = 120.32;
            acc.TotalShares = 100;
            accList.Add(acc);

            Account acc2 = new Account();
            acc2.AccountNumber = 123;
            acc2.MarketValue = 100.1;
            acc2.TotalShares = 12;
            accList.Add(acc2);

            Account acc3 = new Account();
            acc3.AccountNumber = 567;
            acc3.MarketValue = 2003.12;
            acc3.TotalShares = 91;
            accList.Add(acc3);

            Account acc4 = new Account();
            acc4.AccountNumber = 567;
            acc4.MarketValue = 102.3;
            acc4.TotalShares = 43;
            accList.Add(acc4);

            Account acc5 = new Account();
            acc5.AccountNumber = 912;
            acc5.MarketValue = 102.3;
            acc5.TotalShares = 43;
            accList.Add(acc5);

Session["AccountValue"] = accList;

            RadGrid1.DataSource = Session["AccountValue"];
            RadGrid1.DataBind();
        }

Account.cs

public class Account
    {
        private long _accountNumber;
        private double _TotalShares;
        private double _MarketValue;

        public double TotalShares
        {
            get
            {
                return _TotalShares;
            }
            set
            {
                _TotalShares = value;
            }
        }

        public double MarketValue
        {
            get
            {
                return _MarketValue;
            }
            set
            {
                _MarketValue = value;
            }
        }

        public long AccountNumber
        {
            get
            {
                return _accountNumber;
            }
            set
            {
                _accountNumber = value;
            }
        }

    }

answered on 07 Oct 2009, 05:45 PM

Hi Kishan,

But I have noticed that you are using Simple-DataBinding techniques(calling DataBind()). I would suggest you to use AdvanceDataBinding techniques. Try populating the Grid in the NeedDataSource event. Go through the following articles for getting more details about AdvanceDataBinding techniques.
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/needdatasource/defaultcs.aspx
http://www.telerik.com/help/aspnet-ajax/grdadvanceddatabinding.html

Best wishes,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 20 May 2010, 01:09 PM

Hi Nirav,

You can embed any content inside a RadComboBox template, including HTML markup and ASP.NET server controls, as well as other third party controls. Please refer to the following online example which demonstrates how to use the combobox templates:
http://demos.telerik.com/aspnet-ajax/combobox/examples/functionality/templates/defaultcs.aspx

Give it a try and let me know if it works for you.

Best wishes,
Pavlina
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

answered on 16 Jul 2015, 11:25 AM

Example.zip

Hello,

Attached you can find a sample project where one of the columns has null values and the expression you provided is working without error. Give it a try and see what is the difference in your case.

Regards,
Pavlina
Telerik

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items