Telerik Forums
UI for ASP.NET AJAX Forum
2 answers
192 views
I'm trying to bind date column to RadGrid with auto generated columns. binding works fine but the filter options (contains, equal,..) does not showing up when i click on the filter icon, it just cause a post back. How ever if i bind the date column as a string then it's starts working. whats the issue here?

 <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

        <script type="text/javascript">
        

            function doFilter(sender, eventArgs) {
                if (eventArgs.keyCode == 13) {
                    eventArgs.cancelBubble = true;
                    eventArgs.returnValue = false;
                    if (eventArgs.stopPropagation) {
                        eventArgs.stopPropagation();
                        eventArgs.preventDefault();
                    }
                    var masterTableView = $find("<%= gridSearchL3.ClientID %>").get_masterTableView();
                    var index = sender.parentNode.cellIndex; //index of the current column 
                    var columns = masterTableView.get_columns();
                    var uniqueName = columns[index].get_uniqueName();
                    masterTableView.filter(uniqueName, sender.value, Telerik.Web.UI.GridFilterFunction.Contains);
                }
            }

            
        var columnUniquName = ""; 

            function removeCssClass(className, element) {
                element.className = element.className.replace(className, "").replace(/^\s+/, '').replace(/\s+$/, '');
            }

            function addCssClass(className, element) {
                if (element.className.indexOf(className) < 0) {
                    element.className = element.className + " " + className;
                }
            }
            function onRowClick(sender, eventArgs) {
                var radGrid = sender;
                var index = eventArgs.get_itemIndexHierarchical();
                var dataItem = radGrid.get_masterTableView().get_dataItems()[index];
                var row = dataItem.get_element();
                var checkBox = row.children[0].children[0];
                if (!checkBox.checked) {
                    checkBox.checked = true;
                    addCssClass("rgSelectedRow", row);
                }
                else {
                    checkBox.checked = false;
                    removeCssClass("rgSelectedRow", row);
                }

                CheckHeaderCheckBoxIfNeeded(radGrid);
            }

            function changeAllowPaging() {
                var grid = $find("<%= gridSearchL3.ClientID %>");
                var pagerRow = grid.get_masterTableView().get_element().tFoot;
                pagerRow.style.display = "none";
                grid.MasterTableView.set_pageSize(grid.MasterTableView.PageSize * grid.MasterTableView.PageCount)
                return false;

            } 

            function CheckHeaderCheckBoxIfNeeded(radGrid) {
               
                var checkHeaderCheckBox = true;
                var dataItems = radGrid.get_masterTableView().get_dataItems();
              
                for (var i = 0; i < dataItems.length; i++) {
                    var dataItem = dataItems[i];
                    var row = dataItem.get_element();
                    var ckeckBox = row.children[0].children[0];
                    if (!ckeckBox.checked) {
                        checkHeaderCheckBox = false;
                    }
                }

                SelectCheckBox(checkHeaderCheckBox);
            }

            function setSelectedAfterPostback(rowIDs, rowCount) {
                var arrRowIDs = rowIDs.split(",");
                for (var i = 0; i < arrRowIDs.length - 1; i++) {
                    var row = document.getElementById(arrRowIDs[i]);
                    var checkBox = row.children[0].children[0];
                    checkBox.checked = true;
                    addCssClass("rgSelectedRow", row);
                }
                if (rowCount == arrRowIDs.length - 1) {
                    SelectCheckBox(true);
                }
            }

            function CheckBoxCheckedOnClient(rowID, chechBoxId) {
                var row = document.getElementById(rowID);
                var ckeckBox = document.getElementById(chechBoxId);
                if (ckeckBox.checked) {
                    addCssClass("rgSelectedRow", row);
                }
                else {
                    removeCssClass("rgSelectedRow", row);
                }
                var radGrid = $find("<%= gridSearchL3.ClientID %>");
                CheckHeaderCheckBoxIfNeeded(radGrid);
            }

            function SelectCheckBox(isChecked) {
                var checkBoxID = document.getElementById("<%= HiddenField.ClientID %>").value;
                var checkBox = document.getElementById(checkBoxID);
                checkBox.checked = isChecked;
            }

            function CheckUnCheckAll(id) {
                var sender = document.getElementById(id);
                var grid = $find("<%=gridSearchL3.ClientID %>");
                var dataItems = grid.get_masterTableView().get_dataItems();
                for (var i = 0; i < dataItems.length; i++) {
                    var dataItem = dataItems[i];
                    var row = dataItem.get_element();
                    var checkBox = row.children[0].children[0];
                    if (sender.checked) {
                        checkBox.checked = true;
                        addCssClass("rgSelectedRow", row);
                    }
                    else {
                        checkBox.checked = false;
                        removeCssClass("rgSelectedRow", row);
                    }
                }
            }

               function getColumnCliecked(cu) {  
                columnUniquName = cu;  
                
    }  

            function getPDF(docNum, rev,dochTID) {

                WebService.getFilePath(docNum, rev,dochTID, OnPDFSucceed, OnPDFFailed);
            }

            function OnPDFSucceed(result) {
                //alert(result);
                openPDF(result);
            }

            function OnPDFFailed(err) {
                alert(err);
            }

            function openPDF(file) {
                window.open("OpenPDF.aspx?File=" + file);
            }

            
        </script>

    </telerik:RadCodeBlock>

