The file you are trying to open, <pagename>.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
is there anything i can ovoid the format realted warning message? and also .xlsx file is very lighter than the .xls so we want to use the lighter version.
or is there any simple c# code i can write each row to excel file for telerik grid.
Thanks
-krishna
| <telerik:GridTemplateColumn UniqueName="TemplateColumn4" AllowFiltering="True" Groupable="False" |
| HeaderStyle-Width="55px" ItemStyle-Width="55px" Reorderable="False" ShowSortIcon="True"> |
| <ItemTemplate> |
| <asp:LinkButton runat="server" CausesValidation="false" CommandName="Edit" |
| Text='<%#Eval("PartNumber") %>' /> |
| </ItemTemplate> |
| <HeaderStyle Width="55px"></HeaderStyle> |
| <ItemStyle Width="55px"></ItemStyle> |
| </telerik:GridTemplateColumn> |
| <asp:Button ID="btnUpdate" Text='<%# Iif (TypeOf Container is GridEditFormInsertItem, "Insert", "Update") %>' |
| runat="server" CommandName='<%# Iif(TypeOf Container is GridEditFormInsertItem, "PerformInsert" , "Update" ) %>'> |
| </asp:Button> |
function
showMenu(e) {
var contextMenu = $find("<%= titleBarContextMenu.ClientID %>");
debugger;
if ((!e.relatedTarget) || (!$telerik.isDescendantOrSelf(contextMenu.get_element(), e.relatedTarget))) {
contextMenu.show(e);
}
$telerik.cancelRawEvent(e);
}
<
table border="0" cellpadding="0" cellspacing="0" width="100%" style="height:24px; background-color:Transparent; white-space:nowrap; overflow:hidden; " >
<tr>
<td align="left" width="100%">
<asp:Label ID="paneTitleLabel" Font-Names="Arial" Font-Size="8pt" ForeColor="White" runat="server"></asp:Label>
</td>
<td>
<img src="/Images/Options_Idol.png" onmouseover="this.src='/Images/Options_hover.png'" onclick="showMenu(event)" onmouseout="this.src='/Images/Options_Idol.png'" alt="Web Part Menu" width="25px" />
</td>
<td align="right" valign="top">
<telerik:RadToolBar ID="radToolBarTitle" Runat="server" EnableEmbeddedSkins="false"
Font-Names="Arial" Font-Size="8pt" ForeColor="White" BorderWidth="0px" AutoPostBack="true">
<ExpandAnimation Duration="600" Type="InOutCubic"></ExpandAnimation>
<CollapseAnimation Duration="900" Type="InElastic"></CollapseAnimation>
</telerik:RadToolBar>
<telerik:RadContextMenu ID="titleBarContextMenu" runat="server" Skin="Vista" OnItemClick="titleBarContextMenu_ItemClick">
<Targets>
<telerik:ContextMenuControlTarget ControlID="radToolBarTitle" />
</Targets>
<Items>
</Items>
</telerik:RadContextMenu>
</td>
</tr>
</
table>
if (e.Item is GridFooterItem)
{
GridFooterItem footer = (GridFooterItem)e.Item;
RadComboBox radComboStatus = new RadComboBox();
radComboStatus.ID = comboId;
.
.
footer["DisplayStatus"].Controls.Add(radComboStatus);
}
| public class Details |
| { |
| public Int64 ID |
| { |
| get; |
| set; |
| } |
| public Contact Contact |
| { |
| get; |
| set; |
| } |
| } |
| public class Contact |
| { |
| public string Title |
| { |
| get; |
| set; |
| } |
| public string FirstName |
| { |
| get; |
| set; |
| } |
| } |
| <asp:TextBox ID="txtFirstName" Text='<%# Eval("Contact.FirstName") %>' CssClass="txtBox" |
| runat="server"></asp:TextBox> |
"There is no universal mechanism for grouping when custom paging is allowed. The reason for this is that with the custom paging mechanism you fetch only a part of the whole information from the grid data source. Thus, when the grouping event is triggered, the grid is restricted in operating with a limited subset of the entire available data and is not able to group the items accurately. Furthermore, the aggregate functions as Count, Sum, etc. (covering operations with the whole set of grid items) may return incorrect results.
Grouping with custom paging is still possible, but it has several limitations:
Hint:
It would be possible if there were an event (like the NeedDataSource) which is called "NeedGroupTotals" or similiar which provides the needed EventArgs to perform an extra call to the database.