[Solved] Rad Grid With Rad Menu

[Ricky]

I have problem with using the RadContextMenu with Rad Grid. I was using the Radgrid before with the Export Facility but after adding the Rad Menu it killed the export functionality . Now when i hit Export it shows the same grid with now buttons and does not ask to open or save the excel file.

Thanks
 

[Shinu]

Hi Ricky,

Have you enabled Ajax for the Grid ?. Disable the Ajax  feature try exporting the Grid.

Shinu.

[Ricky]

Thanks  Shinu

But it does not make any difference. Same thing happened again.

[Shinu]

Hi,

Could you send your aspx?

Shinu.

[Ricky]

ASPX CODE

<telerik:RadGrid ID="rgrdTransactions" runat="server" DataSourceID="sqldsTransactions" ExportSettings-OpenInNewWindow="true"

Height="570px" EnableAJAX="False" skin="Office2007" Width="780px" PageSize="25"

AllowPaging="True" AllowSorting="True" AllowAutomaticDeletes="True" AutoGenerateColumns="False"

GridLines="None">

<ClientSettings AllowRowsDragDrop="True">

<Selecting AllowRowSelect="True" />

<Scrolling UseStaticHeaders="True" AllowScroll="True"></Scrolling>

<ClientEvents OnRowContextMenu="RowContextMenu2" />

</ClientSettings>

<PagerStyle CssClass="CustomGridPager" Mode="NumericPages"></PagerStyle>

<MasterTableView DataSourceID="sqldsTransactions" DataKeyNames="tGUID,iaGUID,tAuditGUID" ClientDataKeyNames="tAuditGUID"

CommandItemDisplay="Bottom">

<CommandItemTemplate>

<table cellpadding="5" width="100%">

<tr align="center" valign="middle">

<td align="center" valign="middle">

<asp:Image ID="AddRecord1" runat="server" ImageUrl="~/RadControls/Grid/Skins/AddRecord.gif"

AlternateText="Create Contact Note" />

<a href="#" onclick="return ShowInsertTransactionForm();">Add New</a>

</td>

<td align="center" valign="middle">

<asp:LinkButton Style="vertical-align: middle" ID="LinkButton4" runat="server" CommandName="Export">

<asp:Image ID="Image1" runat="server" ImageUrl="~/RadControls/Grid/Skins/excel.jpg"

AlternateText="Export To Excel" /> Export to Excel</asp:LinkButton>

</td>

<td align="center" valign="middle">

<asp:LinkButton Style="vertical-align: middle" ID="LinkButton23" runat="server" CommandName="PerformInsert"

Visible='<%# rgrdTransactions.MasterTableView.IsItemInserted %>'>

<img style="border: 0px" alt="" src="../../../RadControls/Grid/Skins/Insert.gif" /><asp:Label

ID="Label61" runat="server" Text=" Add this" Height="17px"></asp:Label></asp:LinkButton>

</td>

<td align="center" valign="middle">

<asp:LinkButton Style="vertical-align: middle" ID="LinkButton27" OnClientClick="javascript:return confirm('Delete selected Transaction?')"

runat="server" CommandName="DeleteSelected" CausesValidation="false">

<img style="border: 0px" alt="" src="../../../RadControls/Grid/Skins/Delete.gif" /><asp:Label

ID="Label68" runat="server" Text=" Delete Selected" Height="17px"></asp:Label></asp:LinkButton></td>

<td align="center" valign="middle">

<asp:LinkButton Style="vertical-align: middle" ID="LinkButton28" runat="server" CommandName="RebindGrid"><img style="border:0px" alt="" src="../../../RadControls/Grid/Skins/Office2007/Refresh.gif" /> Refresh</asp:LinkButton></td>

<td align="center" valign="middle">

<asp:Label ID="Label28" runat="server" Text='<%# rgrdTransactions.MasterTableView.DataSourceCount & " transactions" %>'></asp:Label></td>

</tr>

</table>

