| RadGrid1.VirtualItemCount = Catalog.ItemCount(Me.txtSearch.Text.Trim, _ |
| txtRangeFrom.Text, txtRangeTo.Text, _ |
| IIf(cmbDepartments.SelectedValue <> "", cmbDepartments.SelectedValue, 0), _ |
| IIf(cmbCategories.SelectedValue <> "", cmbCategories.SelectedValue, 0), _ |
| 0) |
| RadGrid1.DataSource = Catalog.GetProducts(Me.txtSearch.Text.Trim, _ |
| txtRangeFrom.Text, txtRangeTo.Text, _ |
| IIf(cmbDepartments.SelectedValue <> "", cmbDepartments.SelectedValue, 0), _ |
| IIf(cmbCategories.SelectedValue <> "", cmbCategories.SelectedValue, 0), _ |
| 0, Me.RadGrid1.CurrentPageIndex + 1, 10) |
| <telerik:RadGrid ID="gvFirmInfo" runat="server" Width="550px"> |
| <MasterTableView |
| EditMode="PopUp" |
| CommandItemDisplay="Bottom" CommandItemStyle-BackColor = "#D8D8D8" |
| ShowHeader="true" ShowHeadersWhenNoRecords="false" NoMasterRecordsText="" |
| HeaderStyle-Font-Bold="true" HeaderStyle-BackColor ="#D8D8D8" |
| ItemStyle-BackColor="White" ItemStyle-BorderColor="#C9C4D1" |
| ItemStyle-BorderStyle="Solid" ItemStyle-BorderWidth="1px" |
| AlternatingItemStyle-BackColor="#E0E0E0" AlternatingItemStyle-BorderStyle="Solid" |
| AlternatingItemStyle-BorderWidth="0px" AlternatingItemStyle-BorderColor="#FFFFFF" |
| BorderColor="#C9C4D1" BorderWidth="1px" BorderStyle="Solid" |
| GridLines="None"> |
| <CommandItemTemplate> |
| <div style="text-align: right; padding: 8px;"> |
| <asp:Button ID="Button1" Text="Add Firm Location" |
| Runat="server" CommandName="InitInsert"></asp:Button> |
| </div> |
| </CommandItemTemplate> |
| <Columns> |
| <telerik:GridBoundColumn DataField="city" HeaderText="City"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Country" HeaderText="Country"> |
| </telerik:GridBoundColumn> |
| <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="columnDelete" |
| ConfirmText="Are you sure you want to delete this record?"> |
| </telerik:GridButtonColumn> |
| <telerik:GridEditCommandColumn UniqueName="EditCommandColumn"> |
| </telerik:GridEditCommandColumn> |
| </Columns> |
| <EditFormSettings> |
| <!-- I have a custom edit form in here --> |
| </EditFormSettings> |
| </MasterTableView> |
| <ClientSettings> |
| <ClientEvents OnPopUpShowing="PopUpShowing" /> |
| </ClientSettings> |
| </telerik:RadGrid> |
| Protected Sub gvFirmInfo_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles gvFirmInfo.NeedDataSource |
| Dim sqlString As String = "" |
| Dim sqlparam(2) As SqlParameter |
| Dim ds As New DataSet |
| Dim dr As SqlDataReader = Nothing |
| Try |
| SetParam(sqlparam(0), "@recId", Data.SqlDbType.Int, 4, m_rec_id) |
| SetParam(sqlparam(1), "@recType", Data.SqlDbType.Char, 2, m_rec_type) |
| sqlString = "SELECT ... FROM..." |
| ds = SqlHelper.ExecuteDataset(Conn, Data.CommandType.Text, sqlString, sqlparam) |
| gvFirmInfo.DataSource = ds |
| Catch ex As Exception |
| End Try |
| End Sub |
| <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(); |
| } |
| } |