<telerik:RadGrid ID="gridSearchL3" runat="server" AllowPagg="True"  
             GridLines="None" Skin="Office2007" Height="415px" 
             OnExcelMLExportRowCreated="gridSearchL3_ExcelMLExportRowCreated" OnExcelMLExportStylesCreated="gridSearchL3_ExcelMLExportStylesCreated"
            OnGridExporting="gridSearchL3_GridExporting"  oninit="gridSearchL3_Init" OnNeedDataSource="RadGrid1_NeedDataSource"
            Font-Names="Eras Medium ITC" Font-Size="Small" PageSize="50" 
             AllowFilteringByColumn="True" onitemcreated="gridSearchL3_ItemCreated" 
            OnPageIndexChanged="gridSearchL3_PageIndexChanged"
          OnPageSizeChanged="gridSearchL3_PageSizeChanged"
             onselectedindexchanged="gridSearchL3_SelectedIndexChanged" 

             AllowSorting="True" ShowStatusBar="True" AllowPaging="True" CellSpacing="0" oncolumncreated="gridSearchL3_ColumnCreated1" 
                >
               <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="XX-Small" />
               <GroupingSettings CaseSensitive="False" />
            <ExportSettings Excel-Format="ExcelML" ExportOnlyData="True" 
                FileName="PinC Group" IgnorePaging="True" OpenInNewWindow="True">
                <Excel Format="ExcelML" />
            </ExportSettings>
            <ClientSettings>
                <ClientEvents OnRowClick="onRowClick" OnRowSelected="RowSelected" />
                <Selecting AllowRowSelect="True" />
                <Scrolling AllowScroll="True" UseStaticHeaders="True" />
                    
            </ClientSettings>
            <AlternatingItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <GroupHeaderItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <SortingSettings EnableSkinSortStyles="false" /> 
            <MasterTableView ClientDataKeyNames="Document #,Revision,hID,ID" Font-Names="Eras Medium ITC" 
                   Font-Size="X-Small">
           
                <CommandItemSettings  ExportToPdfText="Export to Pdf" />
                 
                <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                </RowIndicatorColumn>
                <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
                </ExpandCollapseColumn>
                <Columns>
                    <telerik:GridTemplateColumn AllowFiltering="false" UniqueName="template">
                        <ItemTemplate>
                            <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="true" 
                                OnCheckedChanged="ToggleRowSelection" />
                        </ItemTemplate>
                        <HeaderTemplate>
                            <asp:CheckBox ID="CheckBoxHeader" runat="server" AutoPostBack="true" 
                                OnCheckedChanged="Header_checkedChange" />
                        </HeaderTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridButtonColumn CommandName="Select" Text="View" 
                        UniqueName="LinkColumn">
                    </telerik:GridButtonColumn>
                   </Columns>
                <EditFormSettings>
                    <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                    </EditColumn>
                </EditFormSettings>
                <ItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
                <PagerStyle Mode="NextPrevNumericAndAdvanced" />
                <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            </MasterTableView>
            <EditItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <FooterStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <HeaderStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
            <FilterItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <CommandItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <ActiveItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <ItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <PagerStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                   HorizontalAlign="Left" Mode="NextPrevNumericAndAdvanced" />
               <SelectedItemStyle Font-Names="Eras Medium ITC" Font-Size="X-Small" />
               <FilterMenu Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                Skin="Office2007" EnableRoundedCorners="True">
               </FilterMenu>
               <HeaderContextMenu Font-Names="Eras Medium ITC" Font-Size="X-Small" 
                   Skin="Simple">
               </HeaderContextMenu>
               </telerik:RadGrid>