</CommandItemTemplate>

<PagerTemplate>

<table border="0" cellpadding="0" cellspacing="0" style="height: 20px" width="100%">

<tr>

<td style="padding-left: 10px;">

<asp:Label ID="Label23" runat="server" Text="<<"></asp:Label>

<asp:LinkButton ID="LinkButton11" CommandName="Page" CausesValidation="false" CommandArgument="First"

runat="server">First</asp:LinkButton>

</td>

<td>

<asp:Label ID="Label24" runat="server" Text="<"></asp:Label>

<asp:LinkButton ID="LinkButton12" CommandName="Page" CausesValidation="false" CommandArgument="Prev"

runat="server">Prev</asp:LinkButton>

</td>

<td>

Change Page:

&nbsp;<asp:TextBox ID="tbPageNumber3" runat="server" Columns="3" Text='' />

<asp:RangeValidator runat="Server" ID="RangeValidator3" ControlToValidate="tbPageNumber3"

EnableClientScript="true" MinimumValue="1" Type="Integer" MaximumValue='<%# DataBinder.Eval(Container, "Paging.PageCount") %>'

ErrorMessage='<%# "Value must be in the range of 1 - " & DataBinder.Eval(Container, "Paging.PageCount") %>'

Display="Dynamic"></asp:RangeValidator>

<asp:LinkButton ID="LinkButton13" runat="server" CommandName="CustomChangePage">Go</asp:LinkButton>

</td>

<td>

Page

<asp:Label ID="Label25" runat="server" Text='<%# DataBinder.Eval(Container, "Paging.CurrentPageIndex")+1 %>'></asp:Label>&nbsp;of&nbsp;<asp:Label

ID="Label32" runat="server" Text='<%# DataBinder.Eval(Container, "Paging.PageCount") %>'></asp:Label>&nbsp;

</td>

<td>

<asp:LinkButton ID="LinkButton14" CommandName="Page" CausesValidation="false" CommandArgument="Next"

runat="server">Next</asp:LinkButton>

<asp:Label ID="Label48" runat="server" Text=">"></asp:Label>

</td>

<td>

<asp:LinkButton ID="LinkButton15" CommandName="Page" CausesValidation="false" CommandArgument="Last"

runat="server">Last</asp:LinkButton>

<asp:Label ID="Label50" runat="server" Text=">>"></asp:Label>

</td>

</tr>

</table>

</PagerTemplate>

<Columns>

<telerik:GridBoundColumn DataField="iaGUID" DataType="System.Guid" UniqueName="iaGUID"

SortExpression="iaGUID" Visible="False" HeaderText="iaGUID">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="tDate" SortExpression="tDate" EditFormColumnIndex="1"

HeaderText="Date">

<HeaderStyle HorizontalAlign="Left" Width="55px" Font-Size="X-Small" Wrap="True"></HeaderStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label51" Width="55px" Text='<%# Eval("tDate", "{0:dd-MMM-yy}") %>'

CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="ttAbbreviation" SortExpression="ttAbbreviation"

EditFormColumnIndex="1" HeaderText="Type">

<HeaderStyle HorizontalAlign="Left" Width="30px" Font-Size="X-Small"></HeaderStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label52" Width="30px" Text='<%# Eval("ttAbbreviation") %>'

CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="tGrossAmount" SortExpression="tGrossAmount"

EditFormColumnIndex="1" HeaderText="Gross">

<HeaderStyle HorizontalAlign="Right" Font-Size="X-Small"></HeaderStyle>

<ItemStyle HorizontalAlign="Right"></ItemStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label53" Text='<%# Eval("tGrossAmount","{0:C}") %>'

CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="Deductions" SortExpression="Deductions" EditFormColumnIndex="1"

HeaderText="Deductions">

<HeaderStyle Width="55px" HorizontalAlign="Right" Font-Size="X-Small"></HeaderStyle>

<ItemStyle HorizontalAlign="Right"></ItemStyle>

