Sum of 2 fields in repeater

Hi Ramco,

You can use ItemDataBound event to calculate sum in another column and footer,

   int total = 0;
   
   protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        
       //using findcontrol method the label and get the Recieved and issued sum
       int sumOfTwocolumn = Convert.ToInt32(((Label)e.Item.FindControl("lblRecieved")).Text) - 
                     Convert.ToInt32(((Label)e.Item.FindControl("lblissued")).Text);

       //Set Values to another column Label
       ((Label)e.Item.FindControl("lblNewLableFoSum")).Text = Convert.ToString(sumOfTwocolumn);
   
        if (e.Item.ItemType == ListItemType.Footer)
        {
            Label lbl = (Label)e.Item.FindControl("Label1");
            lbl.Text = total.toString(); //set value in footer
        }
    }