protected void Button1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); OleDbDataAdapter da=new OleDbDataAdapter("Select NAME, PHONE FROM TBL_CITY WHERE POP='"+TextBox1.Text+"' and ROWNUM<150",conn); da.Fill(dt); RadGrid1.DataSource = dt; RadGrid1.DataBind(); }<telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True"> </telerik:RadGrid><telerik:RadGrid ID="RadCagri" runat="server" CellSpacing="0" Culture="tr-TR" Height="380px" GridLines="None" AllowPaging="True" AutoGenerateColumns="False" CssClass="Grid_Modul" AllowFilteringByColumn="True" AllowSorting="True" Skin="Simple"> <MasterTableView DataKeyNames="GERCEKADI" HierarchyLoadMode="Client" > <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> </EditFormSettings> <PagerStyle Mode="NextPrevAndNumeric" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="GERCEKADI" HeaderText="Çağrı Merkezi Uzm." FilterControlAltText="Filter GERCEKADI column" UniqueName="GERCEKADI" FilterControlWidth="250px"><ItemStyle Wrap="False" /></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TXTUNVAN" HeaderText="Müşteri Adı" FilterControlAltText="Filter TXTUNVAN column" UniqueName="AG" DataType="System.String" FilterControlWidth="400px"> <ItemStyle Wrap="False" /></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TXTPROJEADI" HeaderText="Proje" FilterControlAltText="Filter TXTPROJEADI column" DataType="System.String" UniqueName="TXTPROJEADI"> <ItemStyle Wrap="False" /></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="LNGMERKEZKOD" HeaderText="merkez Kod" FilterControlAltText="Filter LNGMERKEZKOD column" DataType="System.Int32" UniqueName="LNGMERKEZKOD" Display="false"> <ItemStyle Wrap="False" /></telerik:GridBoundColumn> <telerik:GridDateTimeColumn DataField="TRHTARIH" DataFormatString="{0:dd/MM/yyyy}" DataType="System.DateTime" FilterControlAltText="Filter TRHTARIH column" FilterControlWidth="150px" HeaderText="Arama Tarihi" UniqueName="TRHTARIH"> <ItemStyle Wrap="False" /></telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn DataField="TXTSAAT" DataFormatString="{0:HH:mm:ss}" DataType="System.DateTime" FilterControlWidth="100px" FilterControlAltText="Filter TXTSAAT column" HeaderText="Arama Saati" MinDate="" UniqueName="TXTSAAT"> </telerik:GridDateTimeColumn> <telerik:GridBoundColumn DataField="TXTDEPARTMAN" HeaderText="Çağrı Kuyruğu" FilterControlAltText="Filter TXTDEPARTMAN column" DataType="System.String" UniqueName="TXTDEPARTMAN"> <ItemStyle Wrap="False" /></telerik:GridBoundColumn> </Columns> </MasterTableView> <ClientSettings> <DataBinding Location="GridMasterDetailsService.svc" FilterParameterType="Linq" SelectMethod="GetCLG" SortParameterType="Linq" ShowEmptyRowsOnLoad="True"> </DataBinding> <ClientEvents OnDataBound="RadCagri_DataBound" OnDataBinding="RadCagri_DataBinding" OnGridCreated="RadCagriCriteria" /> <Selecting AllowRowSelect="True"></Selecting> <Scrolling AllowScroll="True"></Scrolling> </ClientSettings> <FilterMenu EnableImageSprites="False"> </FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu></telerik:RadGrid>RadCagri.ExportSettings.ExportOnlyData = True RadCagri.ExportSettings.IgnorePaging = True RadCagri.ExportSettings.OpenInNewWindow = True RadCagri.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerBind RadCagri.MasterTableView.ExportToExcel()<telerik:RadToolTipManager ID="RadToolTipManager1" OffsetY="-1" HideEvent="ManualClose" ShowEvent="OnClick" Skin="Office2010Silver" Width="500" Height="175" runat="server" OnAjaxUpdate="OnAjaxUpdate" RelativeTo="Element" Position="MiddleLeft" /> <asp:Repeater ID="rptrMyRepeater" runat="server" OnItemDataBound="myRepeater_OnItemDataBound"> <ItemTemplate> <div> <asp:LinkButton runat="server" ID="btnEmailAttachment" Text="Open Popup" OnClientClick="return false;" /> </div> </ItemTemplate> </asp:Repeater>
MyPage.aspx.cs
protected void myRepeater_OnItemDataBound(object o, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item) { RadToolTipManager1.TargetControls.Add(((LinkButton)e.Item.FindControl("btnEmailAttachment")).ClientID, Convert.ToString(DataBinder.Eval(e.Item.DataItem, "RequestID")), true); } } protected void OnAjaxUpdate(object sender, ToolTipUpdateEventArgs args) { int requestID = Convert.ToInt32(args.Value); Control ctrl = Page.LoadControl("EmailBox.ascx"); args.UpdatePanel.ContentTemplateContainer.Controls.Add(ctrl); CollateralCentral_EmailBox emailBox = (CollateralCentral_EmailBox)ctrl; emailBox.RequestID = requestID; }
EmailBox.ascx
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server"> <telerik:RadComboBox ID="drpdwnEmail1" runat="server" Width="350px" Height="140px" EnableLoadOnDemand="True" OnItemsRequested="RadComboBox1_ItemsRequested" /> </telerik:RadAjaxPanel>
EmailBox.ascx.cs
protected void RadComboBox1_ItemsRequested(object o, RadComboBoxItemsRequestedEventArgs e) { drpdwnEmail1.Items.Clear(); if (e.Text.Trim().Length > 2) // make them type at least 3 letters { DataTable dt = GetDataTable(); for (int i = 0; i < dt.Rows.Count; i++) { drpdwnEmail1.Items.Add(new RadComboBoxItem((string)dt.Rows[i]["Email_addr"], Convert.ToString(dt.Rows[i]["Email_addr"]))); } dt.Dispose(); } }I am not sure in this example how to get past this error - I need to load the control in the manner I am loading it and can't do it each time a postback happens, and I need to populate the email dropdown server-side because there are about 100,000 email addresses so I want them to start typing before they see anything...
Any help would be greatly appreciated!!!
RadGrid4.ExportSettings.ExportOnlyData =
False
RadGrid4.ExportSettings.IgnorePaging =
True
RadGrid4.ExportSettings.OpenInNewWindow =
True
RadGrid4.MasterTableView.ExportToExcel()
and it works just fine, but i would like to know if there is a way to export columns that are hidden, because i'm only showing 4 columns and there are like 50 columns on the table and i need to export all of them but i'm just getting the ones that are not hidden, is there a way get them all?
thanks in advanced.
