| <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LionsConnectionString %>" |
| SelectCommand="SELECT ArticleTitle, ArticleContent, ArticleDateTime, ArticleID FROM tblLionsArticles ORDER BY ArticleDateTime DESC"> |
| </asp:SqlDataSource> |
| <telerik:RadGrid ID="RadGrid2" runat="server" AllowPaging="True" DataSourceID="SqlDataSource1" |
| EnableEmbeddedSkins="False" GridLines="None" PageSize="3" ShowHeader="False" |
| OnItemCreated="RadGrid1_ItemCreated"> |
| <HeaderContextMenu EnableEmbeddedSkins="False"> |
| </HeaderContextMenu> |
| <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="ArticleID"> |
| <ItemTemplate> |
| <div class="apost"> |
| <%# Convert.ToDateTime(Eval("ArticleDateTime"))>=(DateTime.Now.AddDays(-7)) ? "<div class='firstPost'></div>" : ""%> |
| <div class="first"> |
| </div> |
| <div class="inner"> |
| <div class="inner"> |
| <div class="media"> |
| <a href='articles/default.aspx?ArticleID=<%# DataBinder.Eval (Container.DataItem, "ArticleID") %>'> |
| <img alt="" height="199" src="http://site/image.jpg" |
| width="135" /></a> |
| </div> |
| <h2 id="post-181"> |
| <a href='articles/default.aspx?ArticleID=<%# DataBinder.Eval (Container.DataItem, "ArticleID") %>' |
| rel="bookmark" title='<%# DataBinder.Eval (Container.DataItem, "ArticleTitle") %>'> |
| <asp:Label ID="ArticleTitle" runat="server" Text='<%# DataBinder.Eval (Container.DataItem, "ArticleTitle") %>'></asp:Label> |
| </a> |
| </h2> |
| <ul class="info"> |
| <li class="ptime">Posted on: |
| <asp:Label ID="ArticleDateTime" runat="server" Text=' <%#Convert.ToDateTime(DataBinder.Eval (Container.DataItem, "ArticleDateTime")).AddHours(3) %>'></asp:Label> |
| </li> |
| <li class="pcomm">Those Who Had Their Say: |
| <asp:SqlDataSource ID="SqlDataSource_FV1" runat="server" ConnectionString="<%$ ConnectionStrings:LionsConnectionString %>" |
| SelectCommand="SELECT COUNT(Art_Comment_Rating) AS 'Art_Comment_Rating_Count' FROM [tblLionsArticlesComments] WHERE ([ArticleID] = @ArticleID)"> |
| <SelectParameters> |
| <asp:ControlParameter ControlID="RadGrid2" Name="ArticleID" PropertyName="SelectedValue" |
| Type="Empty" /> |
| </SelectParameters> |
| </asp:SqlDataSource> |
| <asp:DataList ID="DataList1" DataSourceID="SqlDataSource_FV1" runat="server"> |
| <ItemTemplate> |
| <asp:Label ID="Greg" runat="server" Text='<%# DataBinder.Eval (Container.DataItem, "Art_Comment_Rating_Count") %>'></asp:Label> |
| </ItemTemplate> |
| </asp:DataList> |
| </li> |
| </ul> |
| <div class="pmain"> |
| <!-- spost --> |
| <asp:Label ID="ArticleContent" runat="server" Text='<%# Truncate(DataBinder.Eval (Container.DataItem, "ArticleContent")) %>'></asp:Label> |
| <!-- epost --> |
| </div> |
| <ul class="pfoot"> |
| <li><a href='articles/default.aspx?ArticleID=<%# DataBinder.Eval (Container.DataItem, "ArticleID") %>'> |
| continue reading post »</a></li> |
| </ul> |
| </div> |
| </div> |
| <div class="second"> |
| </div> |
| </div> |
| </ItemTemplate> |
| iv id="ctl00_ContentPlaceHolder1_RadGrid2" class="RadGrid RadGrid_Default" tabindex="0"> |
| <table id="ctl00_ContentPlaceHolder1_RadGrid2_ctl00" class="rgMasterTable" cellspacing="0" border="0" style="width: 100%; table-layout: auto; empty-cells: show;"> |
| <colgroup> |
| </colgroup> |
| <thead> |
| </thead> |
| <tfoot> |
| </tfoot> |
| <tbody> |
| <tr id="ctl00_ContentPlaceHolder1_RadGrid2_ctl00__0" class="rgRow"> |
| <td colspan="4"> |
| <div class="apost"> |
| <div class="first"> </div> |
| <div class="inner"> |
| <div class="inner"> |
| <div class="media"> |
| </div> |
| <h2 id="post-181"> |
| </h2> |
| <ul class="info"> |
| <li class="ptime"> |
| </li> |
| <li class="pcomm">Those Who Had Their Say: </li> |
| </ul> |
| <div class="pmain"> |
| </div> |
| <ul class="pfoot"> |
| </ul> |
| </div> |
| </div> |
| <div class="second"> </div> |
| <li class="pcomm">Those Who Had Their Say: </li> |
| public class CategoryInfo |
| { |
| public int ModuleId{get; set;} |
| public int ItemId{get; set;} |
| public int CreatedByUser{get; set;} |
| public string Content { get; set; } |
| public DateTime CreatedDate{get; set;} |
| public string CategoryDescription{ get; set;} |
| public int? ParentId { get; set; } |
| } |
| var objCategories = new CategoryController(); |
| RadTreeView1.DataSource = objCategories.GetCategories(ModuleId); |
| RadTreeView1.DataTextField = "CategoryDescription"; |
| RadTreeView1.DataValueField = "ItemId"; |
| RadTreeView1.DataFieldParentID = "ParentId"; |
| RadTreeView1.DataBind(); |
<
script type="text/javascript">
var
_selectedRow;
var rowindex;
function grdResult_RowSelected(sender, args)
{
_selectedRow = $get(args.get_id());
rowindex = _selectedRow.sectionRowIndex;
var myAppKey = "<%= hdnradGridClickedRowIndex.ClientID %>";
document.getElementById(myAppKey).value = rowindex;
}<
telerik:RadGrid ID="grdResult" runat="server" Width="1198px"
AllowMultiRowSelection="True" AllowSorting="True" Height="552px" style="margin-right: 1px" >
<MasterTableView Width="100%">
<Columns>
<telerik:GridClientSelectColumn UniqueName="SEL" Text="SEL"></telerik:GridClientSelectColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Scrolling AllowScroll="True" SaveScrollPosition="True"/>
<Resizing ClipCellContentOnResize="False" />
<Selecting AllowRowSelect="true" UseClientSelectColumnOnly="true" />
<ClientEvents OnRowContextMenu="grdResult_RowSelected" />
</ClientSettings>
</
telerik:RadGrid>
Private Sub btnReport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnReport.Click
grdResult.ExportSettings.OpenInNewWindow = True
grdResult.ExportSettings.IgnorePaging =
True
grdResult.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML
grdResult.MasterTableView.ExportToExcel()
End Sub
Please let me know what is wrong here. Exporttoexcel() functionality is not working.
Thanks,
M.Raji
| <%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Master.master.cs" Inherits="PRSAdminTelerik.Pages.Master" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" > |
| <head runat="server"> |
| <title>PRS Administration</title> |
| <link href="../Includes/Default.css" type="text/css" rel="stylesheet" /> |
| <script language="javascript" src="../Includes/Default.js" type="text/javascript"></script> |
| <asp:ContentPlaceHolder ID="head" runat="server"> |
| </asp:ContentPlaceHolder> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> |
| <img style="LEFT: 0px;POSITION: absolute; TOP: 0px" height="79" alt="" |
| src="..\images\hoover.jpg"/> |
| <div style="position:absolute;left:304px; top: 26px; height: 18px; width: 200px;"> |
| <asp:Label ID="userLabel" runat="server" Text="Label" CssClass="TextReadOnly"></asp:Label> |
| </div> |
| <div> |
| <asp:Label ID="Label1" runat="server" Text="PRS Administration" |
| style="position:absolute;left:69px; top:18px; font-size:larger"></asp:Label> |
| <asp:Label ID="environmentLabel" runat="server" |
| style="LEFT:536px; POSITION: absolute; TOP:22px" Text="" CssClass="PageWarning"></asp:Label> |
| <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="http://ww2t.wapa.gov/sites/western/prshelp/Pages/default.aspx" |
| style="z-index:1; position:absolute; top:26px; left:830px;">PRS Help</asp:HyperLink> |
| </div> |
| <div style="position:absolute; top:70; left:76; width:1000px; "> |
| <telerik:RadMenu ID="RadMenu1" runat="server" |
| style="z-index:1; position:absolute; top: 53px; left: 59px;"> |
| <Items> |
| <telerik:RadMenuItem Text="Home" runat="server" NavigateUrl="Default.aspx"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Accounts" runat="server"> |
| <Items> |
| <telerik:RadMenuItem Text="Administer" runat="server" NavigateUrl="PlantAccountAdministration.aspx"></telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Construction Cost Trend" runat="server" > |
| <Items> |
| <telerik:RadMenuItem Text="Multiplier Update" runat="server" NavigateUrl="CostConstructionMultiplier.aspx"></telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Interest Rates" runat="server"> |
| <Items> |
| <telerik:RadMenuItem Text="Current" runat="server" NavigateUrl="InterestRatesCurrent.aspx"></telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Power System" runat="server" NavigateUrl="PowerSystemAdministration.aspx"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Study" runat="server"> |
| <Items> |
| <telerik:RadMenuItem Text="Administer" runat="server" NavigateUrl="StudyAdministration.aspx"></telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Reports" runat="server" NavigateUrl="ReportAdministration.aspx"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Templates" runat="server"> |
| <Items> |
| <telerik:RadMenuItem Text="Administer" runat="server" NavigateUrl="TemplateAdministration.aspx"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Master" runat="server" NavigateUrl="TemplateMaster.aspx"></telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem Text="Users" runat="server"> |
| <Items> |
| <telerik:RadMenuItem Text="Administer" runat="server" NavigateUrl="Default.aspx"></telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenu> |
| </div> |
| <div> |
| <asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server"> |
| </asp:ContentPlaceHolder> |
| </div> |
| </form> |
| </body> |
| </html> |
| if (!this.IsPostBack) |
| { |
| RadMenuItem item = RadMenu1.FindItemByUrl(Request.Url.PathAndQuery); |
| if (item != null) |
| { |
| item.HighlightPath(); |
| } |
| } |
| var node = new Telerik.Web.UI.RadTreeNode(); |
| node.set_text("New Node"); |
| node.set_value("newValue"); |
| var myTree = $find('<%= myTreeView.ClientID%>'); |
| myTree.trackChanges(); |
| node.get_textElement().title = "myToolTip"; // This line gives an error saying get_textElement is null |
| myTree.get_nodes.add(node) |
| myTree.commitChanges() |
| for (j = 0; i < 5 && j < selectedItems.length; i++, j++) { |
| //create an new page view |
| pageView = new Telerik.Web.UI.RadPageView(); |
| pageView.set_id(("DocView" + i)); |
| multiPage.trackChanges(); |
| multiPage.get_pageViews().add(pageView); |
| multiPage.commitChanges(); |
| tabStripItem = new Telerik.Web.UI.RadTab(); |
| tabStripItem.set_text("new tab"); |
| tabStripItem.set_pageViewID("DocView" + i); |
| tabStripItem.set_selected(); |
| tabStrip.trackChanges(); |
| tabStrip.get_tabs().add(tabStripItem); |
| AttachCloseImage(tabStripItem, "Images/delete.gif"); |
| tabStrip.commitChanges(); |
| tabStrip.set_selectedIndex(i); |
| } |
| } |
| function CreateCloseImage(closeImageUrl) { |
| debugger |
| var closeImage = document.createElement("img"); |
| closeImage.src = closeImageUrl; |
| closeImage.style.marginTop = "2px"; |
| closeImage.style.position = "relative"; |
| closeImage.style.border = "none"; |
| closeImage.style.right = "-10px"; |
| closeImage.alt = "Close this tab"; |
| return closeImage; |
| } |
| function AttachCloseImage(tab, closeImageUrl) { |
| var closeImage = CreateCloseImage(closeImageUrl); |
| closeImage.AssociatedTab = tab; |
| closeImage.onclick = function(e) { |
| if (!e) e = event; |
| if (!e.target) e = e.srcElement; |
| deleteTab(tab); |
| e.cancelBubble = true; |
| if (e.stopPropagation) { |
| e.stopPropagation(); |
| } |
| return false; |
| } |
| tab.get_innerWrapElement().appendChild(closeImage); |
| } |
| function deleteTab(tab) { |
| var tabStrip = $find("<%= RadTabStrip1.ClientID %>"); |
| var pageView = tab.get_pageView(); |
| var tabToSelect = tab.get_nextTab(); |
| var multiPage = $find("<%= RadMultiPage1.ClientID %>"); |
| if (!tabToSelect) |
| tabToSelect = tab.get_previousTab(); |
| tabStrip.trackChanges(); |
| multiPage.trackChanges(); |
| tabStrip.get_tabs().remove(tab); |
| multiPage.get_pageViews().remove(pageView); |
| if (tabToSelect) |
| tabToSelect.set_selected(true); |
| multiPage.commitChanges(); |
| tabStrip.commitChanges(); |
| } |
