
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { if ((e.CommandName == RadGrid.PerformInsertCommandName)) { //the dropdown list will be the first control in the Controls collection of the corresponding cell DropDownList list = (e.Item as GridEditableItem)["ddlContactName"].Controls[0] as DropDownList; } } protected void ObjectDataSource1_Inserting(object sender, System.Web.UI.WebControls.ObjectDataSourceMethodEventArgs e) { ((DAL.DTO.DataTypeObject)e.InputParameters[0]).product.product_id = (int)Session["CustomerID"]; //These dont work...how can I access my Edit form or GridCommandEventArgs from this event in objectDatasource //inserting event to access my dropdownlist?? //Telerik.Web.UI.GridEditFormInsertItem myInsertForm = ((Telerik.Web.UI.GridEditFormInsertItem)RadGrid1.FindControl("EditFormControl")); //Telerik.Web.UI.GridEditFormInsertItem myInsertForm = ((Telerik.Web.UI.GridEditFormInsertItem)RadGrid1.EditItems[0]); <asp:RadioButtonList ID="rbl_radio_list" runat="server" Enabled="false"> <asp:ListItem Text="Radio List Item 1" Value="1"></asp:ListItem> <asp:ListItem Text="Radio List Item 2" Value="2"></asp:ListItem> <asp:ListItem Text="Radio List Item 3" Value="3"></asp:ListItem></asp:RadioButtonList><asp:RadioButton ID="rdb_radio" runat="server" Text="Radio 1" Enabled="false" Checked="false"/><asp:CheckBoxList ID="cbl_check_list" runat="server" Enabled="false"> <asp:ListItem Text="Check List Item 1" Value="1"></asp:ListItem> <asp:ListItem Text="Check List Item 2" Value="2"></asp:ListItem> <asp:ListItem Text="Check List Item 3" Value="3"></asp:ListItem></asp:CheckBoxList><asp:CheckBox ID="cbx_check" runat="server" Text="Check 1" Enabled="false" Checked="false" /><telerik:RadFormDecorator ID="rfd_radio" runat="server" DecoratedControls="RadioButtons" /><telerik:RadFormDecorator ID="rfd_check" runat="server" DecoratedControls="CheckBoxes" />
We are binding Generic List of entities (e.g. List<Employee>) with RadGrid (Teleric.Web.UI.dll v2009.2.826.35). We are using GridBoundColumn. Grid gets diplsayed properly. Also it gets exported very well in .pdf and .csv formats. But when we try to export in Excel using ExcelML format, it generates blank excel file. Here is sample code:
protected void Page_Load(object sender, EventArgs e)
{
}
protected void uxRadListView_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
SetGridDataSource();
}
public void SetGridDataSource()
{
uxRadListView.DataSource = GetList();
}
private List<Employee> GetList()
{
List<Employee> employees = new List<Employee>();
for (int i = 0; i < 10; i++)
{
Employee emp = new Employee();
emp.EmpId = 100;
emp.FName = "John";
employees.Add(emp);
}
}
protected void uxBtnExport_Click(object sender, EventArgs e)
{
uxRadListView.ExportSettings.IgnorePaging = true;
uxRadListView.ExportSettings.OpenInNewWindow = true;
uxRadListView.ExportSettings.FileName = "EXCEL";
uxRadListView.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
uxRadListView.ExportSettings.ExportOnlyData = false;
uxRadListView.MasterTableView.ExportToExcel();
}
RadAjaxManager section<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="btnRefreshTree"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadTreeView1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadTreeView1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadSlider1" /> <telerik:AjaxUpdatedControl ControlID="DescriptionText" /> <telerik:AjaxUpdatedControl ControlID="lblTotalAssets" /> <telerik:AjaxUpdatedControl ControlID="RadListView1" LoadingPanelID="RadAjaxLoadingPanel1" /> <telerik:AjaxUpdatedControl ControlID="RadDataPager1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="btnSelectAll"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadListView1" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="btnUnSelectAll"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadListView1" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="btnRefresh"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadSlider1" /> <telerik:AjaxUpdatedControl ControlID="lblTotalAssets" /> <telerik:AjaxUpdatedControl ControlID="RadListView1" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadListView1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadTreeView1" /> <telerik:AjaxUpdatedControl ControlID="RadSlider1" /> <telerik:AjaxUpdatedControl ControlID="DescriptionText" /> <telerik:AjaxUpdatedControl ControlID="lblTotalAssets" /> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="RadDataPager1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadSlider1" /> <telerik:AjaxUpdatedControl ControlID="RadListView1" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManager><telerik:RadListView ID="RadListView1" runat="server" AllowPaging="True" ItemPlaceholderID="PlaceHolder1" OnItemCreated="RadListView1_ItemCreated" OnPreRender="RadListView1_PreRender" DataKeyNames="id"> <LayoutTemplate> <div class="RadListView RadListViewFloated RadListView_Windows7"> <telerik:RadDataPager ID="RadDataPager1" runat="server" Skin="Sitefinity" PageSize="25" PagedControlID="RadListView1" BorderWidth="0"> <Fields> <telerik:RadDataPagerButtonField FieldType="FirstPrev" /> <telerik:RadDataPagerButtonField FieldType="Numeric" /> <telerik:RadDataPagerButtonField FieldType="NextLast" /> <telerik:RadDataPagerPageSizeField PageSizeText="Page size: " /> <telerik:RadDataPagerGoToPageField CurrentPageText="Page: " TotalPageText="of" SubmitButtonText="Go" TextBoxWidth="15" /> <telerik:RadDataPagerTemplatePageField> <PagerTemplate> <div style="float: right"> <b>Items <asp:Label runat="server" ID="CurrentPageLabel" Text="<%# Container.Owner.StartRowIndex + 1%>" /> to <asp:Label runat="server" ID="TotalPagesLabel" Text="<%# Container.Owner.StartRowIndex+Container.Owner.PageSize %>" /> of <asp:Label runat="server" ID="TotalItemsLabel" Text="<%# Container.Owner.TotalRowCount%>" /> <br /> </b> </div> </PagerTemplate> </telerik:RadDataPagerTemplatePageField> </Fields> </telerik:RadDataPager> <div id="PlaceHolder1" runat="server" /> </div> </LayoutTemplate> <ItemTemplate> <div style="float: left;"> <fieldset style="border: 0; width: 154px; height: 154px; margin: 5px 5px 5px 5px;"> <div class="myClass" style="padding: 2px 2px 2px 2px; background: #eeeeee; text-align: center;"> <a href="javascript:Popup_Window('asset_preview','<%# Eval("id") %>')"> <telerik:RadBinaryImage ID="RadBinaryImage1" runat="server" AutoAdjustImageControlSize="False" CssClass="myClass" ImageUrl='<%# Eval("thumbUrl") %>' ResizeMode="Fit" AlternateText="Click to view preview" ToolTip="Click to view preview" Width="150px" Height="150px" /> </a> </div> </fieldset> <div style="border: 0px; white-space: normal; width: 150px; margin: 5px 5px 5px 5px; padding: 2px 2px 2px 2px;"> <asp:CheckBox ID="chkImage" runat="server" AutoPostBack="True" /> <a href="javascript:Popup_Window('asset_detail','<%# Eval("id") %>')"> <%# Eval("title") %> - <%# Eval("filenameextension") %></a> <%--<asp:HyperLink ID="lnkAsset" Target="_new" NavigateUrl="assetinfo.aspx" runat="server"><%# Eval("filename") %></asp:HyperLink>--%> <asp:HiddenField ID="hiddenAssetId" Value='<%# Eval("id") %>' runat="server" /> </div> </div> </ItemTemplate> <EmptyDataTemplate> No Assets Found </EmptyDataTemplate></telerik:RadListView>