or
protected override void OnInit(EventArgs e) {
radGrid = new RadGrid();radGrid.ID = "myGrid";radGrid.NeedDataSource += new GridNeedDataSourceEventHandler(_grid_NeedDataSource);
radGrid.MasterTableView.AllowFilteringByColumn = true;radGrid.MasterTableView.EnableHeaderContextFilterMenu = true;radGrid.Skin = "Windows7"; radGrid.EnableEmbeddedSkins = true; radGrid.Width = Unit.Percentage(100);
radGrid_AddColumnsToGrid();
}
<
telerik:RadToolBarButton
Text
=
"Excel"
ImageUrl
=
"~/Images/excel.png"
CommandName
=
"ExportToExcel"
Value
=
"Export"
/>
if (!Page.IsPostBack)
{
rgMyGrid.ExportSettings.ExportOnlyData = true;
rgMyGrid.MasterTableView.UseAllDataFields = true;
rgMyGrid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
rgMyGrid.ExportSettings.IgnorePaging = true;
rgMyGrid.ExportSettings.FileName = "CropList";
rgMyGrid.ExportSettings.OpenInNewWindow = true;
}
protected void rtbCommand_ButtonClick(object sender, RadToolBarEventArgs e)
{
if (e.Item.Value == "Export")
{
ExportGrid();
}
}
protected void ExportGrid()
{
rgMyGrid.ExportSettings.ExportOnlyData = true;
rgMyGrid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
rgMyGrid.ExportSettings.IgnorePaging = true;
rgMyGrid.ExportSettings.FileName = "CropList";
rgMyGrid.ExportSettings.OpenInNewWindow = true;
rgMyGrid.MasterTableView.ExportToExcel();
}
RadHtmlChart1.PlotArea.XAxis.DataLabelsField = "PriorityID"