My SQL Query.

select distinct h.DocumentRevisionID 'ID',h.DocumentHeaderID 'hID', h.DocumentNumber 'Document #', h.DocumentTitle 'Document Title',h.Revision as 'Revision',CASE CONVERT(date,[RevisionDate],103)  WHEN '01/01/1991' Then '' else CONVERT(date,[RevisionDate],103) end as 'Rev Date'   from tblDocumentHeader h    
Chamara
Top achievements
Rank 1
 answered on 16 Jul 2013
3 answers
122 views
Hi, I am somewhat new to working with these controls, so I am probably missing something.

We have a project that has multiple RadMultiPage/RadPageView/RadGrid controls. I am trying to implement a context menu for some of the grids to create a cell edit menu item. I have some existing examples and looked at examples on this site. I am seeing a behavior in some grids that when we right-click on empty space of the cell, the menu item shows. But if we right-click on the cell text data, the menu doesn't show at all (only show the browser default conext menu). Strangely, in other grids the exact opposite behavior happens. If we right-click on empty space of a cell, the menu doesn't show. But if we right-click on the text data of the cell, the menu items appear.

I tried searching this forum and didn't find anything matching this issue yet. I have tried comparing the RadContextMenu definition and the grid's ClientSettings/ClientEvents and don't see any major difference. Is this where I should be looking?

Telerik.Web.UI 2012.3.1308.40

Browsers: IE 8, FF 22

Thanks,
kernelk
Top achievements
Rank 1
 answered on 16 Jul 2013
0 answers
151 views
Good Day

I have posted this , but i could not reply to that post, so that is why i am starting a new post . I am using RadAsyncUpload which that is ajaxified. in my Page i have Ajax-toolkit Controls. When i use Telerik Ajax-manager i get a problem. i have attached a link to a Small project that i created that has the problem.

Link to a Problem Project

Thanks
Vuyiswa
Top achievements
Rank 2
 asked on 15 Jul 2013
6 answers
473 views
Hello,

I have a radgrid to which I recently added a history grid button.

<telerik:GridButtonColumn UniqueName="HistoryColumn" HeaderStyle-Width="18px" ButtonType="ImageButton"
      CommandName="History" Text="Get History" ImageUrl="~\Images\history.png">
</telerik:GridButtonColumn>

And I have a server side method in which I want to capture the id of the respective row of the history button and open a report from a report server that shows the history of the item.

Protected Sub RadGrid1_ItemCommand(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles RadGrid1.ItemCommand
If e.CommandName = "History" Then
Dim categoryId As String = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)"UniqueID").ToString
Dim url As String = "link&UniqueID=" & categoryId
End If
End Sub


