how to caluclate the totals in the footer row of the Rad Grid

2 posts, 0 answers
  1. sumanth
    sumanth avatar
    11 posts
    Member since:
    Feb 2009

    Posted 09 Mar 2009 Link to this post

    Hi
    I am Working on Rad Grid
    I am bale to caluclate the numarical(int) values totals in footter 
    BUT Problem araised in Money Datatype Coloumn
    When i trying to caluclate the total for money datatype coloumn
    It is dispalying the  all coloumn values in footter(not the SUM Values)
    Plz help out to solve the problem
    Thanks in advance

    here is my C# Code

    using System;
    using System.Data;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    using System.Data.SqlClient;
    using Telerik.Web.UI;

    namespace ajaxKrunchBox
    {
        public partial class _Default : System.Web.UI.Page
        {
            protected void Page_Load(object sender, EventArgs e)
            {
               
            }

        
            protected void Button1_Click(object sender, EventArgs e)
            {

                Session["weekend"] = TextBox1.Text;
                Session["status"] = DropDownList4.Text;
                SqlCommand cmd = new SqlCommand("usp_CustomerPerformance_V2", new SqlConnection("Data Source=vijay;Initial Catalog=ULTIMATE_NEW;Integrated Security=True"));
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@Customer", DropDownList1.Text));
                cmd.Parameters.Add(new SqlParameter("@WeekEnding", TextBox1.Text));
                cmd.Parameters.Add(new SqlParameter("@Status", DropDownList4.Text));
                cmd.Parameters.Add(new SqlParameter("@noOfWks", DropDownList3.Text));
                cmd.Connection.Open();
                RadGrid1.DataSourceID = null;
                RadGrid1.DataSource = cmd.ExecuteReader();
                //Session["variable1"] = DropDownList1.Text;
                Session["varibale2"] = TextBox1.Text;
                Session["varibale4"] = DropDownList4;
                Session["varibale3"] = DropDownList3;
                RadGrid1.DataBind();
                RadGrid1.Visible = true;
               
              
                cmd.Connection.Close();
                cmd.Connection.Dispose();
              
            }

            int total1;
            int total2;
            int total3;
            int total4;
            int total5;
            int total6;
            String  total7;
            String total8;
            int total9;
            int total10;
             protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
            {
                if (e.Item is GridDataItem)
                {
                    GridDataItem dataItem = e.Item as GridDataItem;
                    int fieldValue1 = int.Parse(dataItem["TYWkSales"].Text);
                    total1 += fieldValue1;
                    int fieldvalue2 = int.Parse(dataItem["LYWkSales"].Text);
                    total2 += fieldvalue2;
                    int fieldvalue3 = int.Parse(dataItem["TYL4WkSales"].Text);
                    total3 += fieldvalue3;
                    int fieldvalue4 = int.Parse(dataItem["LYL4WkSales"].Text);
                    total4 += fieldvalue4;
                    //int fieldvalue5 = int.Parse(dataItem["TYWkRRP"].Text);
                    //total5 += fieldvalue5;
                    //int fieldvalue6 = int.Parse(dataItem["LYWkRRP"].Text);
                    //total6 += fieldvalue6;
                    String fieldvalue7 = String.Format(dataItem["TYL4WkRRP"].Text);
                    total7 += fieldvalue7;
                    mydatatable
                    //String fieldvalue8 = String.Format(dataItem["LYL4WkRRP"].Text);
                    //total8 += fieldvalue8;
                   
                    int fieldvalue9 = int.Parse(dataItem["TYWkSOH"].Text);
                    total9 += fieldvalue9;
                    int fieldvalue10 = int.Parse(dataItem["LYWkSOH"].Text);
                    total10 += fieldvalue10;
                  
                }
                if (e.Item is GridFooterItem)
                {
                    GridFooterItem footerItem = e.Item as GridFooterItem;
                    footerItem["TYWkSales"].Text = "Total Units: " + total1.ToString();
                    footerItem["LYWkSales"].Text = "Total Units: " + total2.ToString();
                    footerItem["TYL4WkSales"].Text = "Total Units: " + total3.ToString();
                    footerItem["LYL4WkSales"].Text = "Total Units: " + total4.ToString();
                    //footerItem["TYWkRRP"].Text = "Total Price: " + total5.ToString();
                    //footerItem["LYWkRRP"].Text = "Total Price: " + total6.ToString();
                    footerItem["TYL4WkRRP"].Text = "Total Price: " + total7;
                    footerItem["LYL4WkRRP"].Text = "Total Price: " + total8;
                    footerItem["TYWkSOH"].Text = "Total Units: " + total9.ToString();
                    footerItem["LYWkSOH"].Text = "Total Units: " + total10.ToString();
                }

               

                }
          
           

          

          

        }
    }

  2. Yavor
    Admin
    Yavor avatar
    11 posts

    Posted 09 Mar 2009 Link to this post

    Hello sumanth,

    The following example demonstrates one possible approach.
    I hope it gets you started properly.

    Kind regards,
    Yavor
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top