or
Grid.ExportSettings.IgnorePaging =
true
;
Grid.ExportSettings.ExportOnlyData =
true
;
Grid.ExportSettings.OpenInNewWindow =
true
;
Grid.ExportSettings.FileName =
"filename"
;
Grid.MasterTableView.ExportToExcel();
Grid.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
<telerik:RadGrid
ShowGroupPanel =
"false"
AutoGenerateColumns =
"false"
ID =
"Grid"
AllowFilteringByColumn =
"False"
AllowSorting =
"False"
ShowFooter =
"True"
runat =
"server"
GridLines =
"Both"
AllowPaging =
"false"
EnableLinqExpressions =
"false"
CssClass =
"RadGridCustomClass"
OnPreRender =
"Grid_PreRender"
OnExcelMLExportRowCreated=
"Grid_ExcelMLExportRowCreated"
OnGridExporting =
"Grid_GridExporting"
OnExcelMLExportStylesCreated=
"Grid_ExcelMLExportStylesCreated"
OnItemDataBound =
"Grid_ItemDataBound"
>
<PagerStyle Mode=
"NextPrevAndNumeric"
/>
<MasterTableView
ShowGroupFooter =
"true"
HeaderStyle-Font-Bold =
"true"
HeaderStyle-ForeColor =
"#333333"
AllowMultiColumnSorting =
"false"
>
<Columns>
<telerik:GridBoundColumn
DataField =
"SubCategory"
ItemStyle-HorizontalAlign =
"Center"
UniqueName =
"REP013_FuellingCategoryHeaderText"
FooterStyle-HorizontalAlign =
"Center"
FooterStyle-Font-Bold =
"true"
HeaderStyle-HorizontalAlign =
"Center"
>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn
Aggregate =
"Sum"
DataField =
"Total_Fuel_Litres"
DataType =
"System.Int32"
UniqueName =
"REP013_TotalFuelHeaderText"
DataFormatString =
"{0:###,###.##}"
ItemStyle-HorizontalAlign =
"Center"
FooterStyle-HorizontalAlign =
"Center"
FooterStyle-Font-Bold =
"true"
HeaderStyle-HorizontalAlign =
"Center"
FooterText =
"<%$ Resources:MyGlobals, REP013_TotalFuelFooterText%>"
>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn
Aggregate =
"Avg"
DataField =
"Bio_Content"
DataFormatString =
"{0:0.0%}"
UniqueName =
"REP013_BioContentHeaderText"
ItemStyle-HorizontalAlign =
"Center"
FooterStyle-HorizontalAlign =
"Center"
FooterStyle-Font-Bold =
"true"
HeaderStyle-HorizontalAlign =
"Center"
>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn
Aggregate =
"Sum"
DataField =
"Bio_Diesel_Litres"
DataFormatString =
"{0:###,###}"
UniqueName =
"REP013_BioDieselHeaderText"
ItemStyle-HorizontalAlign =
"Center"
FooterStyle-HorizontalAlign =
"Center"
FooterStyle-Font-Bold =
"true"
HeaderStyle-HorizontalAlign =
"Center"
FooterText =
"<%$ Resources:MyGlobals, REP013_BioDieselFooterText%>"
>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn
Aggregate =
"Sum"
DataField =
"Standard_Diesel_Litres"
DataFormatString =
"{0:###,###}"
UniqueName =
"REP013_StandardDieselHeaderText"
ItemStyle-HorizontalAlign =
"Center"
FooterStyle-HorizontalAlign =
"Center"
FooterStyle-Font-Bold =
"true"
HeaderStyle-HorizontalAlign =
"Center"
FooterText =
"<%$ Resources:MyGlobals, REP013_StandardDieselFooterText%>"
>
</telerik:GridBoundColumn>
<telerik:GridBoundColumn
Aggregate =
"Sum"
DataField =
"CO2_Tonnes"
DataFormatString =
"{0:###,##0.0}"
UniqueName =
"REP013_CO2QuantityHeaderText"
ItemStyle-HorizontalAlign =
"Center"
FooterStyle-HorizontalAlign =
"Center"
FooterStyle-Font-Bold =
"true"
HeaderStyle-HorizontalAlign =
"Center"
FooterText =
"<%$ Resources:MyGlobals, REP013_CO2QuantityFooterText%>"
>
</telerik:GridBoundColumn>
</Columns>
<GroupByExpressions>
<telerik:GridGroupByExpression>
<SelectFields>
<telerik:GridGroupByField FieldName=
"Category"
/>
</SelectFields>
<GroupByFields>
<telerik:GridGroupByField FieldName=
"Category"
SortOrder=
"Ascending"
/>
</GroupByFields>
</telerik:GridGroupByExpression>
</GroupByExpressions>
</MasterTableView>
<ClientSettings AllowDragToGroup =
"false"
/>
<GroupingSettings ShowUnGroupButton =
"false"
/>
</telerik:RadGrid>
<
telerik:RadListView
ID
=
"RadListView1"
runat
=
"server"
AllowPaging
=
"True"
ItemPlaceholderID
=
"PlaceHolder1"
Skin
=
"listview_2"
EnableEmbeddedSkins
=
"false"
OnItemDataBound
=
"RadListView1_ItemDataBound"
AllowCustomPaging
=
"true"
DataKeyNames
=
"id,filenameextension,typeAbbr,title,fidTimeOfDay"
OnNeedDataSource
=
"RadListView1_NeedDataSource"
OnPageIndexChanged
=
"RadListView1_PageIndexChanged"
OnPageSizeChanged
=
"RadListView1_PageSizeChanged"
>
<
LayoutTemplate
>
<
div
class
=
"RadListView RadListViewFloated RadListView_Windows7"
>
<
telerik:RadDataPager
ID
=
"RadDataPager1"
runat
=
"server"
PageSize
=
"25"
PagedControlID
=
"RadListView1"
BorderWidth
=
"0"
OnFieldCreated
=
"RadDataPager1_FieldCreated"
CssClass
=
"dataPagerClass"
>
<
Fields
>
<
telerik:RadDataPagerButtonField
FieldType
=
"FirstPrev"
/>
<
telerik:RadDataPagerButtonField
FieldType
=
"Numeric"
PageButtonCount
=
"5"
/>
<
telerik:RadDataPagerButtonField
FieldType
=
"NextLast"
/>
<
telerik:RadDataPagerPageSizeField
PageSizeText
=
"Page size: "
/>
<
telerik:RadDataPagerGoToPageField
CurrentPageText
=
"Page: "
TotalPageText
=
"of"
SubmitButtonText
=
"Go"
TextBoxWidth
=
"15"
/>
<
telerik:RadDataPagerTemplatePageField
>
<
PagerTemplate
>
<
b
>Total Number of Assets Found:
<
asp:Label
runat
=
"server"
ID
=
"TotalItemsLabel"
Text="<%# Container.Owner.TotalRowCount%>" />
</
b
>
</
PagerTemplate
>
</
telerik:RadDataPagerTemplatePageField
>
</
Fields
>
</
telerik:RadDataPager
>
<
asp:PlaceHolder
ID
=
"PlaceHolder1"
runat
=
"server"
/>
</
div
>
</
LayoutTemplate
>
<
ItemTemplate
>
<
div
style
=
"float: left; width: 162px; height: 200px; background-color: White;"
>
<
asp:Panel
ID
=
"myThumb"
runat
=
"server"
CssClass
=
"myClass"
Style
=
"border: 0; white-space: normal; padding: 5px 4px 25px 2px; text-align: center; width: 160px; background-color: white; margin-left: 2px;"
>
<
div
style
=
"width: 150px; height: 150px; margin-left: 2px;"
>
<
asp:HyperLink
ID
=
"HyperLink1"
runat
=
"server"
>
<
telerik:RadBinaryImage
ID
=
"RadBinaryImage1"
runat
=
"server"
AutoAdjustImageControlSize
=
"false"
CssClass
=
"myClass"
ImageUrl='<%# Eval("thumbUrl") %>' AlternateText="Click to view preview"
ToolTip="Click to view preview" />
</
asp:HyperLink
><
br
/>
</
div
>
<
asp:CheckBox
ID
=
"ChkImage"
runat
=
"server"
Style
=
"float: left; padding-top: 5px"
/><
small
><
asp:HyperLink
ID
=
"lnkAsset1"
runat
=
"server"
Visible
=
"false"
Style
=
"float: left; padding-top: 5px; text-decoration: none; font-weight: normal; font-size: 7pt;"
>
</
asp:HyperLink
><
asp:HyperLink
ID
=
"lnkAsset2"
runat
=
"server"
Style
=
"float: left; text-decoration: none; font-weight: normal; font-size: 7pt;"
>
</
asp:HyperLink
><
asp:HyperLink
ID
=
"lnkAsset3"
runat
=
"server"
Style
=
"float: left; padding-left: 20px; text-decoration: none; font-weight: normal; font-size: 7pt;"
></
asp:HyperLink
></
small
><
br
/>
<
asp:HiddenField
ID
=
"hiddenAssetId"
Value='<%# Eval("id") %>' runat="server" />
</
asp:Panel
>
</
div
>
</
ItemTemplate
>
<
EmptyDataTemplate
>
No Assets Found
</
EmptyDataTemplate
>
</
telerik:RadListView
>
<
telerik:RadListView
ID
=
"RadListView1"
runat
=
"server"
Width
=
"100%"
AllowPaging
=
"true"
ItemPlaceholderID
=
"StylesHolder"
DataKeyNames
=
"StyleNumber"
OnPageIndexChanged
=
"RadListView1_PageIndexChanged"
>
<
LayoutTemplate
>
<
fieldset
style
=
"width: 100%; border: none;"
id
=
"FieldSet1"
>
<
asp:Panel
ID
=
"StylesHolder"
runat
=
"server"
>
</
asp:Panel
>
</
fieldset
>
</
LayoutTemplate
>
<
ItemTemplate
>
<
div
class
=
"grid_3 SearchResults_Container"
>
<
a
href
=
"#"
onclick
=
"DetailClick('<%# Eval("
StyleNumber") %>')">
<%-- This div is necessary in that 'relative' is required in a div before 'absolute' is used in next dic --%>
<
div
class
=
"SearchResults_ImageContainer"
>
<%-- This div forces image to be vertical-aligned at bottom, just above text, but centered. --%>
<
div
class
=
"SearchResults_ImageAlignment"
>
<%# GetStylePrimaryImage(Eval("StyleNumber") as string) %>
</
div
>
</
div
>
<%# Eval("StyleNumber") %><
br
/>
<%# Eval("ProductName") %>
</
a
>
</
div
>
</
ItemTemplate
>
</
telerik:RadListView
>
radListView.DataSource = GetDataTable(strCollectionID, strCollectionName, strDesignerID, strDesignerName, strProductTypeID, strProductTypeName, strRoomID, strRoomName, strSearch);
radListView.DataBind();
...
public
DataTable GetDataTable(
string
strCollectionID,
string
strCollectionName,
string
strDesignerID,
string
strDesignerName,
string
strProductTypeID,
string
strProductTypeName,
string
strRoomID,
string
strRoomName,
string
strSearch)
{
DataTable dt =
new
DataTable();
(Put some stuff
in
the table)
return
dt;
}