<ItemTemplate>

<asp:Label runat="server" Width="55px" ID="Label54" Text='<%# Eval("deductions","{0:C}") %>'

CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="tNetAmount" SortExpression="tNetAmount" EditFormColumnIndex="1"

HeaderText="Investment">

<HeaderStyle HorizontalAlign="Right" Font-Size="X-Small"></HeaderStyle>

<ItemStyle HorizontalAlign="Right"></ItemStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label55" Text='<%# Eval("tNetAmount","{0:C}") %>' CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="tUnitPrice" SortExpression="tUnitPrice" EditFormColumnIndex="1"

HeaderText="Price">

<HeaderStyle HorizontalAlign="Right" Font-Size="X-Small" Width="45px"></HeaderStyle>

<ItemStyle HorizontalAlign="Right"></ItemStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label56" Width="45px" Text='<%# Eval("tUnitPrice","{0:C4}") %>'

CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="tUnits" SortExpression="tUnits" EditFormColumnIndex="1"

HeaderText="Units">

<HeaderStyle HorizontalAlign="Right" Font-Size="X-Small"></HeaderStyle>

<ItemStyle HorizontalAlign="Right"></ItemStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label57" Text='<%# Eval("tUnits","{0:n}") %>' CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="tUnitBalance" SortExpression="tUnitBalance"

EditFormColumnIndex="1" HeaderText="Unit Balance">

<HeaderStyle HorizontalAlign="Right" Font-Size="X-Small"></HeaderStyle>

<ItemStyle HorizontalAlign="Right"></ItemStyle>

<ItemTemplate>

<asp:Label runat="server" ID="Label58" Text='<%# Eval("tUnitBalance","{0:n}") %>'

CssClass="smallfont"></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn UniqueName="TemplateEditColumn" >

<HeaderStyle Width="20px"></HeaderStyle>

<ItemStyle Width="20px"></ItemStyle>

<ItemTemplate>

<a runat="server" id="EditAnchor" title="Edit" >

<asp:Image ID="EditRecord" runat="server" ImageUrl="~/RadControls/Grid/Skins/Default/Edit.gif"

AlternateText="Edit Trsaction" /></a>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

<ExpandCollapseColumn Visible="False">

<HeaderStyle Width="19px"></HeaderStyle>

</ExpandCollapseColumn>

<RowIndicatorColumn Visible="False">

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

</MasterTableView>

</telerik:RadGrid>




CODE BEHIND

Protected Sub rgrdTransactions_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles rgrdTransactions.ItemCommand

If (e.CommandName = "Export") Then

rgrdTransactions.ExportSettings.ExportOnlyData =

True

rgrdTransactions.ExportSettings.IgnorePaging =

True

rgrdTransactions.ExportSettings.OpenInNewWindow =

True

rgrdTransactions.MasterTableView.ExportToExcel()

End If

End sub


Thanks
Rick

[Shinu]

Hi Ricky,

Have you ajaxified the Grid using RadAjaxManager?

Shinu

[Ricky]

Yes i did 

Code:

<telerik:RadAjaxManager ID="RadAjaxManager2" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadMenu1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadMenu1" />

<telerik:AjaxUpdatedControl ControlID="rgrdInvestmentAccountEntities" LoadingPanelID="AjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadMenu2">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadMenu2" />

<telerik:AjaxUpdatedControl ControlID="rgrdtransactions" LoadingPanelID="AjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="RadMenu3">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadMenu3" />

<telerik:AjaxUpdatedControl ControlID="rgrdEntityNotes" LoadingPanelID="AjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

RICK

[Princy]

Hi Ricky,

The exporting feature of the control work with regular postbacks only. Go through the following help document link for more details.
Export from ajaxified grid

Thanks
Princy.

[Ricky]

Thanks Princy

I have fixed this one, now the export feature work without Ajaxified Grid. now i am not sure i will be able to use the Drag Drop feature.


Rick