Hi, I have master child grid and export functionality in both parent as well as child grid.
I do data binding in code behind. Export from the parent grid works fine but when user clicks on Export to Excel in child grid, it throws following exception.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Stack Trace:
My ASPX template is:
<telerik:RadGrid ID="RGModels" runat="server" Width="100%" ShowStatusBar="true" AutoGenerateColumns="false"
PageSize="10" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="True"
AllowAutomaticInserts="false" OnInsertCommand="RGModels_InsertCommand" Visible="true">
<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
<MasterTableView Width="100%" Name="Models" DataKeyNames="ID" AllowAutomaticInserts="false"
AllowMultiColumnSorting="True" AutoGenerateColumns="false" HierarchyLoadMode="ServerOnDemand"
CommandItemDisplay="Top" EditMode="PopUp">
<CommandItemSettings AddNewRecordText="New business model" ShowExportToExcelButton="true" />
<EditFormSettings InsertCaption="Add new business model" UserControlName="Templates\DeplObjectCreate.ascx"
EditFormType="WebUserControl">
</EditFormSettings>
<DetailTables>
<telerik:GridTableView DataKeyNames="ID" Name="Sets" Width="100%" CommandItemDisplay="Top"
EditMode="PopUp">
<CommandItemSettings AddNewRecordText="New business (release) set" ShowExportToExcelButton="true" />
<EditFormSettings InsertCaption="Add new business (release) set" UserControlName="Templates\DeplObjectCreate.ascx"
EditFormType="WebUserControl">
</EditFormSettings>
<CommandItemStyle ForeColor="Yellow" />
<Columns>
<telerik:GridBoundColumn DataField="Name" HeaderText="Name" HeaderStyle-Width="20%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" HeaderStyle-Width="30%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="ShortName" HeaderText="Short name" HeaderStyle-Width="15%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="StateName" SortExpression="StateName" ReadOnly="True"
HeaderText="<%$ Resources:WebResource, State %>">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="BeginDate" HeaderText="Begin date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EndDate" HeaderText="End date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ID" HeaderText="ID" HeaderStyle-Width="2%" ItemStyle-HorizontalAlign="Left" UniqueName="ID" />
<telerik:GridBoundColumn DataField="ModelID" HeaderText="MID" HeaderStyle-Width="2%"
ItemStyle-HorizontalAlign="Left" UniqueName="MID" />
<telerik:GridTemplateColumn HeaderText="Account" UniqueName="ColumnRGModelsAccounts" >
<ItemTemplate>
<asp:ImageButton ID="LnkAccount" runat="server" Tooltip="Change deployment set parameters"
PostBackUrl='<%# "~/DeplAccounts.aspx?ProjectID=" & DataBinder.Eval (Container.DataItem,"DeploymentID").tostring & _
"&ModelID=" & DataBinder.Eval(Container.DataItem,"ModelID").tostring & _
"&SetID=" & DataBinder.Eval(Container.DataItem,"ID").tostring %>'
ImageUrl="./App_Themes/UP/bAccount.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Review" UniqueName="ColumnRGModelsReview" >
<ItemTemplate>
<asp:ImageButton ID="LnkReview" runat="server" Tooltip="Review generated requests"
PostBackUrl='<%# "~/DeplReview.aspx?ProjectID=" & DataBinder.Eval (Container.DataItem,"DeploymentID").tostring & _
"&ModelID=" & DataBinder.Eval(Container.DataItem,"ModelID").tostring & _
"&SetID=" & DataBinder.Eval(Container.DataItem,"ID").tostring %>'
ImageUrl="./App_Themes/UP/bReview.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Approve" UniqueName="ColumnRGModelsApprove" >
<ItemTemplate>
<asp:ImageButton ID="LnkApprove" runat="server" Tooltip="Approve changed requests"
PostBackUrl='<%# "~/DeplApprove.aspx?ProjectID=" & DataBinder.Eval (Container.DataItem,"DeploymentID").tostring & _
"&ModelID=" & DataBinder.Eval(Container.DataItem,"ModelID").tostring & _
"&SetID=" & DataBinder.Eval(Container.DataItem,"ID").tostring %>'
ImageUrl="./App_Themes/UP/Approve.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Change" >
<ItemTemplate>
<asp:ImageButton ID="LnkEdit" runat="server" Tooltip="Change deployment set parameters"
PostBackUrl='<%# DataBinder.Eval(Container, "DataItem.ID", "~/DeplBUSetDetails.aspx?ID={0}") %>'
ImageUrl="./App_Themes/UP/Edit.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Remove" meta:resourcekey="TemplateFieldResource2">
<ItemTemplate>
<asp:ImageButton ID="LnkRemove" runat="server" Visible="True" OnClientClick='<%# "DeplSetRemoveBtn(this,""" + DataBinder.Eval(Container.DataItem, "ID").ToString + """, " + Westwind.Utilities.WebUtils.EncodeJsString(DataBinder.Eval(Container.DataItem, "Name")) + "); return false;" %>'
AlternateText="Remove deployment model" ToolTip="Assigned requests will be 'orphaned'"
ImageUrl="./App_Themes/UP/bCut.gif" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridBoundColumn DataField="Name" HeaderText="Name" HeaderStyle-Width="20%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" HeaderStyle-Width="30%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="ShortName" HeaderText="Short name" HeaderStyle-Width="15%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="StateName" SortExpression="StateName" ReadOnly="True"
HeaderText="<%$ Resources:WebResource, State %>">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="BeginDate" HeaderText="Begin date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EndDate" HeaderText="End date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ID" HeaderText="ID" HeaderStyle-Width="2%" ItemStyle-HorizontalAlign="Left" UniqueName="ID" />
<telerik:GridBoundColumn DataField="DeplID" HeaderText="DID" HeaderStyle-Width="2%"
ItemStyle-HorizontalAlign="Left" UniqueName="DID" />
<telerik:GridTemplateColumn HeaderText="Change" meta:resourcekey="TemplateField">
<ItemTemplate>
<asp:ImageButton ID="LnkEdit" runat="server" AlternateText="Change deployment model parameters"
PostBackUrl='<%# DataBinder.Eval(Container, "DataItem.ID", "~/DeplBUModelDetails.aspx?ID={0}") %>'
ImageUrl="./App_Themes/UP/Edit.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Remove" meta:resourcekey="TemplateFieldResource2">
<ItemTemplate>
<asp:ImageButton ID="LnkRemove" runat="server" Visible="True" OnClientClick='<%# "DeplModelRemoveBtn(this,""" + DataBinder.Eval(Container.DataItem, "ID").ToString + """, " + Westwind.Utilities.WebUtils.EncodeJsString(DataBinder.Eval(Container.DataItem, "Name")) + "); return false;" %>'
AlternateText="Remove business model" ToolTip="Will also remove sibling business sets"
ImageUrl="./App_Themes/UP/bCut.gif" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
code behind:
Private Sub RGModels_ItemCreated(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles RGModels.ItemCreated
' 4 build-in export buttons
'ExportToExcelButton()
'ExportToWordButton()
'ExportToPdfButton()
'ExportToCsvButton()
If TypeOf e.Item Is GridCommandItem Then
Dim ExportToExcelButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToExcelButton"), Button)
If Not ExportToExcelButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToExcelButton)
Dim ExportToWordButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToWordButton"), Button)
If Not ExportToWordButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToWordButton)
Dim ExportToPdfButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToPdfButton"), Button)
If Not ExportToPdfButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToPdfButton)
Dim ExportToCsvButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToCsvButton"), Button)
If Not ExportToCsvButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToCsvButton)
End If
End Sub
Private Sub RGModels_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles RGModels.ItemCommand
If e.CommandName = Telerik.Web.UI.RadGrid.ExportToExcelCommandName OrElse e.CommandName = Telerik.Web.UI.RadGrid.ExportToWordCommandName OrElse e.CommandName = Telerik.Web.UI.RadGrid.ExportToCsvCommandName Then
sender.ExportSettings.ExportOnlyData = True
sender.ExportSettings.IgnorePaging = True
sender.ExportSettings.OpenInNewWindow = True
sender.ExportSettings.HideStructureColumns = True
sender.MasterTableView.HierarchyDefaultExpanded = True
sender.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML
Select Case e.CommandName
Case "ExportToExcel"
sender.MasterTableView.ExportToExcel()
Case "ExportToWord"
sender.MasterTableView.ExportToWord()
End Select
End If
End Sub
I do data binding in code behind. Export from the parent grid works fine but when user clicks on Export to Excel in child grid, it throws following exception.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
|
Stack Trace:
|
My ASPX template is:
<telerik:RadGrid ID="RGModels" runat="server" Width="100%" ShowStatusBar="true" AutoGenerateColumns="false"
PageSize="10" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="True"
AllowAutomaticInserts="false" OnInsertCommand="RGModels_InsertCommand" Visible="true">
<PagerStyle Mode="NextPrevAndNumeric"></PagerStyle>
<MasterTableView Width="100%" Name="Models" DataKeyNames="ID" AllowAutomaticInserts="false"
AllowMultiColumnSorting="True" AutoGenerateColumns="false" HierarchyLoadMode="ServerOnDemand"
CommandItemDisplay="Top" EditMode="PopUp">
<CommandItemSettings AddNewRecordText="New business model" ShowExportToExcelButton="true" />
<EditFormSettings InsertCaption="Add new business model" UserControlName="Templates\DeplObjectCreate.ascx"
EditFormType="WebUserControl">
</EditFormSettings>
<DetailTables>
<telerik:GridTableView DataKeyNames="ID" Name="Sets" Width="100%" CommandItemDisplay="Top"
EditMode="PopUp">
<CommandItemSettings AddNewRecordText="New business (release) set" ShowExportToExcelButton="true" />
<EditFormSettings InsertCaption="Add new business (release) set" UserControlName="Templates\DeplObjectCreate.ascx"
EditFormType="WebUserControl">
</EditFormSettings>
<CommandItemStyle ForeColor="Yellow" />
<Columns>
<telerik:GridBoundColumn DataField="Name" HeaderText="Name" HeaderStyle-Width="20%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" HeaderStyle-Width="30%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="ShortName" HeaderText="Short name" HeaderStyle-Width="15%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="StateName" SortExpression="StateName" ReadOnly="True"
HeaderText="<%$ Resources:WebResource, State %>">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="BeginDate" HeaderText="Begin date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EndDate" HeaderText="End date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ID" HeaderText="ID" HeaderStyle-Width="2%" ItemStyle-HorizontalAlign="Left" UniqueName="ID" />
<telerik:GridBoundColumn DataField="ModelID" HeaderText="MID" HeaderStyle-Width="2%"
ItemStyle-HorizontalAlign="Left" UniqueName="MID" />
<telerik:GridTemplateColumn HeaderText="Account" UniqueName="ColumnRGModelsAccounts" >
<ItemTemplate>
<asp:ImageButton ID="LnkAccount" runat="server" Tooltip="Change deployment set parameters"
PostBackUrl='<%# "~/DeplAccounts.aspx?ProjectID=" & DataBinder.Eval (Container.DataItem,"DeploymentID").tostring & _
"&ModelID=" & DataBinder.Eval(Container.DataItem,"ModelID").tostring & _
"&SetID=" & DataBinder.Eval(Container.DataItem,"ID").tostring %>'
ImageUrl="./App_Themes/UP/bAccount.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Review" UniqueName="ColumnRGModelsReview" >
<ItemTemplate>
<asp:ImageButton ID="LnkReview" runat="server" Tooltip="Review generated requests"
PostBackUrl='<%# "~/DeplReview.aspx?ProjectID=" & DataBinder.Eval (Container.DataItem,"DeploymentID").tostring & _
"&ModelID=" & DataBinder.Eval(Container.DataItem,"ModelID").tostring & _
"&SetID=" & DataBinder.Eval(Container.DataItem,"ID").tostring %>'
ImageUrl="./App_Themes/UP/bReview.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Approve" UniqueName="ColumnRGModelsApprove" >
<ItemTemplate>
<asp:ImageButton ID="LnkApprove" runat="server" Tooltip="Approve changed requests"
PostBackUrl='<%# "~/DeplApprove.aspx?ProjectID=" & DataBinder.Eval (Container.DataItem,"DeploymentID").tostring & _
"&ModelID=" & DataBinder.Eval(Container.DataItem,"ModelID").tostring & _
"&SetID=" & DataBinder.Eval(Container.DataItem,"ID").tostring %>'
ImageUrl="./App_Themes/UP/Approve.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Change" >
<ItemTemplate>
<asp:ImageButton ID="LnkEdit" runat="server" Tooltip="Change deployment set parameters"
PostBackUrl='<%# DataBinder.Eval(Container, "DataItem.ID", "~/DeplBUSetDetails.aspx?ID={0}") %>'
ImageUrl="./App_Themes/UP/Edit.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Remove" meta:resourcekey="TemplateFieldResource2">
<ItemTemplate>
<asp:ImageButton ID="LnkRemove" runat="server" Visible="True" OnClientClick='<%# "DeplSetRemoveBtn(this,""" + DataBinder.Eval(Container.DataItem, "ID").ToString + """, " + Westwind.Utilities.WebUtils.EncodeJsString(DataBinder.Eval(Container.DataItem, "Name")) + "); return false;" %>'
AlternateText="Remove deployment model" ToolTip="Assigned requests will be 'orphaned'"
ImageUrl="./App_Themes/UP/bCut.gif" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridBoundColumn DataField="Name" HeaderText="Name" HeaderStyle-Width="20%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="Description" HeaderText="Description" HeaderStyle-Width="30%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="ShortName" HeaderText="Short name" HeaderStyle-Width="15%"
ItemStyle-HorizontalAlign="Left" />
<telerik:GridBoundColumn DataField="StateName" SortExpression="StateName" ReadOnly="True"
HeaderText="<%$ Resources:WebResource, State %>">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="BeginDate" HeaderText="Begin date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="EndDate" HeaderText="End date" DataFormatString="{0:dd-MMM-yyyy}">
<HeaderStyle HorizontalAlign="Center" Width="10%" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="ID" HeaderText="ID" HeaderStyle-Width="2%" ItemStyle-HorizontalAlign="Left" UniqueName="ID" />
<telerik:GridBoundColumn DataField="DeplID" HeaderText="DID" HeaderStyle-Width="2%"
ItemStyle-HorizontalAlign="Left" UniqueName="DID" />
<telerik:GridTemplateColumn HeaderText="Change" meta:resourcekey="TemplateField">
<ItemTemplate>
<asp:ImageButton ID="LnkEdit" runat="server" AlternateText="Change deployment model parameters"
PostBackUrl='<%# DataBinder.Eval(Container, "DataItem.ID", "~/DeplBUModelDetails.aspx?ID={0}") %>'
ImageUrl="./App_Themes/UP/Edit.gif" meta:resourcekey="LnkEditResource1" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Remove" meta:resourcekey="TemplateFieldResource2">
<ItemTemplate>
<asp:ImageButton ID="LnkRemove" runat="server" Visible="True" OnClientClick='<%# "DeplModelRemoveBtn(this,""" + DataBinder.Eval(Container.DataItem, "ID").ToString + """, " + Westwind.Utilities.WebUtils.EncodeJsString(DataBinder.Eval(Container.DataItem, "Name")) + "); return false;" %>'
AlternateText="Remove business model" ToolTip="Will also remove sibling business sets"
ImageUrl="./App_Themes/UP/bCut.gif" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="5%" />
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
code behind:
Private Sub RGModels_ItemCreated(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles RGModels.ItemCreated
' 4 build-in export buttons
'ExportToExcelButton()
'ExportToWordButton()
'ExportToPdfButton()
'ExportToCsvButton()
If TypeOf e.Item Is GridCommandItem Then
Dim ExportToExcelButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToExcelButton"), Button)
If Not ExportToExcelButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToExcelButton)
Dim ExportToWordButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToWordButton"), Button)
If Not ExportToWordButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToWordButton)
Dim ExportToPdfButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToPdfButton"), Button)
If Not ExportToPdfButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToPdfButton)
Dim ExportToCsvButton As Button = TryCast(TryCast(e.Item, GridCommandItem).FindControl("ExportToCsvButton"), Button)
If Not ExportToCsvButton Is Nothing Then ScriptManager.GetCurrent(Me.Page).RegisterPostBackControl(ExportToCsvButton)
End If
End Sub
Private Sub RGModels_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles RGModels.ItemCommand
If e.CommandName = Telerik.Web.UI.RadGrid.ExportToExcelCommandName OrElse e.CommandName = Telerik.Web.UI.RadGrid.ExportToWordCommandName OrElse e.CommandName = Telerik.Web.UI.RadGrid.ExportToCsvCommandName Then
sender.ExportSettings.ExportOnlyData = True
sender.ExportSettings.IgnorePaging = True
sender.ExportSettings.OpenInNewWindow = True
sender.ExportSettings.HideStructureColumns = True
sender.MasterTableView.HierarchyDefaultExpanded = True
sender.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML
Select Case e.CommandName
Case "ExportToExcel"
sender.MasterTableView.ExportToExcel()
Case "ExportToWord"
sender.MasterTableView.ExportToWord()
End Select
End If
End Sub