I have the full URL from another developer and simply want to fire the event to open the URL when the user clicks the history button.  How do I do that?
Craig
Top achievements
Rank 1
 answered on 15 Jul 2013
2 answers
246 views
I'm having some issues setting a rad textbox value. In a JS function, I'm copying the text from a data array and filling the textbox.
var radTbLine = $find('radTbLine' + lineNum);
radTbLine.set_textBoxValue(arrPrevLines[y]);

When I debug the code, I can see the textbox has the new value all the way to the very end of the function. But the next time a function is triggered, the value is gone. When actually triggering this copy, I can see the value flash in the textbox and then immediately disappears. I made a test page with 2 textboxes and had js copy the text from one to the other, and that worked fine. This leads me to think that there is something else resetting my textbox, but since I stepped thru the code, I have no clue what that could be.

Is there any reason why I shouldn't try doing getElementById('radTbLine1_text').value = 'test';?
Josh
Top achievements
Rank 1
 answered on 15 Jul 2013
1 answer
120 views
Hello
when I open a radcombobox and go down the list of data with the scrollbar when I get alal end of the list also moves the scrollbar of the web page. It 'possible that if the focus is on the radcombobox mouse only moves the scrollbar of combo moves that without the web page? The scrollbar of the web page you just have to move if the mouse focus is on the page
Magdalena
Telerik team
 answered on 15 Jul 2013
2 answers
490 views
Hi,
 I am using the Q2 2013 release (2013.2.611.45) version of your controls. On the page I have two databound combos and a grid. The datasource for the grid uses control parameters linked to the two dropdowns. If the grid is in any other EditMode other than Batch, everything works as expected. Both dropdowns have code in the databound event to either select a specific item or add a 'Choose' item.

The grid is empty on initial page load and then once a Form is chosens from the dropdown it then populates with a list of pupils.

If I put the grid into Batch EditMode then when I select a form from the dropdown I get the following error: 

Collection was modified; enumeration operation may not execute.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Collection was modified; enumeration operation may not execute.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Collection was modified; enumeration operation may not execute.]
   System.Web.UI.ControlCollectionEnumerator.MoveNext() +12538578
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +779
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +755
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +755
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +755
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +755
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +755
   Telerik.Web.UI.RadFormDecorator.FindAndDecorateControls(Control parent) +755
   Telerik.Web.UI.RadFormDecorator.ControlPreRender() +761
   System.Web.UI.Control.PreRenderRecursiveInternal() +113
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Control.PreRenderRecursiveInternal() +222
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4297


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18044              


I have tried deleting the grid and rebuilding using the configuration tools, same result. Here is my grid and code behind, also I am using a custom skin set at application level in the web.config and a formdecorator.

