I am trying to export my grid using LinkButton's in the CommandItemTemplate, but unfortunately it is not working. I have tried setting the OnClick="LinkButton1_Click" but it does not seem to be working.
I have also tried to FindControl during the RadGrid1_ItemCreated event, but then I cannot set the OnClick property from there since it is Protected...
Any suggestions would be great
I have also tried to FindControl during the RadGrid1_ItemCreated event, but then I cannot set the OnClick property from there since it is Protected...
Any suggestions would be great
Protected Sub LinkButton1_Click(ByVal sender As Object, ByVal e As System.EventArgs) |
RadGrid1.ExportSettings.ExportOnlyData = True |
RadGrid1.MasterTableView.ExportToExcel() |
End Sub |
Protected Sub LinkButton2_Click(ByVal sender As Object, ByVal e As System.EventArgs) |
RadGrid1.MasterTableView.ExportToPdf() |
End Sub |
Protected Sub RadGrid1_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemCreated |
If (TypeOf e.Item Is GridCommandItem) Then |
Dim cmditm As GridCommandItem = DirectCast(e.Item, GridCommandItem) |
Dim LinkButton1 As LinkButton = DirectCast(cmditm.FindControl("LinkButton1"), LinkButton) |
Dim LinkButton2 As LinkButton = DirectCast(cmditm.FindControl("LinkButton2"), LinkButton) |
LinkButton1.OnClick = LinkButton1_Click() |
End If |
End Sub |
<div class="panelbody_bottom"> |
<div style="height: 20px;"> </div> |
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" Skin="Telerik" AllowAutomaticDeletes="false" AllowAutomaticUpdates="false" AllowAutomaticInserts="false" AllowSorting="true" AllowPaging="true"> |
<ExportSettings IgnorePaging="true" OpenInNewWindow="true" ExportOnlyData="true"> |
<Excel Format="HTML" /> |
<Pdf AllowAdd="false" AllowCopy="true" AllowModify="true" AllowPrinting="true" Author="Anonymous" Keywords="None" PageBottomMargin="1in" PageLeftMargin="1in" PageRightMargin="1in" PageTopMargin="1in" PageTitle="My Businesses For Sale" |
Subject="My Businesses For Sale" Title="My Businesses For Sale" PaperSize="Letter" /> |
</ExportSettings> |
<MasterTableView TableLayout="Auto" DataKeyNames="ID" CommandItemDisplay="Top"> |
<PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" /> |
<RowIndicatorColumn> |
<HeaderStyle Width="15px" /> |
</RowIndicatorColumn> |
<ExpandCollapseColumn> |
<HeaderStyle Width="15px" /> |
</ExpandCollapseColumn> |
<Columns> |
<telerik:GridBoundColumn DataField="_31" HeaderText="Broker/Agent" UniqueName="31" /> |
<telerik:GridBoundColumn DataField="_45" HeaderText="Business Extension" UniqueName="45" /> |
<telerik:GridBoundColumn DataField="_59" HeaderText="Description" UniqueName="59" /> |
<telerik:GridBoundColumn DataField="_118" HeaderText="Selling Price" UniqueName="_118" DataFormatString="{0:c}" /> |
<telerik:GridTemplateColumn DataField="DateExpires" HeaderText="Expires" UniqueName="DateExpires"> |
<ItemTemplate> |
<asp:Label ID="lblDateUpdated" runat="server" Text='<%# FormatDate(DataBinder.Eval(Container.DataItem, "DateExpires"), DataBinder.Eval(Container.DataItem, "OrderID")) %>' /> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridBoundColumn DataField="AdHits" HeaderText="Views" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" UniqueName="AdHits" /> |
<telerik:GridTemplateColumn DataField="ID" HeaderText="" UniqueName="Edit"> |
<ItemTemplate> |
<a href='#'>edit</a> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
<telerik:GridTemplateColumn DataField="ID" HeaderText="" UniqueName="Sold"> |
<ItemTemplate> |
<a href='#'>sold</a> |
</ItemTemplate> |
</telerik:GridTemplateColumn> |
</Columns> |
<CommandItemTemplate> |
<div style="float: left; display: inline; padding-left: 5px;"><a href="PostAd.aspx">post new business for sale ad</a></div> |
<div style="float: right; display: inline; padding-right: 5px;"> |
<asp:LinkButton ID="LinkButton1" runat="server" Text="export to excel" /> |
| |
<asp:LinkButton ID="LinkButton2" runat="server" Text="export to pdf" /> |
</div> |
</CommandItemTemplate> |
</MasterTableView> |
<StatusBarSettings LoadingText="Loading..." /> |
</telerik:RadGrid> |
</div> |