Setting FooterText to DataField

[Jeff Reinhardt]

I have a grid that I want to set the footer text to a datafield in datasource the grid is bound to.  How can I do this?

[Cori]

What are you trying to set the FooterText to? A single field or an aggregate of the column?

[Jeff Reinhardt]

Just one of the fields in the data source, no calculations, or aggregate of any kind.

[Princy]

Hello Jeff,

I am not quite sure about your requirement. If you want to set footer text for a column try the following code snippet.

C#:

protected void RadGrid1_ItemDataBound1(object sender, GridItemEventArgs e)
   {
      if (e.Item is GridFooterItem)
       {
           GridFooterItem footerItem = (GridFooterItem)e.Item;
           footerItem["ColumnUniqueName"].Text = "Footer Text"; //setting footer text for column
       }
   }

Thanks,
Princy.

[Jeff Reinhardt]

I know how to simply set the footer text, I can do that as part of the control tag in the HTML markup.   I want to know how to set it so that it has the DATAFIELD value.

IE.   

FooterText = "Cart Total: " + DataSet.Tables[0].Rows[0]["CartTotal"].ToString();   

Or

<

 

telerik:GridBoundColumn DataField="CartTotal"  FooterText="Cart Total: <%#Bind("CartTotal")%>" />

Or something like that so I can get a datafield in the footer text.  I do not want any calculations done,  this is being done in SQL, I want to just display the field in the footer text.

 

[Jeff Reinhardt]

There has to be a way to do this???  Anyone?

[Veli]

Hi Jeff,

As Princy showed, you need to use RadGrid's ItemDataBound event to get the footer cell and set its text. You cannot bind a footer cell text to a data field, because the footer is not databound to a grid record.

Veli
the Telerik team