<%@ Page Title="Stars Pluses Minuses" Language="C#" MasterPageFile="~/Staff/Staff.master" AutoEventWireup="true"
         CodeFile="StarsPlusMinus.aspx.cs" Inherits="Staff.Reporting.AR.StarsPlusMinus" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="head_staff" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="main_staff" Runat="Server">
    <asp:Panel ID="SelectionPanel" runat="server" CssClass="SelectionPanel">
        <telerik:RadComboBox ID="FormComboBox" runat="server" Label="Form: " Width="150px" CssClass="PupilChooserCombo"
                             AutoPostBack="True" OnDataBound="FormComboBox_OnDataBound" DataSourceID="FormDataSource" DataTextField="DESCRIPTION" DataValueField="CODE">
        </telerik:RadComboBox>
        <telerik:RadComboBox ID="PeriodComboBox" runat="server" Label="Period: " Width="150px"
                             CssClass="PupilChooserCombo" AutoPostBack="True" DataSourceID="PeriodDataSource"
                             DataTextField="PERIOD_NAME" DataValueField="PERIOD_ID" OnDataBound="PeriodComboBox_DataBound">
        </telerik:RadComboBox>
    </asp:Panel>
    <telerik:RadGrid ID="PupilGrid" runat="server" AllowAutomaticUpdates="True" AutoGenerateColumns="False"
        CellSpacing="0" DataSourceID="GridDataSource" GridLines="None">
        <ExportSettings>
            <Pdf>
                <PageHeader>
                    <LeftCell Text=""></LeftCell>
 
                    <MiddleCell Text=""></MiddleCell>
 
                    <RightCell Text=""></RightCell>
                </PageHeader>
 
                <PageFooter>
                    <LeftCell Text=""></LeftCell>
 
                    <MiddleCell Text=""></MiddleCell>
 
                    <RightCell Text=""></RightCell>
                </PageFooter>
            </Pdf>
        </ExportSettings>
 
        <ValidationSettings EnableModelValidation="False" EnableValidation="False" />
 
        <MasterTableView ClientDataKeyNames="LINE_ID" CommandItemDisplay="TopAndBottom" DataKeyNames="LINE_ID" DataSourceID="GridDataSource"
                         EditMode="Batch"  ShowHeadersWhenNoRecords="True">
            <CommandItemSettings ExportToPdfText="Export to PDF" ShowAddNewRecordButton="False" ShowCancelChangesButton="True"
                ShowRefreshButton="False" ShowSaveChangesButton="True"></CommandItemSettings>
 
            <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
                <HeaderStyle Width="20px"></HeaderStyle>
            </RowIndicatorColumn>
 
            <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column" Created="True">
                <HeaderStyle Width="20px"></HeaderStyle>
            </ExpandCollapseColumn>
 
            <Columns>
                <telerik:GridBoundColumn DataField="INFORMAL_NAME" FilterControlAltText="Filter INFORMAL_NAME column" HeaderText="INFORMAL_NAME"
                    ReadOnly="True" SortExpression="INFORMAL_NAME" UniqueName="INFORMAL_NAME">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ReadOnly="True" DataField="ACADEMIC_HOUSE_DESCRIPTION" FilterControlAltText="Filter ACADEMIC_HOUSE_DESCRIPTION column"
                    HeaderText="ACADEMIC_HOUSE_DESCRIPTION" SortExpression="ACADEMIC_HOUSE_DESCRIPTION" UniqueName="ACADEMIC_HOUSE_DESCRIPTION">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn ReadOnly="True"  DataField="FORM_DESC" FilterControlAltText="Filter FORM_DESC column"
                    HeaderText="FORM_DESC" SortExpression="FORM_DESC" UniqueName="FORM_DESC">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="STARS" DataType="System.Decimal" FilterControlAltText="Filter STARS column"
                    HeaderText="STARS"  SortExpression="STARS" UniqueName="STARS">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="PLUSES" DataType="System.Decimal" FilterControlAltText="Filter PLUSES column"
                    HeaderText="PLUSES"  SortExpression="PLUSES" UniqueName="PLUSES">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="MINUSES" DataType="System.Decimal" FilterControlAltText="Filter MINUSES column"
                    HeaderText="MINUSES" ReadOnly="True" SortExpression="MINUSES" UniqueName="MINUSES">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="LINE_ID" DataType="System.Int32" FilterControlAltText="Filter LINE_ID column"
                    HeaderText="LINE_ID" ReadOnly="True" SortExpression="LINE_ID" UniqueName="LINE_ID">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="HEADER_ID" DataType="System.Int32" FilterControlAltText="Filter HEADER_ID column"
                    HeaderText="HEADER_ID" SortExpression="HEADER_ID" UniqueName="HEADER_ID">
                    <ColumnValidationSettings>
                        <ModelErrorMessage Text="" />
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
            </Columns>
 
            <EditFormSettings>
                <EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
            </EditFormSettings>
 
            <BatchEditingSettings EditType="Cell"></BatchEditingSettings>
 
            <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>
        </MasterTableView>
 
        <PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>
 
        <FilterMenu EnableImageSprites="False"></FilterMenu>
    </telerik:RadGrid>
    <asp:SqlDataSource ID="FormDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:PassMainConnectionString %>"
        SelectCommand="usps_SA_GetForms" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ProfileParameter Name="ACADEMIC_YEAR" PropertyName="CurrentAcademicYear" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="PeriodDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:PassMainConnectionString %>"
                       SelectCommand="usps_SA_GetAssessmentPeriods" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ProfileParameter Name="ACADEMIC_YEAR" PropertyName="CurrentAcademicYear" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="GridDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:PassMainConnectionString %>"
                       SelectCommand="usps_SA_GetPupilsForSPMGrid" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:Parameter Name="SCHOOL"  Type="String" DefaultValue="SA"/>
            <asp:ControlParameter ControlID="PeriodComboBox" Name="PERIOD_ID" PropertyName="SelectedValue" Type="Int32" />
            <asp:ControlParameter ControlID="FormComboBox" Name="FORM_CODE" PropertyName="SelectedValue" Type="String" />
            <asp:ProfileParameter  Name="ACADEMIC_YEAR" PropertyName="CurrentAcademicYear" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>

