<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm3.aspx.cs" Inherits="RadControlsWebApp1.WebForm3" %><!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 id="Head1" runat="server"> <title></title> <telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server" /> <style type="text/css"> body { font-family: Arial, Helvetica, Sans-Serif; font-size: 11pt; color: Black; } div.MasterContainer { width: 600px; height: 400px; padding: 0px; margin: auto; margin-top: 40px; } </style></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> <Scripts> <%--Needed for JavaScript IntelliSense in VS2010--%> <%--For VS2008 replace RadScriptManager with ScriptManager--%> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> </Scripts> </telerik:RadScriptManager> <script type="text/javascript"> //Put your JavaScript code here. </script> <div class="MasterContainer"> <telerik:RadTabStrip ID="RadTabStrip1" runat="server" MultiPageID="RadMultiPage1" SelectedIndex="0" Skin="Hay" Width="100%"> <Tabs> <telerik:RadTab runat="server" Text="Tab1" Value="Tab1" Owner="RadTabStrip1" PageViewID="rpvTab1" /> <telerik:RadTab runat="server" Text="Tab2" Value="Tab2" Owner="RadTabStrip1" PageViewID="rpvTab2" /> </Tabs> </telerik:RadTabStrip> <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0"> <telerik:RadPageView ID="rpvTab1" runat="server" Width="100%" > <table style="padding: 0px; margin: 0px; border-style: none; border-width: 0px; width: 500px;"> <tr> <td> Title: </td> <td> <telerik:RadTextBox ID="RadTextBox1" runat="server" Enabled="true" MaxLength="100" Text="Test" Width="240px"> </telerik:RadTextBox> </td> </tr> <tr> <td> Gender: </td> <td> <telerik:RadComboBox ID="RadComboBox1" runat="server" EmptyMessage="Choose Gender" Width="240px"> <Items> <telerik:RadComboBoxItem runat="server" Text="Male" Value="Male" /> <telerik:RadComboBoxItem runat="server" Text="Female" Value="Female" /> </Items> </telerik:RadComboBox> </td> </tr> </table> </telerik:RadPageView> <telerik:RadPageView ID="rpvTab2" runat="server" Width="100%"> <table style="padding: 0px; margin: 0px; border-style: none; border-width: 0px; width: 500px;"> <tr> <td> Title: </td> <td> <telerik:RadTextBox ID="txtTitle" runat="server" Enabled="true" MaxLength="100" Text="Test" Width="240px"> </telerik:RadTextBox> </td> </tr> <tr> <td> Gender: </td> <td> <telerik:RadComboBox ID="cmbxGender" runat="server" EmptyMessage="Choose Gender" Width="240px"> <Items> <telerik:RadComboBoxItem runat="server" Text="Male" Value="Male" /> <telerik:RadComboBoxItem runat="server" Text="Female" Value="Female" /> </Items> </telerik:RadComboBox> </td> </tr> </table> </telerik:RadPageView> </telerik:RadMultiPage> </div> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> </telerik:RadAjaxManager> </form></body></html>So, I've boiled it down to a simple case that I think captures all the important parts of my implementation. There's a commented section in the code-behind that can be uncommented to enable Load on Demand. I didn't supply any of my futile implementations in TreeView_NodeExpand because none of them have worked. I'm asking for what might go in there to make this example work.
My aspx file is:
<%@ Page AutoEventWireup="true" CodeFile="DefaultCS.aspx.cs" Inherits="Telerik.Web.Examples.Grid.Integration.GridWithTreeViewComboBoxEditors.DefaultCS" Language="c#" %> <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"></head> <body class="BODY"> <form runat="server" id="mainForm" method="post"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" /> <asp:UpdatePanel RunAt="Server"> <ContentTemplate> <telerik:RadGrid ID="FooGrid" OnNeedDataSource="FooGrid_NeedDataSource" OnItemDataBound="FooGrid_ItemDataBound" AutoGenerateEditColumn="true" runat="server" > <MasterTableView> <EditFormSettings EditFormType="Template"> <FormTemplate> <telerik:RadTreeView ID="TreeView" DataTextField="Text" DataFieldID="Key" DataFieldParentID="Parent" DataValueField="Key" OnNodeExpand="TreeView_NodeExpand" RunAt="Server" > <NodeTemplate> <telerik:RadButton ButtonType="ToggleButton" ToggleType="CheckBox" AutoPostBack="false" Checked='<%# Bind("CanView") %>' Text="View" ID="CanViewButton" RunAt="Server" /> <telerik:RadButton ButtonType="ToggleButton" ToggleType="CheckBox" AutoPostBack="false" Text="Alter" RunAt="Server" /> - <%# DataBinder.Eval(Container, "Text") %> </NodeTemplate> </telerik:RadTreeView> <telerik:RadButton Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>' CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>' RunAt="Server" /> <telerik:RadButton Text="Cancel" CommandName="Cancel" RunAt="Server" /> </FormTemplate> </EditFormSettings> </MasterTableView> </telerik:RadGrid> </ContentTemplate> </asp:UpdatePanel> </form> </body> </html>And my code-behind is:
using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Web.UI; using Telerik.Web.UI; using System; using System.Collections.Generic; namespace Telerik.Web.Examples.Grid.Integration.GridWithTreeViewComboBoxEditors { public partial class DefaultCS : Page { public void FooGrid_NeedDataSource(Object sender, GridNeedDataSourceEventArgs e) { FooGrid.DataSource=new GreekGods(); } public void FooGrid_ItemDataBound(Object sender, GridItemEventArgs e) { GridEditFormItem item=e.Item as GridEditFormItem; if (item != null && item.IsInEditMode) { RadTreeView treeView=item.FindControl("TreeView") as RadTreeView; if (treeView != null) { treeView.DataSource=new TreeDataList(); treeView.DataBind(); // To enable Load on Demand, uncomment these lines // foreach (RadTreeNode pNode in treeView.Nodes) { // pNode.ExpandMode=TreeNodeExpandMode.ServerSideCallBack; // pNode.Nodes.Clear(); // } } } } public void TreeView_NodeExpand(Object sender, RadTreeNodeEventArgs e) { // What can go in here that will allow me to create nodes according to // the NodeTemplate in the aspx file. } } //////////// From here down is just canned data public class GreekGod { private string name; public string Name { get { return name; } set { name = value; } } private string description; public string Description { get { return description; } set { description = value; } } private string romanName; public string RomanName { get { return romanName; } set { romanName = value; } } public GreekGod(string name, string description, string romanName) { this.name = name; this.description = description; this.romanName = romanName; } } public class GreekGods : List<GreekGod> { public GreekGods() { this.Add(new GreekGod("Aphrodite", "Goddess of love, beauty and fertility", "Venus")); this.Add(new GreekGod("Apollo", "God of prophesy, music and healing", "Apollo")); this.Add(new GreekGod("Ares", "God of war", "Mars")); } } public class TreeData { private string key; public string Key { get { return key; } set { key=value; } } private string text; public string Text { get { return text; } set { text=value; } } private string parent; public string Parent { get { return parent; } set { parent=value; } } private bool canView; public bool CanView { get { return canView; } set { canView=value; } } public TreeData(string key, string text, string parent) { Key=key; Text=text; Parent=parent; } } public class TreeDataList: List<TreeData> { public TreeDataList() { Add(new TreeData("0", "P1", null)); this[0].CanView=true; Add(new TreeData("1", "P1C1", "0")); Add(new TreeData("2", "P2", null)); Add(new TreeData("3", "P2C1", "2")); Add(new TreeData("4", "P2C2", "2")); Add(new TreeData("5", "P3", null)); Add(new TreeData("6", "P3C1", "5")); } } }Thanks.
kd
<telerik:RadGrid ID="GridComplianceReport" Width="100%" AllowPaging="True" PageSize="30" runat="server" AllowSorting="true" Visible="false" OnNeedDataSource="GridComplianceReport_NeedDataSource" GridLines="None" > <MasterTableView Width="100%" /> <PagerStyle Mode="NextPrevAndNumeric" /> </telerik:RadGrid>protected void GridComplianceReport_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e) { Employee parentEmployee = new Employee(); Employee childEmployee = new Employee(); if (Session["Employee"] != null) { parentEmployee = (Employee)Session["Employee"]; } if (Session["ChildEmployee"] != null) { childEmployee = (Employee)Session["ChildEmployee"]; if (Session["SelectedEmployeeID"].ToString() == parentEmployee.EmployeeID) { FillComplianceReport(parentEmployee); } else { FillComplianceReport(childEmployee); } } else //no child employee, populate with logged in employee { FillComplianceReport(parentEmployee); } } private void FillComplianceReport(Employee employee) { lblReportsHeader.Text = employee.Name; string who = ""; ArrayList complianceType = new ArrayList(); ArrayList complianceStatus = new ArrayList(); List<Reports> complianceReport = new List<Reports>(); who = rdbEmployeeType.SelectedItem.Value; foreach (ListItem item in chkComplianceTypes.Items) { if (item.Selected) complianceType.Add(item.Value); } foreach (ListItem item in chkComplianceStatus.Items) { if (item.Selected) complianceStatus.Add(item.Value); } complianceReport = EmployeeBLL.GetComplianceReports(employee.EmployeeID, who, complianceType, complianceStatus); Session["ComplianceReport"] = complianceReport; GridComplianceReport.DataSource = complianceReport; if (compliancereport.Count > 0) GridComplianceReport.Visible = true; ReportsExceptionPanel.Visible = false; }protected void btnGenerateComplianceReport_Click(object sender, ImageClickEventArgs e) { GridComplianceReport.Visible = true; GridComplianceReport.DataSource = null; GridComplianceReport.Rebind(); }RadWindow newWindow = new Telerik.Web.UI.RadWindow();newWindow.ID = "HelpDeskMessageWindow";newWindow.NavigateUrl = "ErrorPopup.aspx";newWindow.AutoSize = true;newWindow.Modal = true;RadWindowManager1.Windows.Add(newWindow);newWindow.VisibleOnPageLoad = true;Telerik Support,
I am receiving the following error “The operation could not be completed. Invalid FORMATETC structure” when trying to add the “RADEDITOR” Telerik Control to my page. Please find the environment details below with the mail. Also, I have attached the snapshot of the error.
Environment Details:
OS: Windows-7
IDE: Visual Studio 2008
Project using: .NET Framework 3.5
Ajax Control Toolkit Version: 3.5.50731.0
Thanks & Regards,
Varun
Message: Unexpected call to method or property access.Line: 1063Char: 32442Code: 0URI: http://localhost:3895/..../Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=ctl00_RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=%3b%3bSystem.Web.Extensions%2c+Version%3d3.5.0.0%2c+Culture%3dneutral%2c+PublicKeyToken%3d31bf3856ad364e35%3aen-US%3a553a4a13-b3a5-4e6b-a152-b131051f1788%3aea597d4b%3ab25378d2%3bTelerik.Web.UI%3aen-US%3a99e38628-ac51-4787-84f7-90d827ba8fe8%3a16e4e7cd%3af7645509%3a22a6274a%3a24ee1bba%3af46195d3%3a2003d0b8%3a1e771326%3aaa288e2d%3a7165f74%3a58366029%3a874f8ea2%3ac172ae1e%3a9cdfc6e7%3ae330518b%3ac8618e41%3ae4f8f289<asp:Content ID="Step1Content" ContentPlaceHolderID="ContentHolder" Runat="Server"> <asp:UpdatePanel ID="uxInformationPanel" runat="server"> <ContentTemplate> <div class="form1"> . . <div id="uxBlackOwnershipPanel" style="display:none;"> . . <asp:UpdatePanel ID="updateBlackOwnership" runat="server"> <ContentTemplate> . . . <div class="input_slide"> <telerik:RadButton ID="uxBlackOwnershipAdd" OnClick="uxBlackOwnershipAdd_Click" Text="Add" EnableEmbeddedSkins="false" Skin="CustomButton" runat="server" /> </div> <div class="input_slide"> <telerik:RadGrid ID="uxBlackOwnershipGrid"> . . </telerik:RadGrid> </div> </ContentTemplate> </asp:UpdatePanel> . . </div> </ContentTemplate> </asp:UpdatePanel> <script type="text/javascript"> window.jQuery = window.$ = $telerik.$; function pageLoad(sender, args) { $("#<%=uxBlackOwnershipYes.ClientID%>").click(function() { $("#uxBlackOwnershipPanel").show(); }); $("#<%=uxBlackOwnershipNo.ClientID%>").click(function() { $("#uxBlackOwnershipPanel").hide(); }); var blackOwnership = $("#<%=uxBlackOwnershipYes.ClientID%>"); if (blackOwnership.attr("checked") != "undefined" && blackOwnership.attr("checked") == "checked") { $("#uxBlackOwnershipPanel").show(); } }</script></asp:Content><telerik:RadScriptManager runat="server" ID="RadScriptManager1"> <Scripts> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> </Scripts> </telerik:RadScriptManager>| <telerik:RadMenu ID="RadMenu1" |
| Runat="server" |
| Skin="Web20_PL" |
| EnableEmbeddedSkins="False" |
| CssClass="MasterMenu" |
| ForeColor="#467464"> |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
| <Items> |
| <telerik:RadMenuItem runat="server" |
| NavigateUrl="Default.aspx" |
| Text="Home" |
| ForeColor="#467464"> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem runat="server" |
| NavigateUrl="Exposure.aspx" |
| Text="Exposure" |
| AccessKey="E" |
| ForeColor="#467464"> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem runat="server" |
| Text="Cash" |
| ForeColor="#467464" |
| AccessKey="C"> |
| <Items> |
| <telerik:RadMenuItem runat="server" |
| NavigateUrl="CashSummary.aspx" |
| Text="Summary" |
| AccessKey="S"> |
| </telerik:RadMenuItem> |
| <telerik:RadMenuItem runat="server" |
| NavigateUrl="CashAuthorisation.aspx" |
| Text="Authorisation" |
| AccessKey="A"> |
| </telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenuItem> |
| </Items> |
| </telerik:RadMenu> |
| Error Creating Control - RadMenu1 'Items' could not be initialized. |
| Details: |
| Unable to cast object of type 'Telerik.Web.UI.RadMenuItemCollection' to type |
| 'Telerik.Web.UI.RadMenuItemCollection'.<BR> |
Private Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load If Page.IsPostBack Then Exit Sub Dim sSQLText As String = "SELECT Currency_CountryCode, Currency_CountryDesc, CurrencyTarget_CountryCode, Currency_LastUpdated, Currency_DisplayOrder FROM Currency_LatestConversions_TBL LEFT OUTER JOIN Currency_CurrentlyTracked ON Currency_LatestConversions_TBL.Currency_CountryCode = Currency_CurrentlyTracked.CurrencyTarget_CountryCode " If Page.User.Identity.Name.ToString.ToUpper = "RSCOTT" Then sSQLText &= "ORDER BY Existing, Currency_LatestConversions_TBL.Currency_CountryDesc" Else sSQLText &= "ORDER BY Currency_DisplayOrder" End If SqlDataSource1.SelectCommand = sSQLText RadGrid1.DataBind()End Sub<body> <form id="form1" runat="server"> <div> <asp:Label ID="Label1" runat="server" Text="Don Beaty's Foreign Currency Tracker" Font-Bold="False" Font-Names="Calibri" Font-Size="XX-Large"></asp:Label> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager> <telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" BorderColor="Gray" BorderStyle="Inset" Skin="Office2010Silver" > <MasterTableView AutoGenerateColumns="False" DataSourceID="SqlDataSource1" commanditemdisplay="None" allowpaging="True" EditMode="InPlace" PageSize="30" Width="100%" Name="Currency" showgroupfooter="True" BorderColor="#E0E0E0" BorderStyle="Solid" BorderWidth="1px" GridLines="Vertical" DataKeyNames="Currency_CountryCode, Currency_BriefcaseUsed, Currency_HomeOfficeUsed, Currency_OneHundUsed, Currency_LastUpdated"> <Columns> <telerik:GridTemplateColumn FilterControlAltText="Filter EditCommandColumn column" Groupable="False" UniqueName="EditCommandColumn"> <ItemTemplate> <asp:LinkButton ID="lbuEditP" runat="server" CausesValidation="false" CommandName="Edit" Text="Edit"></asp:LinkButton> </ItemTemplate> <EditItemTemplate> <asp:LinkButton ID="lbuUpdateP" runat="server" CommandName="Update" Text="Update"></asp:LinkButton> <asp:LinkButton ID="lbuCancelUpdateP" runat="server" CausesValidation="false" CommandName="Cancel" Text="Cancel"></asp:LinkButton> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="Currency_CountryDesc" FilterControlAltText="Filter Currency_CountryDesc column" HeaderText="Currency" SortExpression="Currency_CountryDesc" UniqueName="Currency_CountryDesc" ReadOnly="True"> <HeaderStyle VerticalAlign="Bottom"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ExchangeRate" DataType="System.Decimal" FilterControlAltText="Filter Currency_Conversion column" HeaderText="Exchange Rate" SortExpression="ExchangeRate" ItemStyle-HorizontalAlign="Right" HeaderStyle-HorizontalAlign="Center" UniqueName="ExchangeRate" ReadOnly="True"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle> <ItemStyle HorizontalAlign="Right"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Flag Briefcase<br/>(With DLB)" FilterControlAltText="Filter Currency_BriefcaseUsed column" UniqueName="Currency_BriefcaseUsed"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle> <ItemStyle HorizontalAlign="Center"></ItemStyle> <EditItemTemplate> <asp:CheckBox ID="CheckBoxA" runat="server" Checked='<%# Bind("Currency_BriefcaseUsed") %>' /> </EditItemTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBoxB" runat="server" Checked='<%# Bind("Currency_BriefcaseUsed") %>' OnCheckedChanged="UpdateBriefcaseFlag" autopostback="true"/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Flag Home<br/>(With DLB)" FilterControlAltText="Filter Currency_HomeOfficeUsed column" UniqueName="Currency_HomeOfficeUsed"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle> <ItemStyle HorizontalAlign="Center"></ItemStyle> <EditItemTemplate> <asp:CheckBox ID="CheckBoxC" runat="server" Checked='<%# Bind("Currency_HomeOfficeUsed") %>' /> </EditItemTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBoxD" runat="server" Checked='<%# Bind("Currency_HomeOfficeUsed") %>' OnCheckedChanged="UpdateHomeOfficeFlag" autopostback="true"/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Flag 100<br/>(With DLB)" FilterControlAltText="Filter Currency_OneHundUsed column" UniqueName="Currency_OneHundUsed"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle> <ItemStyle HorizontalAlign="Center"></ItemStyle> <EditItemTemplate> <asp:CheckBox ID="CheckBoxE" runat="server" Checked='<%# Bind("Currency_OneHundUsed") %>' /> </EditItemTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBoxF" runat="server" Checked='<%# Bind("Currency_OneHundUsed") %>' OnCheckedChanged="UpdateOneHundFlag" autopostback="true"/> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="Currency_EnvelopeCount500" DataType="System.Int16" FilterControlAltText="Filter Currency_EnvelopeCount500 column" HeaderText="500 Env. Count<br/>Needed<br/>(With Accounting)" SortExpression="Currency_EnvelopeCount500" UniqueName="Currency_EnvelopeCount500"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle> <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Currency_EnvelopeCount100" DataType="System.Int16" FilterControlAltText="Filter Currency_EnvelopeCount100 column" HeaderText="100 Env. Count<br/>Needed<br/>(With Accounting)" SortExpression="Currency_EnvelopeCount100" UniqueName="Currency_EnvelopeCount100"> <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle> <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Currency_EnvelopeCount500_Ready" DataType="System.Int16" FilterControlAltText="Filter Currency_EnvelopeCount500_Ready column" HeaderText="500 Env. Count<br/>On Hand<br/>(With Accounting)" SortExpression="Currency_EnvelopeCount500_Ready" UniqueName="Currency_EnvelopeCount500_Ready"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Bottom"></HeaderStyle> <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Currency_EnvelopeCount100_Ready" DataType="System.Int16" FilterControlAltText="Filter Currency_EnvelopeCount100_Ready column" HeaderText="100 Env. Count<br/>On Hand<br/>(With Accounting)" SortExpression="Currency_EnvelopeCount100_Ready" UniqueName="Currency_EnvelopeCount100_Ready"> <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle> <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Currency_DisplayOrder" DataType="System.Int16" FilterControlAltText="Filter Currency_DisplayOrder column" HeaderText="Display<br/>Order" SortExpression="Currency_DisplayOrder" UniqueName="Currency_DisplayOrder"> <HeaderStyle HorizontalAlign="Center" CssClass="maximize"></HeaderStyle> <ItemStyle HorizontalAlign="Center" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> </Columns> <DetailTables> <telerik:GridTableView runat="server" DataKeyNames="Currency_ID" EditMode="InPlace" CommandItemDisplay="Bottom" Width="100%" DataSourceID="SqlDataSource2" AutoGenerateColumns="False" ShowGroupFooter="True" > <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="Currency_CountryCode" MasterKeyField="Currency_CountryCode" /> </ParentTableRelation> <CommandItemSettings ExportToPdfText="Export to PDF" /> <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> <Columns> <telerik:GridEditCommandColumn FilterControlAltText="Filter EditCommandColumn column" InsertText="Save"> <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle> </telerik:GridEditCommandColumn> <telerik:GridTemplateColumn DataField="CurrencyTarget_ForeignDenomination" DataType="System.Int32" FilterControlAltText="Filter CurrencyTarget_ForeignDenomination column" HeaderText="Foreign<br/>Currency<br/>Denomination" SortExpression="CurrencyTarget_ForeignDenomination" UniqueName="CurrencyTarget_ForeignDenomination"> <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle> <InsertItemTemplate> <asp:TextBox ID="CurrencyTarget_ForeignDenomination" runat="server" Text='<%# Bind("CurrencyTarget_ForeignDenomination") %>'></asp:TextBox> </InsertItemTemplate> <ItemTemplate> <asp:Label ID="CurrencyTarget_ForeignDenominationLabel" runat="server" Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:Label ID="CurrencyTarget_ForeignDenominationLabel2" runat="server" Text='<%# Eval("CurrencyTarget_ForeignDenomination") %>'></asp:Label> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="USDEquivalent" HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDEquivalent" UniqueName="USDEquivalent" FilterControlAltText="Filter USDEquivalent column" DataType="System.Decimal" DataFormatString="${0:#}" ReadOnly="True" > <ItemStyle HorizontalAlign="Right" BorderColor="Black"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CurrencyTarget_FCNeeded" HeaderText="Enter<br/>Quantity to be Included<br/>for 1 '500'<br/>Envelope" SortExpression="CurrencyTarget_FCNeeded" UniqueName="CurrencyTarget_FCNeeded" FilterControlAltText="Filter CurrencyTarget_FCNeeded column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"> <ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="USDValue" HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue" UniqueName="USDValue" FilterControlAltText="Filter USDValue column" DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Right" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TotalFor500Envelopes" HeaderText="Total<br/>For '500'<br/>Envelopes<br/>On Hand" SortExpression="TotalFor500Envelopes" UniqueName="TotalFor500Envelopes" FilterControlAltText="Filter TotalFor500Envelopes column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Center" BackColor="#CCFFCC" BorderColor="Green"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CurrencyTarget_FCNeeded_100" HeaderText="Enter<br/>Quantity to be Included<br/>for 1 '100'<br/>Envelope" SortExpression="CurrencyTarget_FCNeeded_100" UniqueName="CurrencyTarget_FCNeeded_100" FilterControlAltText="Filter CurrencyTarget_FCNeeded_100 column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"> <ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="USDValue_100" HeaderText="US<br/>Dollar<br/>Value" SortExpression="USDValue_100" UniqueName="USDValue_100" FilterControlAltText="Filter USDValue_100 column" DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum" ReadOnly="True"> <ItemStyle HorizontalAlign="Right" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TotalFor100Envelopes" HeaderText="Total<br/>For '100'<br/>Envelopes<br/>On Hand" SortExpression="TotalFor100Envelopes" UniqueName="TotalFor100Envelopes" FilterControlAltText="Filter TotalFor100Envelopes column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Center" BackColor="#CCCCFF" BorderColor="#6666FF"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TotalForAllEnvelopes" HeaderText="Total<br/>All<br/>Envelopes<br/>On Hand" SortExpression="TotalForAllEnvelopes" UniqueName="TotalForAllEnvelopes" FilterControlAltText="Filter TotalForAllEnvelopes column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CurrencyTarget_OutsideEnvelope" HeaderText="Enter<br/>Total<br/>Outside<br/>the Envelope" SortExpression="CurrencyTarget_OutsideEnvelope" UniqueName="CurrencyTarget_OutsideEnvelope" FilterControlAltText="Filter CurrencyTarget_OutsideEnvelope column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum"> <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" CssClass="maximize"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="AccountingTotalOnHand" HeaderText="Total<br/>Quantity<br/>On Hand<br/>In Accounting" SortExpression="AccountingTotalOnHand" UniqueName="AccountingTotalOnHand" FilterControlAltText="Filter AccountingTotalOnHand column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TotalAllEnvelopesNeeded" HeaderText="Total<br/>All<br/>Envelopes<br/>Needed" SortExpression="TotalAllEnvelopesNeeded" UniqueName="TotalAllEnvelopesNeeded" FilterControlAltText="Filter TotalAllEnvelopesNeeded column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="QuantityToOrder" HeaderText="Quantity<br/>To<br/>Order" SortExpression="QuantityToOrder" UniqueName="QuantityToOrder" FilterControlAltText="Filter QuantityToOrder column" DataType="System.Int32" DataFormatString="{0:#}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Center" BackColor="#FFCCCC" BorderColor="#FF6666" ForeColor="Crimson" Font-Bold="true"></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TotalFCValue" HeaderText="Total<br/>Foreign<br/>Currency<br/>Value" SortExpression="TotalFCValue" UniqueName="TotalFCValue" FilterControlAltText="Filter TotalFCValue column" DataType="System.Int32" DataFormatString="{0:###,##0}" Aggregate="Sum" ReadOnly="True" > <ItemStyle HorizontalAlign="Right" BackColor="#FFCCCC" BorderColor="#FF6666" ></ItemStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TotalUSDValue" HeaderText="Total<br/>USD<br/>Value" SortExpression="TotalUSDValue" UniqueName="TotalUSDValue" FilterControlAltText="Filter TotalUSDValue column" DataType="System.Decimal" DataFormatString="${0:###,##0.00}" Aggregate="Sum" ReadOnly="True"> <ItemStyle HorizontalAlign="Right" BackColor="#FFCCCC" BorderColor="#FF6666"></ItemStyle> </telerik:GridBoundColumn> </Columns> <GroupByExpressions> <telerik:GridGroupByExpression> <SelectFields> <telerik:GridGroupByField FieldAlias="CountryCode" FieldName="Currency_CountryCode" HeaderText="Country Code" /> </SelectFields> <GroupByFields> <telerik:GridGroupByField FieldAlias="Currency_CountryCode" FieldName="Currency_CountryCode" /> </GroupByFields> </telerik:GridGroupByExpression> </GroupByExpressions> <FooterStyle Font-Bold="true" /> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> </telerik:GridTableView> </DetailTables> <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings> <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> <EditFormSettings> <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn> </EditFormSettings> <PagerStyle AlwaysVisible="True" /> <HeaderStyle Font-Bold="True" /> </MasterTableView> <FilterMenu EnableImageSprites="False"></FilterMenu> </telerik:RadGrid> </div> <br /> <telerik:RadButton ID="btnReport" runat="server" style="top: 0px; left: 0px" Text="Summary Report"> </telerik:RadButton> <telerik:RadEditor ID="radPDFReport" Runat="server" Height="114px" Width="685px" ExportSettings-FileName="ForeignCurrencyTotals" Visible="False" Font-Names="Calibri"> <ExportSettings OpenInNewWindow="True"> <Pdf PageHeight="8.5in" PageWidth="11in" AllowAdd="True" AllowCopy="True" AllowModify="True" Title="Foreign Curency Totals" Author="Accounting" Creator="Accounting" PageBottomMargin="45px" PageFooterMargin="18px" PageHeaderMargin="18px" PageLeftMargin="18px" PageRightMargin="18px" PageTopMargin="37px" /> </ExportSettings> <Content>CONTENT</Content> <TrackChangesSettings CanAcceptTrackChanges="False"></TrackChangesSettings> </telerik:RadEditor> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>" UpdateCommand="UPDATE [Currency_LatestConversions_TBL] SET [Currency_EnvelopeCount500] = @Currency_EnvelopeCount500, [Currency_EnvelopeCount100] = @Currency_EnvelopeCount100, [Currency_EnvelopeCount500_Ready] = @Currency_EnvelopeCount500_Ready, [Currency_EnvelopeCount100_Ready] = @Currency_EnvelopeCount100_Ready, [Currency_BriefcaseUsed] = @Currency_BriefcaseUsed, [Currency_HomeOfficeUsed] = @Currency_HomeOfficeUsed, [Currency_OneHundUsed] = @Currency_OneHundUsed, Currency_DisplayOrder = @Currency_DisplayOrder, Currency_LastEdited = GetDate() WHERE [Currency_CountryCode]=@Currency_CountryCode"> <UpdateParameters> <asp:Parameter Name="Currency_CountryCode" /> </UpdateParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:DonPlannerCS %>" SelectCommand="SELECT Currency_Grid.* FROM Currency_Grid WHERE([Currency_CountryCode]=@Currency_CountryCode) ORDER BY CurrencyTarget_ForeignDenomination" UpdateCommand="UPDATE [Currency_TargetAmounts_TBL] SET [CurrencyTarget_FCNeeded] = @CurrencyTarget_FCNeeded, [CurrencyTarget_FCNeeded_100] = @CurrencyTarget_FCNeeded_100, [CurrencyTarget_OutsideEnvelope] = @CurrencyTarget_OutsideEnvelope, [CurrencyTarget_DateUpdated] = GetDate() WHERE [Currency_ID] = @Currency_ID" InsertCommand="INSERT INTO Currency_TargetAmounts_TBL(Currency_Location, CurrencyTarget_CountryCode, CurrencyTarget_ForeignDenomination, CurrencyTarget_FCNeeded, CurrencyTarget_FCNeeded_100, CurrencyTarget_OutsideEnvelope) SELECT 'Accounting' AS Expr1, @Currency_CountryCode AS Expr2, @CurrencyTarget_ForeignDenomination AS Expr3, @CurrencyTarget_FCNeeded AS Expr4, @CurrencyTarget_FCNeeded_100 AS Expr5, @CurrencyTarget_OutsideEnvelope AS Expr6" > <SelectParameters> <asp:SessionParameter DefaultValue="XXX" Name="Currency_CountryCode" SessionField="@Currency_CountryCode" Type="String" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="CurrencyTarget_FCNeeded" /> <asp:Parameter Name="CurrencyTarget_FCNeeded_100" /> <asp:Parameter Name="CurrencyTarget_OutsideEnvelope" /> <asp:Parameter Name="CurrencyTarget_DateUpdated" /> <asp:Parameter Name="Currency_ID" /> </UpdateParameters> <InsertParameters> <asp:Parameter Type="Int32" Name="CurrencyTarget_ForeignDenomination" /> <asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded" /> <asp:Parameter Type="Int32" Name="CurrencyTarget_FCNeeded_100" /> <asp:Parameter Type="Int32" Name="CurrencyTarget_OutsideEnvelope" /> <asp:Parameter Type="DateTime" Name="CurrencyTarget_DateCreated" /> </InsertParameters> </asp:SqlDataSource> </form></body>