<rad:GridBoundColumn DataField="FileName" UniqueName="NameColumn" />void ListGrid_EditCommand(object source, GridCommandEventArgs e)<
telerik:GridDateTimeColumn UniqueName="DatePlaced" DataField="DatePlaced" HeaderText="Date Placed"
HeaderStyle-Width="160px" DataFormatString="{0:d}">
</telerik:GridDateTimeColumn>
<telerik:GridDateTimeColumn UniqueName="DateShipped" DataField="DateShipped" HeaderText="Date Shipped"
HeaderStyle-Width="160px" DataFormatString="{0:d}">
</telerik:GridDateTimeColumn>
<telerik:GridTemplateColumn DataField="DaysToShip" HeaderText="Days To Ship" >
<ItemTemplate>
<asp:Label ID="lblDaysToShip" runat="server"></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lblDaysToShipFooter" runat="server"></asp:Label>
</FooterTemplate>
</telerik:GridTemplateColumn>
C# code
double
totalRows, countRows;
protected
void TrackingGrid_ItemDataBound(object source, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
(item.FindControl(
"lblDaysToShip") as Label).Text = DateTime.Parse(item["DateShipped"].Text).Subtract(DateTime.Parse(item["DatePlaced"].Text)).Days.ToString();
totalRows +=
Double.Parse((item.FindControl("lblDaysToShip") as Label).Text);
countRows += 1;
}
if (e.Item is GridFooterItem)
{
GridFooterItem footerItem = e.Item as GridFooterItem;
(footerItem.FindControl(
"lblDaysToShipFooter") as Label).Text = "Average days: " + (totalRows / countRows).ToString("N2");
}
}
Thanks for your help
Greg
RadGrid1.MasterTableView.ExportToExcel()RadGrid1.ExportSettings.Excel.FileExtension = "xlsx"Panel edpanelContent = new Panel();edpanelContent.Attributes.Add("class", "popupcontent");RadDatePicker eddp = new RadDatePicker();eddp.ID = "dp_ENDDATE";eddp.DateInput.Attributes["onclick"] = String.Format("showPopUp('{0}');", eddp.ClientID);edpanelContent.Controls.Add(eddp);