using System;
using System.Linq;
using NLog;
using Telerik.Web.UI;
 
namespace Staff.Reporting.AR
{
    public partial class StarsPlusMinus : System.Web.UI.Page
    {
        private readonly Logger _logger = LogManager.GetCurrentClassLogger();
 
        protected void Page_Error(object sender, EventArgs e)
        {
            Exception ex = Server.GetLastError();
            _logger.Fatal(ex);
            Server.ClearError();
            //store exception to display some details to the user
            Session[Profile.DomainUsername + "LastError"] = ex;
            Response.Redirect("/Staff/StaffError.aspx", true);
        }
 
        protected void Page_Load(object sender, EventArgs e)
        {
        }
 
        protected void PeriodComboBox_DataBound(object sender, EventArgs e)
        {
            if (IsPostBack) return;
            //always select the current period on first visit
            var item = PeriodComboBox.Items.FirstOrDefault(i => i.Text.EndsWith("(*)"));
            if (item != null)
                item.Selected = true;
        }
 
        protected void FormComboBox_OnDataBound(object sender, EventArgs e)
        {
            if (IsPostBack) return;
            FormComboBox.Items.Insert(0, new RadComboBoxItem("Choose ...", "XX") { Selected = true });
        }
    }
}

<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" ControlsToSkip="None" DecoratedControls="All" Skin="MyCustomSkin" />

Any ideas gratefully received.

Thanks

Chris 

Angel Petrov
Telerik team
 answered on 15 Jul 2013
2 answers
239 views
I think is quite a common scenario, so I was wondering if is there a "simple" way to do the sorting and filtering (with NeedDataSource).
Displaying both in a template column is quite straightforward just Trim(Item.LastName & " " & item.FirstName)
Filtering in SQL Server should be something like "WHERE Trim(LastName+' '+FirstName) LIKE... (filter options)"
Sorting of course should be " ORDER BY LastName ASC,FirstName ASC " and " ORDER BY LastName Desc, FirstName Desc"

Any hint?
Massimiliano
Top achievements
Rank 1
 answered on 15 Jul 2013
2 answers
153 views
We have a behavior on our production and UA instances where the charting temp files are not being deleted.  When I attempt to duplicate this on my local and QA instances I see the files being created when I generate a chart but then promptly removed.  However on our other public sites these files are not being deleted.

The directory is ...\OurWebsite\Temp\
The files are named like "chart_19219c2e...a352.png"
The files date back to 3/1/2013 
The telerik version is 2012.03.1017.0

Our first thought was security.  The application pool is using a specific system user.  This system user has full control of the website directory including delete permission on the Temp directory.

  • Can the details of the process using these temp files be explained in hopes of helping where to check next?
  • How are these files automatically deleted, what is the trigger?
  • Are there known reasons that the files would not be deleted?
  • Are there logs to capture the delete errors?  No errors are being raised by the application, we found out when we ran out of space.

Thanks for the help on this one.

-Tim
Jeff
Top achievements
Rank 1
 answered on 15 Jul 2013
3 answers
94 views
i am trying to get a scenario working and am unable to.
THe following works

<asp:Content ContentPlaceHolderID="phContent" runat="server"><br>
<br>
<br>
 <br>
     <script type="text/javascript"><br>
<br>
         function openPOW() {<br>
<br>
             var win2 = $find('ctl00_phContent_winPOW')<br>
             win2.show();<br>
             <br>
        }<br>
<div><br>
</div>
</script><br>
<br>
<br>
        <asp:ScriptManager runat="server"></asp:ScriptManager><br>
        <telerik:RadWindow Behaviors="Maximize,Minimize,Close" Modal="true" AutoSize="true" ID="winPOW" runat="server" Skin="Sitefinity"><br>
            <ContentTemplate><br>
                <iframe style="width:750px;height:450px;" src="../orders/PredictiveOrderDeliveryDates.aspx" id="myframePOW"></iframe><br>
                <br>
                <br>
            </ContentTemplate><br>
        </telerik:RadWindow><br>
  <br>
<input type="button" id="opPOW" onclick="openPOW()" /><br>
</asp:Content>






the following will result in the page refreshing but no RadWindow appearing.
Note that i am having to fill my 'win' variable slightly differently from above, as to do it like above would result in the win variable returning a 'null' value.



<br>
<br>
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;"><asp:Content ContentPlaceHolderID="phContent" runat="server"></font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;"> </font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">     <script type="text/javascript"></font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">         function openPOW() {</font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">               var win = $('ctl00_phContent_winPOW');</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">             win.show();</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">             </font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">        }</font><br style="font-size: 14.399999618530273px;">
<div style="font-size: 14.399999618530273px;"><br>
</div>
<font style="font-size: 14.399999618530273px;"></script></font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">        <asp:ScriptManager runat="server"></asp:ScriptManager></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">        <telerik:RadWindow Behaviors="Maximize,Minimize,Close" Modal="true" AutoSize="true" ID="winPOW" runat="server" Skin="Sitefinity"></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">            <ContentTemplate></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                <iframe style="width:750px;height:450px;" src="../orders/PredictiveOrderDeliveryDates.aspx" id="myframePOW"></iframe></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                </font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                </font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">            </ContentTemplate></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">        </telerik:RadWindow></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">  </font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;"><input type="button" id="opPOW" onclick="openPOW()" /></font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;"></asp:Content></font><br style="font-size: 14.399999618530273px;">
<br>


<br>
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">          Dim lnkPredictiveOrderWizard As New LinkButton</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">            With lnkPredictiveOrderWizard</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                .Text = "Use Predictive Wizard"</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                .ToolTip = "Use a wizard to create order"</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                .CssClass = "menubar_wizard"</font><br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                .ID = "lnkPredictiveOrderWizard"</font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">                AddHandler .Click, AddressOf PredictiveWizard</font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">            End With</font><br style="font-size: 14.399999618530273px;">
<br style="font-size: 14.399999618530273px;">
<font style="font-size: 14.399999618530273px;">            _master.Menubar.Add(lnkPredictiveOrderWizard)</font><br>
<br>
<br>
<br>
 Public Sub PredictiveWizard(ByVal sender As Object, ByVal e As EventArgs)<br>
  Dim jscript As String = "javascript:openPOW();"<br>
<br>
Page.ClientScript.RegisterStartupScript(Me.GetType(), "key", jscript, True)<br>
end sub
David
Top achievements
Rank 1
 answered on 15 Jul 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?